topic Re: TSalesforceOutput => Upsert Problem with ExternalID in Talend Studio

TSalesforceOutput => Upsert Problem with ExternalID

PCoste1596533974 — Sat, 16 Nov 2024 01:44:48 GMT

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 ?

Re: TSalesforceOutput => Upsert Problem with ExternalID

manodwhb — Tue, 04 Aug 2020 10:20:04 GMT

@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-references-not-working

Re: TSalesforceOutput => Upsert Problem with ExternalID

AStainer — Tue, 04 Aug 2020 14:25:52 GMT

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.

Re: TSalesforceOutput => Upsert Problem with ExternalID

PCoste1596533974 — Tue, 04 Aug 2020 14:33:26 GMT

Hello,

Re: TSalesforceOutput => Upsert Problem with ExternalID

PCoste1596533974 — Tue, 04 Aug 2020 14:36:30 GMT

Finally, I solve my problem.

On the img, the good maping

Don't forget to check polymorphic

Tell me if you need more help

Re: TSalesforceOutput => Upsert Problem with ExternalID

PCoste1596533974 — Tue, 04 Aug 2020 14:42:37 GMT

look my second post

Re: TSalesforceOutput => Upsert Problem with ExternalID

AStainer — Tue, 04 Aug 2020 14:52:22 GMT

Thanks, I'll try this.