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?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.