Mapper Snap : Help with JsonPath

Question

Hi
I appreciate some help in transform the attached input to the attached output.
I have tried using the mapper snap with the following expression
$person.jive.profile[?(value.jive_label == ‘Country’)].value
$person.jive.profile[?(jive_label == ‘Country’)].value
And is getting syntax error.
input.txt (636 Bytes)
output.txt (191 Bytes)

nganapathiraju · Answer

The correct way is like this
Country:
jsonPath($, "$person.jive.profile[?(@.jive_label=='Country')].value")[0]

Company:
jsonPath($, "$person.jive.profile[?(@.jive_label=='Company Name')].value")[0]

But, since it will get an array of values, you would want to grap the index 0.
Let me know if this helps!!

daisytam · Answer

This works.
jsonPath($, “$person.jive.profile[?(value.jive_label==‘Country’)].value”)[0]

daisytam · Answer

So ‘Country’ sometimes does not exist. How do I deal with that use case?

daisytam · Answer

I solved the problem with
jsonPath($, “$person.jive.profile[?(value.jive_label==‘Country’)].value”).length &gt; 0 ? jsonPath($, “$person.jive.profile[?(value.jive_label==‘Country’)].value”)[0] : null

nganapathiraju · Answer

Another way
jsonPath($, "$person.jive.profile[?( @.jive_label=='Country' &amp;&amp; @.value != '' )].value").toString()

Forum Discussion

Mapper Snap : Help with JsonPath

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

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