How to access a JSON Array response using JsonPath?

Question

How to handle when REST service response is returned as Json Array: for e.g:

[{"boolField":true,"intField":991, "StringField":"SampleString"},
 {"boolField":false, "intField":998, "StringField": "SampleString2"}]";

All the blogs & examples I have seen didn't deal with the scenario mentioned above. For example, I went through http://goessner.net/articles/JsonPath/ expression syntax, but couldn't locate the solution.

For example the following json, if I want to get all the authors, I can use $.store.book[*].author or $..author

{ "store": {
    "book": [ 
      { "category": "reference",
        "author": "Nigel Rees",
        "title": "Sayings of the Century",
        "price": 8.95
      },
      { "category": "fiction",
        "author": "Evelyn Waugh",
        "title": "Sword of Honour",
        "price": 12.99
      }]}
}

However, if the REST service response is returned like below, then how to get all authors from the list

[
  { "category": "reference",
    "author": "Nigel Rees",
    "title": "Sayings of the Century",
    "price": 8.95
  },
  { "category": "fiction",
    "author": "Evelyn Waugh",
    "title": "Sword of Honour",
    "price": 12.99
   }
]

josephpconley · Accepted Answer · 2016-01-04 15:06:38Z

3

$..author will retrieve all of the authors.

In general when your root object is an array, you can think of the $ as an array and do things like $[0] to inspect the first item (You'll still get an array back however).

answered Jan 4, 2016 at 15:06

josephpconley

1,72312 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

josephpconley Over a year ago

I tested it at jsonpath.curiousconcept.com and got the array of authors back, what results do you get?

parishodak Over a year ago

java.lang.IllegalArgumentException: The parameter "author" was used but not defined. Define parameters using the JsonPath.params(...) function

when I use $..author. If i use $.author an empty [] is returned. If I use $ alone, I am getting the list.

parishodak Over a year ago

I tried in jsonpath.curiousconcept.com, and it resulted in An unknown error has occured. I am at least able to proceed and not blocked, as I am getting $ result as list.

Maruthi · Accepted Answer · 2017-11-24 19:26:02Z

0

In my case [0].author worked (I left out the $).

answered Nov 24, 2017 at 19:26

Maruthi

4801 gold badge4 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to access a JSON Array response using JsonPath?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related