topic Talend nullifies values of Relationship fields in output files in Talend Studio

Talend nullifies values of Relationship fields in output files

KamSH — Fri, 15 Nov 2024 21:14:32 GMT

So I have a question regarding the Output results after loading in data through the tSalesforceOutputBulkExec component.

Lets says my files that I have passed through it contains two columns with values that are actually the External_Id of other Salesforce objects

The fields contain values, but in my result files, regardless if it is an Error or Success file, the Lookup values are always removed. Why is this happening?

Sample Error file

An answer to this is highly appreciated

Re: Talend nullifies values of Relationship fields in output files

Anonymous — Tue, 21 Nov 2023 08:02:13 GMT

Hello

Is this a file output the rejected rows? Before tSalesforceOutputBulkExec, use a tLogRow to print the value on the console to see if the filed contains value?

Regards

Shong

Re: Talend nullifies values of Relationship fields in output files

KamSH — Tue, 21 Nov 2023 08:22:47 GMT

Hi Shong,

Thanks for the reply.

Yea Using a tLogRow, all the column contains value.

What I did was switch to using the non-bulk Component, tSalesforceOutput.

Using this component, the result files are able to contain the Lookup Values, like so:

This sounds very much like a Salesforce Issue instead of a Talend one when attempting to load records via their Bulk API