Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
EV89
Contributor III
Contributor III
‎2021-03-05 05:22 AM

Salesforce - tSalesforceoutputbulkExec - Relationship mapping for upsert - no match

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

Labels (2)
Labels
1 user say ditto
141 Views
0 Likes
1 Reply
kholio_ak
Contributor
Contributor
‎2021-03-28 12:24 PM

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

130 Views
0 Likes