How to upsert data from excel to salesforce object using Talend Open Studio Integration Tool? - Forcetalks

Tagged: Excel, Excel Connector, Salesforce Object Query Language, Salesforce Objects, Talend, Talend Open Studio Integration Tool, Upsert Data

Salesforce® Discussions

How to upsert data from excel to salesforce object using Talend Open Studio Integration Tool?

Posted by akash shinde on April 28, 2018 at 7:12 PM

Can you please explain the process, how to upsert data from excel to salesforce where upsert key column: Name(Standard field).

shariq replied 7 years, 8 months ago 2 Members · 1 Reply
1 Reply

shariq

Member
September 13, 2018 at 11:28 PM

Hi,

The minimalist design by your question looks like tFileInputExcel–>tSalesforceOutput.
For this component you need a field declared as an External Id used by salesforce to decide the action (insert or update) for each record.

Hope this helps.

Log In to reply.