Errors Upserting to Salesforce on ExternalIDs

Six Stars

Errors Upserting to Salesforce on ExternalIDs

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:

error-talend.PNG

 

Can you help?

Moderator

Re: Errors Upserting to Salesforce on ExternalIDs

Hello,

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

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Fifteen Stars TRF
Fifteen Stars

Re: Errors Upserting to Salesforce on ExternalIDs

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.

TRF

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch