topic Re: Salesforce to Salesforce Transfer Records in Talend Studio

Salesforce to Salesforce Transfer Records

Anonymous — Sat, 16 Nov 2024 09:39:51 GMT

Hi Community,

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!

Re: Salesforce to Salesforce Transfer Records

TRF — Wed, 07 Jun 2017 20:50:50 GMT

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.

Re: Salesforce to Salesforce Transfer Records

Anonymous — Wed, 07 Jun 2017 21:33:12 GMT

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.

Any ideas?

Re: Salesforce to Salesforce Transfer Records

TRF — Wed, 07 Jun 2017 22:21:14 GMT

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).

Re: Salesforce to Salesforce Transfer Records

Anonymous — Wed, 14 Jun 2017 07:32:52 GMT

Hello @sflknight

A record owner, or any user above the owner in the role or territory hierarchy, can transfer a salesforce single record to another user.

Transfer multiple records by selecting the records from a list view and clicking Change Owner
Transfer multiple records using the Mass Transfer tool

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.

Thanks.