Unable to do a salesforce lookup

hzainuddin2002 — Sat, 16 Nov 2024 06:16:09 GMT

I'm doing an upsert to a salesforce object using tSalesforceOutput. I have a field on the object which is a lookup field.

The field is called Production_Unit__c the object that it looked up to is also called Production_Unit__c with an External_Id__c

Ive build out my job and whenever I try to run I'm getting an error

I've attached screenshot for both the error and the relationship mapping for the upsert

Please assist

failed to release the resource in tSalesforceOutput_1 :com.sforce.ws.SoapFaultException: Element or attribute do not match QName production: QName::=(NCName':')?NCName.

Re: Unable to do a salesforce lookup

TRF — Sun, 24 Mar 2019 09:16:01 GMT

Did you try to populate the "Lookup field name" with "Product_Unit__c" and "Lookup relationship field name" with "Product_Unit__r"?

topic Unable to do a salesforce lookup in Talend Studio

Unable to do a salesforce lookup

Re: Unable to do a salesforce lookup