Forum Discussion

walkerline117's avatar
walkerline117
Contributor
8 years ago
Solved

Jsonpath to get value with @

I have below json body, how would I use jsonpath in a mapper to get all 'name’s? Its easier for me if the json have ‘name’ instead of ‘@name’… Not sure how to get all those values in a mapper {...
  • tstack's avatar
    tstack
    8 years ago

    I’m not quite sure what you’re asking, can you give an example of the output you want?

    If you’re asking how to reference a field with a special character, like the @ symbol, you can quote it like so:

    ['@name']

    If you want to collect all the ‘@name’ values at any level, you can do:

    jsonPath($, "$..['@name']")

    That will return a list containing all the values.

tstack's avatar
tstack
Former Employee
8 years ago

I’m not quite sure what you’re asking, can you give an example of the output you want?

If you’re asking how to reference a field with a special character, like the @ symbol, you can quote it like so:

['@name']

If you want to collect all the ‘@name’ values at any level, you can do:

jsonPath($, "$..['@name']")

That will return a list containing all the values.

  • walkerline117's avatar
    walkerline117
    Contributor
    8 years ago

    Thanks
    is there a tool that can help us to debug such jsonpath expression, i have tried @name in http://jsonpath.com/
    However, such @name is not valid in this website.

    • jaybodra's avatar
      jaybodra
      New Contributor III
      8 years ago

      I use this one: http://www.jsonquerytool.com/

      {
      “response”: {
      “lst”: [{
      “@name”: “terms”,
      “lst”: {
      “@name”: “user_query”,
      “int”: [{
      “@name”: “solar energy”,
      “$”: “4651”
      }, {
      “@name”: “script”,
      “$”: “1993”
      }, {
      “@name”: “scenario planning”,
      “$”: “641”
      }, {
      “@name”: “strategy under uncertainty framework”,
      “$”: “627”
      }, {
      “@name”: “smed game”,
      “$”: “601”
      }, {
      “@name”: “specialty pharma”,
      “$”: “458”
      }, {
      “@name”: “specialty pharmaceutical”,
      “$”: “446”
      }, {
      “@name”: “specialty care”,
      “$”: “444”
      }, {
      “@name”: “supply chain”,
      “$”: “406”
      }, {
      “@name”: “sap”,
      “$”: “310”
      }
      ]
      }
      }
      ]
      }
      }

      And use this: $[@name] or $.[@name]

      • walkerline117's avatar
        walkerline117
        Contributor
        8 years ago

        thank you for your information

    • tstack's avatar
      tstack
      Former Employee
      8 years ago

      In the SnapLogic Designer, the dropdown for expression properties will fill in the correct path with the appropriate quoting:

      Also, in the Mapper, you can drag the property from the schema view on the left into the expression property and it should do the same: