I'm seeking to populate a joiner desk in salesforce from data in a database. The joiner desk has two lookups (of course to two exclusive items).
My waft begins from querying a database. The question fetches have two fields nt_account & cxm_id - those exist as separate gadgets in salesforce so I need to research salesforce to get their corresponding salesforce IDs to create a report in my joiner desk. I am no longer certain of the precise manner to do this
Below is the waft I've which takes nt_account and did a query against sf to get its id in sfdc and create the joiner report. Now my question is what's the right manner to populate the alternative loop in my joiner that is (a look up on sfdc for cxm_id in a database). Will it be a good choice to query for cxm_id in sfdc for its corresponding SFDC id and combine each payload and pass it on creating (if yes any pointers on a way to try this will help)?
<db:select config-ref="Generic_Database_Configuration" doc:name="Database">
<db:parameterized-query><![CDATA[SELECT NT_ACCOUNT,CXM_ID from Table where lastmodifieddate = 'within last 24 hours';]]></db:parameterized-query>
<sfdc:query-single config-ref="Salesforce__Basic_authentication1" query="dsql:#["SELECT id FROM FM_Account__c WHERE account_number__c = '"+payload.NT_ACCOUNT+"' LIMIT 1"]" doc:name="Salesforce"/>
<batch:commit size="200" doc:name="Batch Commit">
<data-mapper:transform config-ref="Map_To_Map_1" doc:name="Map To Map"/>
<sfdc:create config-ref="Salesforce__Basic_authentication1" type="Joiner_Table__c" doc:name="Salesforce">
<logger message="#[message.payload]" level="INFO" doc:name="Logger"/>
Subscribe to get latest updates