topic tSalesforceOutputBulk link Custom object to User (via OwnerId) in Talend Studio

tSalesforceOutputBulk link Custom object to User (via OwnerId)

Anonymous — Sat, 16 Nov 2024 09:35:39 GMT

Hi guys,

I work on a custom object called Dossier__c.
And I'm trying to fill in the Owner Id with the External Id of the user (IdentifiantUnique__c). I'm going to the advanced setting of the tSalesforceOutputBulk component :

And when I try to run my Job I have the issue "Invalid Job"

For information I try this manip on the Account Object with the same configuration and it worked perfectly.

Someone has an Idea ?

Thanks !

Elliot

Re: tSalesforceOutputBulk link Custom object to User (via OwnerId)

TRF — Fri, 23 Jun 2017 17:38:35 GMT

Hi,

Everything looks fine with the relationship configuration.

Are you sure the problem is with this field? What if you remove this operation?

You can also get some more details from Salesforce (if the flow has been pushed to Salesforce).

Connect to Salesforce, Setup, Bulk Data Load Jobs, click on the desired JobID (7509E00000xxxxx), scroll down to the Batches list then look at the State Message for the Failed batch.

You should find something like "InvalidBatch : Field name not found : xxxxxxx_c".

Let us know.

Re: tSalesforceOutputBulk link Custom object to User (via OwnerId)

Anonymous — Mon, 26 Jun 2017 08:52:26 GMT

Hi TRF,

Thanks for your quick answer, yes I'm sure the problem is with this field because when I remove it, records are processed successfully ! On the bulk data Load page I have this error message :

Thank you very much
Have a nice day,

Elliot

Re: tSalesforceOutputBulk link Custom object to User (via OwnerId)

TRF — Mon, 26 Jun 2017 09:22:19 GMT

Hi,

Tick the option "Polymorphic", like in my case:

Re: tSalesforceOutputBulk link Custom object to User (via OwnerId)

Anonymous — Mon, 26 Jun 2017 09:35:51 GMT

TRF,

It works perfectly !

Thanks for your help

I am sending you my best wishes for the future,
Bye,
Elliot

Re: tSalesforceOutputBulk link Custom object to User (via OwnerId)

TRF — Mon, 26 Jun 2017 21:23:28 GMT

Great!

@lli, can you mark the case as solved, for people searching an answer to the same case.

Kudos are also welcome as incentive - we can't eat them, but never mind, we like it anyway!