Salesforce - tSalesforceoutputbulkExec - Relationship mapping for upsert - no match

[EV89]

hi gurus,

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.

Any idea to have the lookup field empty if there is not match with external code and the other fields upserted?

my error:

INVALID_FIELD:Foreign key external ID: 310713 not found for field ID_Cliente__c in entity Account:--"

my settings.

see attached screenshot

Any help is really appreciated

[kholio_ak]

Hi,

Unfortunately, Salesforce will keep throwing this error message as long as it can't find the external ID in the Account entity.

• Have you tried to write just "Account" in the Lookup relation field?

Best regards