Extract values from web service JSON response with JSONPath

Question

I have a JSON response from web service that looks something like this :

[
   {
      "id":4,
      "sourceID":null,
      "subject":"SomeSubjectOne",
      "category":"SomeCategoryTwo",
      "impact":null,
      "status":"completed"  
   },
   {
      "id":12,
      "sourceID":null,
      "subject":"SomeSubjectTwo",
      "category":"SomeCategoryTwo",
      "impact":null,
      "status":"assigned"
   }
]

What I need to do is extract the subjects from all of the entities by using JSONPATH query.

How can I get these results :

Subject from the first item - SomeSubjectOne
Filter on specific subject value from all entities (SomeSubjectTwo for example)
Get Subjects from all entities

Have you read the [original JSONPath article](https://goessner.net/articles/JsonPath/)? After that, you could try solutions out using an [online evaluator](https://jsonpath.herokuapp.com/)? — glyn, Oct 07 '20 at 10:19

score 0 · Answer 1 · answered Oct 12 '20 at 19:25

Goessner's orinial JSONPath article is a good reference point and all implementations more or less stick to the suggested query syntax. However, implementations like Jayway JsonPath/Java, JSONPath-Plus/JavaScript, flow-jsonpath/PHP may behave a little differently in some areas. That's why it can be important to know what implementation you are actually using.

Subject from the first item

Just use an index to select the desired array element.
```
$.[0].subject
```
Returns:

SomeSubjectOne

Specific subject value

First, go for any elements .., check those with a subject [?(@.subject] and use == '..' for comparison.
```
$..[?(@.subject == 'SomeSubjectTwo')]
```

Returns

[ { "id" : 12, "sourceID" : null, "subject" : "SomeSubjectTwo", "category" : "SomeCategoryTwo", "impact" : null, "status" : "assigned" } ]*

Get all subjects
```
$.[*].subject
```
or simply
```
$..subject
```

Returns

[ "SomeSubjectOne", "SomeSubjectTwo" ]

Extract values from web service JSON response with JSONPath

1 Answers1