Updating Salesforce Contact records upon Account external IDs - 7.3


Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Talend Studio
Data Governance > Third-party systems > Business applications > Salesforce components
Data Quality and Preparation > Third-party systems > Business applications > Salesforce components
Design and Development > Third-party systems > Business applications > Salesforce components


  1. Double-click the fourth tSalesforceOutput component to open its Basic settings view on the Component tab.
  2. Select the component that will create the Salesforce connection from the Connection Component drop-down list, tSalesforceConnection_1 in this example.
  3. 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.
  4. 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.
  5. Select UPSERT from the Output Action drop-down list and talendlena__Contact_Talend_ID__c from the Upsert Key Column drop-down list displayed.
  6. 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.
  7. Double-click the third tFixedFlowInput component to open its Basic settings view on the Component tab.
  8. 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_exid

    You can also select Use Inline Content, and then copy and paste the input data into the Content field displayed.