https://community.qlik.com/t5/Talend-Studio/Salesforce-tSalesforceoutputbulkExec-Relationship-mapping-for/m-p/2329916#M99055 <P>Hi,</P><P>&nbsp;</P><P>Unfortunately, Salesforce will keep throwing this error message as long as it can't find the external ID in the Account entity.</P><UL><LI>Have you tried to write just "Account" in the Lookup relation field?</LI></UL><P>&nbsp;</P><P>Best regards</P> Sun, 28 Mar 2021 16:24:02 GMT kholio_ak 2021-03-28T16:24:02Z https://community.qlik.com/t5/Talend-Studio/Salesforce-tSalesforceoutputbulkExec-Relationship-mapping-for/m-p/2329915#M99054 <P>hi gurus,</P><P></P><P></P><P>i am trying to use the advanced settings in salesforce connector, but when i define the Relationship mapping for upsert i got records discarded if an external code has no match in salesforce.</P><P></P><P></P><P>Any idea to have the lookup field empty if there is not match with external code and the other fields upserted?</P><P></P><P></P><P></P><P></P><P>my error:</P><P>INVALID_FIELD:Foreign key external ID: 310713 not found for field ID_Cliente__c in entity Account:--"</P><P></P><P></P><P>my settings.</P><P>see attached screenshot</P><P></P><P></P><P>Any help is really appreciated</P> Fri, 05 Mar 2021 10:22:26 GMT https://community.qlik.com/t5/Talend-Studio/Salesforce-tSalesforceoutputbulkExec-Relationship-mapping-for/m-p/2329915#M99054 EV89 2021-03-05T10:22:26Z https://community.qlik.com/t5/Talend-Studio/Salesforce-tSalesforceoutputbulkExec-Relationship-mapping-for/m-p/2329916#M99055 <P>Hi,</P><P>&nbsp;</P><P>Unfortunately, Salesforce will keep throwing this error message as long as it can't find the external ID in the Account entity.</P><UL><LI>Have you tried to write just "Account" in the Lookup relation field?</LI></UL><P>&nbsp;</P><P>Best regards</P> Sun, 28 Mar 2021 16:24:02 GMT https://community.qlik.com/t5/Talend-Studio/Salesforce-tSalesforceoutputbulkExec-Relationship-mapping-for/m-p/2329916#M99055 kholio_ak 2021-03-28T16:24:02Z