tsalesforceOutput not updating data with externalID

[JavierP2]

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.

[Anonymous]

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-upsert...

Best regards

Sabrina