Getting a single value from a JSON object using JSONPath

json jsonpath
Ilija picture Ilija · May 12, 2014 · Viewed 59.5k times · Source

I have the following JSON and I need to get the plain name value using JSONPath:

{
  "single" : {
    "id" : 1, 
    "name" : "Item name"
  }
}

Expression that I used is $.single.name but I always get an array:

[ "Item name" ]

instead of a string value ("Item name").

Answer

Tim picture Tim · May 13, 2014

but I always get an array:

That is meant to happen. As you can read in this documentation, under 'Result' (almost at the bottom):

Please note, that the return value of jsonPath is an array, which is also a valid JSON structure. So you might want to apply jsonPath to the resulting structure again or use one of your favorite array methods as sort with it.

So basically it will always return an array. If you need the data as an other type, e.g. a String in this case, you will have to do the conversion yourself I'm afraid.

Related questions

How to filter by string in JSONPath?

I have a JSON response from the Facebook API that looks like this: { "data": [ { "name": "Barack Obama", "category": "Politician", "id": "6815841748" }, { "name": "Barack Obama's Dead Fly", "category": "Public figure", "id": "92943557739" }] } I want to apply JSONPath to it to only return results …

Read More
Basic use of JSONPath in Java

I have JSON as a string and a JSONPath as a string. I'd like to query the JSON with the JSON path, getting the resulting JSON as a string. I gather that Jayway's json-path is the standard. The online API, …

Read More
Parse JSON array file with JSONPATH

I want to parse this with JSONPath: [ [50.4154134372953,-1.28486558931069,"CLASS B",9,205,0,"UK",431500382,3,4], [50.3058858494047,-0.976070494820637,"CLASS B",9,239,0,"UK",2750350,21,2] ] Can you help with that please?

Read More