Forum Discussion

walkerline117's avatar
walkerline117
Contributor
9 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
    9 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
9 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
9 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
    9 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
      9 years ago

      thank you for your information

  • tstack's avatar
    tstack
    Former Employee
    9 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: