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
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: Salesforce Lookup in Talend - tSalesforceOutput upsert

@sandbox_talend,did it help you? 

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
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)

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads