topic Re: Errors Upserting to Salesforce on ExternalIDs in Talend Studio

Errors Upserting to Salesforce on ExternalIDs

Anonymous — Sat, 16 Nov 2024 07:40:24 GMT

Hi folks,

I created a solid process that uploads a lot of data into our salesforce org, but when I try to connect the objects via external IDs that I set, it keeps saying "MALFORMED ID".

The sequence I'm using is this:

CSV --> tmap --> tSalesforceOutputBulk --> tSalesforceBulkExec ---> tLogRow

Which is working for all file upserts that don't try to link objects via external IDs.

Process & errors pictured here:

Can you help?

Re: Errors Upserting to Salesforce on ExternalIDs

Anonymous — Mon, 17 Sep 2018 07:51:48 GMT

Hello,

Could you please try to link the tFileInputDelimited component to the tSalesforceBulkExec component using a Trigger > OnSubjobOk connection?

Best regards

Sabrina

Re: Errors Upserting to Salesforce on ExternalIDs

TRF — Mon, 17 Sep 2018 08:15:36 GMT

1rst I suggest you to use tSalesforceOutputBulkExec component as soon as data flow is made in a single step.
For the error, share the Advanced Settings where you establish the relation between parent and child objects.