Updating Salesforce Contact records upon Account external IDs
Procedure
Double-click the fourth tSalesforceOutput component to
open its Basic settings view on the
Component tab.
Select the component that will create the Salesforce connection from the
Connection Component drop-down list,
tSalesforceConnection_1 in this example.
Click the [...] button next to the Module
Name field and in the pop-up dialog box, select the object into
which data will be inserted, Contact in this example. The
schema of the Contact object will be automatically filled.
Click the [...] button next to Edit
schema and in the pop-up dialog box, remove all schema columns
except the three columns Phone,
Email, and
talendlena__Contact_Talend_ID__c. Then add another
column Account_External_ID of String type and copy these
four columns to the second tFixedFlowInput component.
When done, click OK to close the dialog box.
Select UPSERT from the Output
Action drop-down list and
talendlena__Contact_Talend_ID__c from the
Upsert Key Column drop-down list displayed.
Go to the Advanced settings view and in the
Relationship mapping for upsert table, specify the
relationship mapping for the column Account_External_ID
by adding one row and setting the value for each table column. In this example,
the column Account_External_ID is mapped with the
external ID field talendlena__Account_External_ID__c of
the Account object, so the value for Column name of Talend
Schema is Account_External_ID, the value
for Lookup relationship field name and Module
name is Account, and the value for
External id name is
talendlena__Account_External_ID__c.
Double-click the third tFixedFlowInput component to open
its Basic settings view on the
Component tab.
In the Mode area, select Use Inline
Table and in the table displayed, enter the data used to update
the two records inserted into the Salesforce Contact object. In this example,
the updated data is as follows. The phone and email values will be added for
both two records and the Account external ID value for the second record is
updated to account_talend_doc_exid.
