โ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