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)

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog