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.
+86 13666666666;beckham.david@talend.com;2018010001;account_talend_exid +86 13888888888;taylor.swift@talend.com;2018010002;account_talend_doc_exidYou can also select Use Inline Content, and then copy and paste the input data into the Content field displayed.