Salesforce Lookup in Talend - tSalesforceOutput upsert

[Anonymous]

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

[manodwhb]

@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

[manodwhb]

@sandbox_talend,did it help you? 

[Anonymous]

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.