I am working on a process in Talend Open Studio for Big Data that will transfer a set of records into another Salesforce org. I then want it to go back to the original Salesforce org and update the successful records statuses to "transmitted".
The problem is when there are errors. If one of the records fails to insert into Delphi, the job stops and won't update anything. If I turn off "cease on error" it will update all the record's statuses (even failed ones).
Any ideas on how I can have the process only update the successfully inserted records status? Thanks in advance!
Right click on tSalesforceOutput component to catch Main flow (inserted records) and memorize inserted records into a tHashOutput.
After the tFileInputExcel, add a tMap with a lookup with inner join based on the inserted records (using tHashInput associated to the previous tHashOutput).
This will give you the list of source records to be updated.
Thank you for your reply!
I added what you recommended, but it appears to be sending all records (both inserted success and fails) to the tHashOutput.
Well, I didn't try...
Use Reject link instead of main then reverse the logic in tMap (set "Catch lookup inner join reject" to true for tMap output flow).
A record owner, or any user above the owner in the role or territory hierarchy, can transfer a salesforce single record to another user.
Users with the “Modify All Data” permission, or users with the “Modify All” permission for the given object, can transfer any record, regardless of who owns the record.
Hope it helps you.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Find out how to migrate from one database to another using the Dynamic schema
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences