Parse JSON array file with JSONPATH

Question

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?

I want to know the JSONPATH e.g. $.* to get any item of the array. — Kheiri, Feb 15 '12 at 13:18
So you want to use JSONPath, whose implementations for several languages are available at http://code.google.com/p/json-path/ and http://goessner.net/articles/JsonPath/ — ArjunShankar, Feb 15 '12 at 14:47

score 50 · Accepted Answer · edited May 08 '14 at 16:47

If the object is:

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

Then "$[0]" will return:

[50.4154134372953,-1.28486558931069,"CLASS B",9,205,0,"UK",431500382,3,4]

And "$[1]" will return:

[50.3058858494047,-0.976070494820637,"CLASS B",9,239,0,"UK",2750350,21,2]

You can do it two levels deep as well. "$[0][4]" will return:

You can also extract the elements of the array into a list with "$[*]", which will return a list of 2 elements. The first being:

[50.4154134372953,-1.28486558931069,"CLASS B",9,205,0,"UK",431500382,3,4]

and the second being:

[50.3058858494047,-0.976070494820637,"CLASS B",9,239,0,"UK",2750350,21,2]

score 0 · Answer 2 · answered May 18 '14 at 11:42

Using DefiantJS, you can search a JSON structure with XPath syntax. This library extends the global object JSON with a search function.

In this scenario, you can write something like this;

var data = [
  [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]
],
search = JSON.search( data, '//*/*/*' );

Check out this fiddle; http://jsfiddle.net/hbi99/5NfeM/

score 0 · Answer 3 · edited Nov 15 '18 at 14:46

0

This works for me

JsonPath.with(jsonResponse).param("name", "getName").get("findAll { a -> a.name == name  }")

edited Nov 15 '18 at 14:46

Walery Strauch

6,792
8
50
57

answered Apr 04 '16 at 10:02

Jayen Chondigara

387
4
3

Parse JSON array file with JSONPATH

3 Answers3