topic Re: Salesforce Lookup in Talend - tSalesforceOutput upsert in Talend Studio

Salesforce Lookup in Talend - tSalesforceOutput upsert

Anonymous — Sat, 16 Nov 2024 07:59:22 GMT

Hi all,
I am beginner on Talend.
i created a standard job for importing data into Salesforce using upsert.

I want to make a lookup on the table RecordType to get the id corresponding to the type of my input stream
ex: type = "physical person" I want to retrieve the corresponding id, in other words I want the id corresponding to type = RecordType.Name.

I'm using the tSalesforceOutput i know that i can do this in advanced settings,
if possible i don't want to make it with tMap and tSalesforceInput.

what should I put in the columns so that I can do my lookup.

Tanks in advance

Re: Salesforce Lookup in Talend - tSalesforceOutput upsert

manodwhb — Mon, 09 Jul 2018 08:50:12 GMT

@sandbox_talend,

Column name of Talend Schema : Input column

Lookup Filed Name : lookup filed type

Module name:- the Object which you were doing lookup

Exteral id name:- Id filed from the Lookup Modudule.

please check below link.

https://help.talend.com/reader/9q55KsfASqX0qY4GVhEDNQ/oBYwPezWk9VAMEum2kcyNQ

Re: Salesforce Lookup in Talend - tSalesforceOutput upsert

manodwhb — Tue, 17 Jul 2018 06:08:06 GMT

@sandbox_talend,did it help you?

Re: Salesforce Lookup in Talend - tSalesforceOutput upsert

Anonymous — Tue, 17 Jul 2018 10:48:21 GMT

Hello,
sorry I was a little busy, I found another solution is to do it in two stages, I have not yet managed to do it but I'm on the way thank you.

https://help.talend.com/reader/8BHX9tH5qcw~5xM6p58OTg/c~1aO3bj_CwodjPYoXfqxQ

Sofiane.