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

{
“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”}]}}
]
}
}

Thanks

  • 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.

6 Replies

  • 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]