08-12-2022 12:03 PM
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!
08-12-2022 12:06 PM
It sounds like one record in your data set does not have a value for State.
08-12-2022 12:13 PM
Yes. How do I pass the null value?
08-12-2022 12:15 PM
Select Null-safe access in the Mapper Snap.
08-16-2022 03:05 PM
Just write it like this
jsonPath($, “$address[0].state”) ? jsonPath($, “$address[0].state”) : null