topic Get Salesforce ID in Talend Studio

Get Salesforce ID

Anonymous — Sat, 16 Nov 2024 10:59:00 GMT

I need realize this simple flow:
1) I must read records from a mysql table
2) I must insert this data (i can use tMap) in Salesforce object
3) I must update the opriginally record in mysql table with salesforce record ID
What I can do? how can I get the salesforce id and update table column of originally record?
Can you help me?
Benny

Re: Get Salesforce ID

Anonymous — Thu, 22 Oct 2015 11:29:20 GMT

Hi,
From you description, you can design your job as:
tMySqlInput(read records from a mysql table)-->tMap(further processing)-->tSalesforceOutput(insert this data in Salesforce).

3) I must update the opriginally record in mysql table with salesforce record ID

Could you please set an example with input and expected output for us?
Best regards
Sabrina

Re: Get Salesforce ID

Anonymous — Thu, 22 Oct 2015 15:51:18 GMT

Hi Sabrina,
in the image you can see an example of expected output

Re: Get Salesforce ID

Anonymous — Mon, 26 Oct 2015 16:05:55 GMT

Hi,
hello, have you some news for me?
P.s. please ... please ... :rolleyes::rolleyes:

Re: Get Salesforce ID

tamilselvan1 — Wed, 12 Feb 2020 23:07:49 GMT

any solution ?

Re: Get Salesforce ID

TRF — Thu, 13 Feb 2020 06:40:12 GMT

Clear Extend Insert checkbox From Advanced Settings then tick Retrieve Insert Id option.
This will have you salesforce ids after Insert operation. Then you can update original records.