cancel
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

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.

10 REPLIES 10

Supratim
Contributor III

@NAl Looks like even through you have defined external id, it is evaluating as null value from snap. Is that hardcoded value ? If not just double check your expression (=) is enable for external id field or not.

NAl
Contributor

Hi there, the External Id isnโ€™t hardcoded. In the output preview, there is a valid value

jlandells
Former Employee

Can you post a screenshot of the expression, please?

NAl
Contributor

sure,
Screen Shot 2021-07-28 at 11.58.37 AM