topic Re: upsert into salesforce in Talend Studio

upsert into salesforce

Anonymous — Sat, 16 Nov 2024 08:16:50 GMT

Can you please explain how to upsert data from excel file to salesforce. The salesforce object has no lookup field. Just need to upsert on single object with an external custom/standard field. How to design talend job for this case?

Re: upsert into salesforce

TRF — Sat, 12 May 2018 21:09:16 GMT

The minimalist design 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.

Re: upsert into salesforce

Anonymous — Sun, 13 May 2018 16:04:14 GMT

I done it like TFileInputExcel ==> tMap ==> tSalesforceOutput(External Id).

It is upserting data correctly into salesforce. Thanks for reply.

But after executing talend job, giving exception: java.io.IOException: Name not specified - here Name is standard field (Upsert key column).

Re: upsert into salesforce

TRF — Sun, 13 May 2018 20:44:46 GMT

Can you share your tSalesforceOutput settings with schema?