Forum Discussion

NAl's avatar
NAl
Contributor
5 years ago

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

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...
NAl's avatar
NAl
Contributor
5 years ago

del's avatar
del
Contributor III
5 years ago

@NAl,

I believe the Salesforce Upsert snap’s “External-ID Field” and “Related External ID” fields are expecting the actual field names - not the values from the fields. The values should be in your input payload - with matching key names.

Try unchecking the expression toggle “=” and removing the “$”. Or otherwise, uncheck the toggle and use the suggest feature.