Filter names from Json object/array using jsonpath query

Question

I am trying to extract all name from computerScience and electronics using json path query

my input json is

{
  "computerscience": [
    {
      "name": "john doe",
      "grade": "B",
      "year": "4"
    },
    {
      "name": "Bjarne Stroustrup",
      "grade": "A",
      "year": "4"
    },
    {
      "name": "Dennis Ritchie",
      "grade": "A",
      "year": "4"
    }
  ],
  "someProp1": "false",
  "someProp2": "dirSync",
  "electronics": [
    {
      "name": "thomas edison",
      "grade": "B",
      "year": "4"
    },
    {
      "name": "nichola tesla",
      "grade": "B",
      "year": "4"
    }
  ]
}

I want to figure out json path which give me below result

["john doe", "Bjarne Stroustrup", "Dennis Ritchie" , "thomas edison", "nichola tesla"]

I want to extract names from only computerScience and electronics

I am trying few jsonpaths here but it won't work

Can you also post the few jsonpath that you have tried which won’t work? — Akshay G
– Akshay G, Commented Feb 7, 2022 at 22:41

Kevin Perry · Accepted Answer · 2022-02-08 00:36:22Z

3

This pattern works:

$.[computerscience,electronics][*].name

This simpler pattern works as long as there aren't any other properties that you want to avoid selecting the names from:

$.*[*].name

Or if you really just want to collect all the names in the document, there's:

$..name

edited Feb 8, 2022 at 0:36

answered Feb 8, 2022 at 0:28

Kevin Perry

5413 silver badges6 bronze badges

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

2 Comments

Kevin Perry Over a year ago

And of course I should have mentioned, these operators are documented here: github.com/json-path/JSONPath#operators

Akshay G Over a year ago

As per the documentation of Jayway JSONpath the query should look like $.['computerscience','electronics'][*].name . The names of the properties should be enclosed within single quotes. Try here jsonpath.herokuapp.com

Collectives™ on Stack Overflow

Filter names from Json object/array using jsonpath query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related