topic Re: Upsert into Salesforce using 2 columns in Talend Studio

Upsert into Salesforce using 2 columns

Anonymous — Sat, 16 Nov 2024 02:26:22 GMT

Hello Team,

We are trying to replace IBM BlueWolf integrator with Talend for salesforce integration.

I have simple requirement to UPSERT a module in Salesforce based on 2 fields from a source file. in tsalesforceoutput for UPSERT operation we have dropdown to select single field, however my requirement UPSERT need to be performed based on 2 field. There is lookup simple upsert from the file to saleforce.

Please let me know your suggestion.

@TRF - Please suggest, as i have seen you answering many Salesforce related questions

Thanks - Gopi

Re: Upsert into Salesforce using 2 columns

manodwhb — Fri, 15 May 2020 08:18:54 GMT

@Gopik , you need to use Relationship mapping for upsert in tsalesforceoutput.

https://help.talend.com/reader/~JrHURluxR5dMtQmHpZHGg/9b8t40yZo3Wp4PVuNCAEyA

Re: Upsert into Salesforce using 2 columns

Anonymous — Fri, 15 May 2020 11:49:44 GMT

Re: Upsert into Salesforce using 2 columns

TRF — Fri, 15 May 2020 12:51:20 GMT

Salesforce API give you the possibility to use Upsert operation with only one search field which could be the standard record id or an external ID. Nothing else.

Re: Upsert into Salesforce using 2 columns

Anonymous — Tue, 19 May 2020 15:13:40 GMT

@TRF- Can you please brief me on Salesforce AP ? I am looking for some capability or work around for upsert using 2 columns in Talend.

Regards,

Gopi

Re: Upsert into Salesforce using 2 columns

TRF — Tue, 19 May 2020 15:23:29 GMT

As I said, this not possible due to Salesforce API capabilities.
If you have actually 2 fields A and B, the only work around is to declare a custom technical field on salesforce side which you'll populate with A + B (A + "_" + B better for readability).
This field must also be declared as an external ID (others are not required anymore) and you'll use it on Talend side for the Upsert operation.
Is that clear for you?

Re: Upsert into Salesforce using 2 columns

TRF — Sat, 23 May 2020 10:07:14 GMT

Did this help? If so, thanks to mark your case as solved (Kudo also accepted)

Re: Upsert into Salesforce using 2 columns

Anonymous — Sun, 24 May 2020 02:12:19 GMT

@TRF - Thanks for the reply, We already have this design, I was looking for any option in Talend directly without making changes to the Salesforce like adding extra column.

Re: Upsert into Salesforce using 2 columns

TRF — Sun, 24 May 2020 07:40:41 GMT

Talend itself is limited by Salesforce's limits.
In other words, the train runs the same speed as the slower coach.
Thanks to mark your case as solved.