Extract multiple values from a JSON using JSONPath

Question

I'd like to extract, using JSONPath, some values from a JSON like this one

{
"key": "value",
"array": [
    {
        "key": 1,
        "item": "a",
        "cod": 123
    },
    {
        "key": 2,
        "item":"b",
        "cod": 345
    },
    {
        "key": 3,
        "item": "c",
        "cod": 126
    }
]

}

I'd like to extract "key" AND "cod" values ....

I'm trying to use this JSONPath filter $.array[*]['key','item'] but it doesn't work.

Is it possible? Any suggestions? Thank you in advance!

Serge · Accepted Answer · 2022-07-22 19:04:08Z

4

this works for me

$.array[*].key,item

you just selected a wrong website , try this https://jsonpath.com/ for example or better create java script code. You jsonPath is working here

console.log(jsonPath(arr,("$.array[*]['key','item']")));

output

[
  1,
  "a",
  2,
  "b",
  3,
  "c"
]

edited Jul 22, 2022 at 19:04

answered Jul 22, 2022 at 18:15

Serge

44.4k4 gold badges26 silver badges53 bronze badges

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

4 Comments

ArtBindu Over a year ago

$.array[*]['key','item'] This is not working at jsonpath.com

Serge Over a year ago

@ArtBindu Thanks, you are right. it only works in the code

ArtBindu Over a year ago

I saw a different issue in the different compilers: jsonpath.com. $.array[*].key,item is not working here. See the same observation at site24x7.com/tools/json-path-evaluator.html Also, seeing different types of compilers send us different types of answers. So, can you suggest me best compiler to understand JSON path coding deeply.

Serge Over a year ago

@ArtBindu There are different jsonPath libraries. And they work different. I don't know what OP uses, I am not sure that he knows it too.

Cesare · Accepted Answer · 2022-07-27 16:08:53Z

1

Starting from the @Serge reply (thanks ...), I've retried using https://www.jsonquerytool.com/ that I've used in my initial test BUT changing the transformation used (JSONPath Plus (4.0.0) in this case, and its' working now

answered Jul 27, 2022 at 16:08

Cesare

1,75710 gold badges36 silver badges77 bronze badges

Collectives™ on Stack Overflow

Extract multiple values from a JSON using JSONPath

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related