Mapper Snap JSON expression

Question

I have a mapper Snap to map address from left to right schema.
However, when I run it, I see this error:

Meaning the jsonPath($, “$address[0].state”) path cannot be found meaning state = null.
Is there any way I could write JSON expression in the Mapping table part in a Mapper Snap?
Please help!

dmiller · Answer

Select Null-safe access in the Mapper Snap.

dmiller · Answer

It sounds like one record in your data set does not have a value for State.

jcornelius · Answer

Just write it like this
jsonPath($, “$address[0].state”) ? jsonPath($, “$address[0].state”) : null

snapintegration · Answer

Yes. How do I pass the null value?

Forum Discussion

Mapper Snap JSON expression

4 Replies

Recent Discussions

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found

Unable to write sldb file to file system