tsalesforceOutput not updating data with externalID

JavierP2 — Fri, 15 Nov 2024 21:12:30 GMT

Hi there,

i would like to move some jobs that i'm doing with dataloader.io to talend as they go faster, i've been able to move some jobs and they are working nice, but for update an specific table who has external ID, this is not working.

This is the config that i have fot the external id at dataloader

so in talend i do have this config.

I have mapped at t_map component the field orderlin__c to referenceuk__c (UK to map when doing upsert). I've tried all combinations but it doenst work,

With the posted config this is the error that i have :

java.io.IOException: com.sforce.ws.SoapFaultException: Element or attribute do not match QName production: QName::=(NCName':')?NCName.

any ideas or suggestions?

thanks a lot.

Re: tsalesforceOutput not updating data with externalID

Anonymous — Mon, 04 Dec 2023 07:56:18 GMT

Hello,

Please check you do have the visibility on that field on Salesforce side. As the Module name must contain the target object name, is your "Producto_Pedido_c" the salesforce object which you want to do Upsert?

https://help.talend.com/r/en-US/8.0/salesforce/tsalesforceinput-tsalesforceconnection-tlogrow-upserting-salesforce-data-based-on-external-ids-standard-component-the-job

Best regards

Sabrina

topic Re: tsalesforceOutput not updating data with externalID in Talend Studio

tsalesforceOutput not updating data with externalID

Re: tsalesforceOutput not updating data with externalID