topic Re: tSalesforceOutput upsert problem in Talend Studio

tSalesforceOutput upsert problem

Anonymous — Wed, 22 Aug 2018 11:17:12 GMT

While attempting to transfer data from Microsoft SQL Server to Sales force I am getting the below error:-

I tried using the upsert action and entered the upsert key column as one of customized field named 'SfId__c'. The error is as shown below:-

exceptionMessage = 'sObjecttype ' ' is not supported.If you are attempting to use a custom object , be sure to append the '__c' after the entity name'.

Re: tSalesforceOutput upsert problem

TRF — Wed, 22 Aug 2018 11:23:51 GMT

Check you have the visibility on that field on Salesforce side

Re: tSalesforceOutput upsert problem

Anonymous — Wed, 22 Aug 2018 12:01:20 GMT

Yes , checked it is having visibility on Salesforce side

Re: tSalesforceOutput upsert problem

TRF — Wed, 22 Aug 2018 12:15:23 GMT

Share your component settings

Re: tSalesforceOutput upsert problem

Anonymous — Wed, 22 Aug 2018 12:29:33 GMT

Re: tSalesforceOutput upsert problem

TRF — Wed, 22 Aug 2018 13:33:21 GMT

Module name must contain the target object name

Re: tSalesforceOutput upsert problem

Anonymous — Thu, 23 Aug 2018 05:20:27 GMT

Hello,

Can you please explain, target object name means?

Re: tSalesforceOutput upsert problem

manodwhb — Thu, 23 Aug 2018 05:29:46 GMT

@ruchita366,target object means on the object which you wan to do Upsert logic.

Re: tSalesforceOutput upsert problem

manodwhb — Thu, 23 Aug 2018 05:55:43 GMT

@ruchita366,check the below link to know more about tSalesforceOutput.

https://help.talend.com/reader/9q55KsfASqX0qY4GVhEDNQ/roH3~9ht_XXQfMql8oG3dQ

Re: tSalesforceOutput upsert problem

TRF — Thu, 23 Aug 2018 07:18:21 GMT

In the component settings, the field "Module name" must contain the Salesforce object name you want to address. For example, "Account" or "YourObject__c" (including the double quotes).

Re: tSalesforceOutput upsert problem

TRF — Thu, 23 Aug 2018 23:15:04 GMT

Did this help?
If so, thank's to mark your case as solved (Kudos also accepted).