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?
Could you please try to link the tFileInputDelimited component to the tSalesforceBulkExec component using a Trigger > OnSubjobOk connection?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.