TSalesforceOutput => Upsert Problem with ExternalID

[PCoste1596533974]

Hello everybody,

Thanks for your help...

I would like upsert Task with the What field and Owner Field

My DD :

Account-> ExternalID__c

User --> ExternalID__c

In advanced settings of TSalesforceOutputBulkExec what i have to write ?

• Column name of Talend Schema
  • WhatId
  • OwnerId
• Lookup relationship field name.
  • "What"
  • "Owner"
• Module Name
  • "Account"
  • "User"
• External ID Name
  • "ExternalID__c"
  • "ExternalID__c"

It doesn't work..

Exception in component tSalesforceOutputBulkExec_1_tSalesforceBulkExec (ExternalID2)

org.talend.components.api.exception.ComponentException: UNEXPECTED_EXCEPTION

Any Idea ?

[manodwhb]

@Philippe Coste​ , check the below link,may be your lookup table is not configured correctly.

https://salesforce.stackexchange.com/questions/63371/upsert-to-salesforce-with-external-id-reference...

[AStainer]

Hello. Write here or ping me please if it is not difficult for you to write how your problem was solved. I have similar problems. I tried to find the answer here - https://www.ergonized.com/blog/steps-to-implement-salesforce/ but I still haven't figured it out. Please look, maybe you will understand what needs to be done.

[PCoste1596533974]

Hello,

[PCoste1596533974]

Finally, I solve my problem.

On the img, the good maping

Don't forget to check polymorphic

Tell me if you need more help

[PCoste1596533974]

look my second post

[AStainer]

Thanks, I'll try this.