Skip to content

Instantly share code, notes, and snippets.

@adrianhsieh
Created September 22, 2012 21:26
Show Gist options
  • Select an option

  • Save adrianhsieh/3767890 to your computer and use it in GitHub Desktop.

Select an option

Save adrianhsieh/3767890 to your computer and use it in GitHub Desktop.
Demo how to select records sorted
<flow name="mainFlow" doc:name="mainFlow" processingStrategy="synchronous">
<file:inbound-endpoint path="src/test/resources" moveToDirectory="src/test/archives" responseTimeout="10000" doc:name="Input File"/>
<jdbc-ee:csv-to-maps-transformer ignoreFirstRecord="true" doc:name="CSV to Maps" mappingFile="src/main/resources/mules-csv-format.xml"/>
<foreach doc:name="Foreach">
<logger message="#[payload]" level="INFO" doc:name="csv record" />
<jdbc-ee:outbound-endpoint exchange-pattern="one-way" queryKey="insertRecord" queryTimeout="-1" connector-ref="apache-derby" doc:name="insert-record"/>
</foreach>
<jdbc-ee:outbound-endpoint exchange-pattern="request-response" queryKey="selectRecord" queryTimeout="-1" connector-ref="apache-derby" doc:name="select records"/>
<sfdc:upsert config-ref="salesforce" externalIdFieldName="External_ID__c" type="Demo_Object__c" doc:name="upsert.record.in.salesforce">
<sfdc:objects ref="#[payload]"/>
</sfdc:upsert>
</flow>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment