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.
07-28-2021 03:28 AM
@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.
07-28-2021 03:52 AM
Hi there, the External Id isn’t hardcoded. In the output preview, there is a valid value
07-28-2021 03:57 AM
Can you post a screenshot of the expression, please?
07-28-2021 03:59 AM
sure,