Mapper Snap JSON expression

[SnapIntegration]

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]

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

[SnapIntegration]

Yes. How do I pass the null value?

[dmiller]

Select Null-safe access in the Mapper Snap.

[jcornelius]

Just write it like this

jsonPath($, “$address[0].state”) ? jsonPath($, “$address[0].state”) : null