tSalesforceOutputBulk link Custom object to User (via OwnerId)

Four Stars

tSalesforceOutputBulk link Custom object to User (via OwnerId)

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 : 
outpubulk1.JPG


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


Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

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

Hi,

 

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

Capture.PNG


TRF

All Replies
Fifteen Stars TRF
Fifteen Stars

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

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.

 


TRF
Highlighted
Four Stars

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

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 : 
invlidbatch.jpg

 

Thank you very much
Have a nice day,

Elliot

Fifteen Stars TRF
Fifteen Stars

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

Hi,

 

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

Capture.PNG


TRF
Four Stars

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

TRF,

It works perfectly ! 

Thanks for your help Smiley Happy 

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

Fifteen Stars TRF
Fifteen Stars

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

Great!

@ElliotCathy, 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!


TRF

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 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog