Forum Discussion

DaisyTam's avatar
DaisyTam
New Contributor
8 years ago

Mapper Snap : Help with JsonPath

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 == ‘Co...
DaisyTam's avatar
DaisyTam
New Contributor
8 years ago

This works.

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

  • DaisyTam's avatar
    DaisyTam
    New Contributor
    8 years ago

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

    • DaisyTam's avatar
      DaisyTam
      New Contributor
      8 years ago

      I solved the problem with

      jsonPath($, “$person.jive.profile[?(value.jive_label==‘Country’)].value”).length > 0 ? jsonPath($, “$person.jive.profile[?(value.jive_label==‘Country’)].value”)[0] : null

      • nganapathiraju's avatar
        nganapathiraju
        Former Employee
        8 years ago

        Another way

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