Upserting the emails into the Contact object upon the external ID
matching
-
Double-click the second tFixedFlowInput
component to open its Basic settings
view.
-
Click the […] button next to Edit schema and in the pop-up schema dialog box,
define the schema by adding four columns Email, AccountBizLicense,
AccountID and LastName of String type.
Click OK to save the changes and close the
dialog box. -
In the Mode area, select Use Inline Content (delimited file) and enter the
data below in the Content field.12andy@talend.com;Paris888;FR888;Andyanderson@talend.com;C.A.666;US666;Anderson -
Double-click the second tSalesforceOutput
component to open its Basic settings
view.
-
In the drop-down list next to the Property
Type drop-down list, select the tSalesforceConnection component to reuse the connection created
by it. -
Click the […] button next to the Module Name field and in the pop-up dialog box,
select the object you want to access. In this example, it is Contact. -
Select UPSERT from the Output Action drop-down list, and then Email from the Upsert Key
Column drop-down list. -
Go to the Advanced settings view to set the
relationship mapping.
Click the [+] button below the Relationship mapping for upsert table to add two
lines.Click the cells under the Column name of Talend
Schema column and from the drop-down list select AccountBizLicense and AccountID respectively.Enter the lookup relationship fields in the Lookup field
name column, Account and
Account__r respectively.Enter the lookup module names in the Module
name column, Account for the
both.Enter the external ID fields in the External id
name column, AccountBizLicense__c and AccountID__c respectively, which are the customized fields (with
the external ID attribute) in the Account
object.Note that Column name of Talend Schema refers
to the fields in the schema of the component preceding tSalesforceOutput. Such columns are intended to match against
the external ID fields specified in the External id
name column, which are the fields of the lookup module specified
in the Module name column. Lookup field name refers to the lookup relationship
fields of the module selected from the Module
list in the Basic settings view. They are
intended to establish relationship with the lookup module specified in the
Module name column. For how to define the
lookup relationship fields and how to provide their correct names in the
Lookup field name column, go to the
Salesforce website and launch the Salesforce Data Loader application for proper
actions and information.
Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Login
0 Comments