topic Re: Update Salesforce Object only if specific criteria match in Talend Studio

Update Salesforce Object only if specific criteria match

udotheman — Sat, 16 Nov 2024 05:08:25 GMT

Hi guys,

I'm new in Talend and I have a question regarding updating a Salesforce (custom) object only if specific criteria match.

My basic configuration looks as follow:

So I get every data I want from the Input and the maps looks also good. Lets say I have a custom Object Foo__c on the Salesforce site and there is a field called: MyId__c.

Is it possible to update a Foo__c record only if MyId__c is empty?

As far as I understand this, is not possible with the expression editor within the tMap component right?

Best,

udotheman

Re: Update Salesforce Object only if specific criteria match

sayzol — Mon, 29 Jul 2019 15:18:42 GMT

Not that I'm aware of. If you want to perform a check on the data before it's updated, you can bring in the Salesforce data (via tSalesforceInput) and join it to your source data to exclude records you don't want pushed to Salesforce.

Re: Update Salesforce Object only if specific criteria match

udotheman — Mon, 29 Jul 2019 17:51:54 GMT

Thx for the quick answer.

I already thought that this would be the "correct" way. Thx anyway!