Salesforce Lookup in Talend - tSalesforceOutput upsert

Four Stars

Salesforce Lookup in Talend - tSalesforceOutput upsert

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. upsert.PNG
Tanks in advance
Thirteen Stars

Re: Salesforce Lookup in Talend - tSalesforceOutput upsert

@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

Manohar B
Thirteen Stars

Re: Salesforce Lookup in Talend - tSalesforceOutput upsert

@sandbox_talend,did it help you? 

Manohar B
Four Stars

Re: Salesforce Lookup in Talend - tSalesforceOutput upsert

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.
Tags (1)