This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
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: 

Failure: Related External ID: Cannot lookup a property on a null value, Reason: Value referenced in the sub-expression

NAl
Contributor

‎07-28-2021 02:20 AM

Hi all,

I am trying to conduct an upsert operation on a child record in Salesforce.
I have defined the External ID for the record and the related object but keep receiving this message:

Failure: Related External ID: Cannot lookup a property on a null value, Reason: Value referenced in the sub-expression

The null-safe access has been checked in each of the mapper snaps.

0 Kudos
Reply
10 REPLIES 10

rohitdhiman
New Contributor

‎11-15-2021 03:50 AM

I also faced a similar issue, the issue is with the value “$” in External-ID field, in real it is expecting the name of the object against you want to do upsert , so no the value ,

0 Kudos
Reply