Talend nullifies values of Relationship fields in output files

[KamSH]

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

[Anonymous]

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

[KamSH · Accepted solution]

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