Hello everyone, I am pretty new to Talend and I am trying to design a job which queries Salesforce using the output record of the tmap. For context, in the tmap, I am checking to see if the external ID field of the incoming record is null. If it is not null, I perform the upsert directly using tSalesforceOutput component to Contact object. If the External ID field is null, then I would like to query Salesforce using the incoming record's firstname and lastname combination, get the external Id,assign it to incoming record and perform an upsert operation. But I am not able to query the Salesforce using the fields of the record coming out of the tmap. I would very much appreciate any suggestions on how I should go about designing this job.
Solved! Go to Solution.
Hi TRF, thanks for the reply. I have set up the flow as per what you suggested. For now, I am trying with just tFlowToIterate and TsaleforceInput to understand how everything works. The issue is, when I execute the job, tSalesforceInput is querying for all the contact records. How can can I limit it to query only for the records coming in from tFlowToIterate component?