How to find value of given key from json using JsonPath?

Question

I have searched a lot but no answer helped what I want.

[{
    "activity_id": 1,
    "created_date": 104,
    "note_id": 1
}, {
    "activity_id": 2,
    "created_date": 101,
    "note_id": 2
}, {
    "activity_id": 3,
    "created_date": 105,
    "note_id": 3
}, {
    "activity_id": 4,
    "created_date": 102,
    "note_id": 4
}, {
    "activity_id": 5,
    "created_date": 103,
    "note_id": 5
}]

DocumentContext dc =  JsonPath.parse(data);

I have tried to get key d.read(key) but it didn't work as it gives an array of values.

How can I get an array of all values of a particular key? There is one thing to add more. I can get array of all values using d.read("$..created_date") But I have to make generic functions so I will take the key name as a parameter and I have to find all values of that given key.

For example: created_date: [101, 102, 103..]

I tried using Jackson also. I cannot use a library other than this.

Any help will be appreciated.

Sri · Accepted Answer · 2020-04-16 09:23:02Z

2

Hope this code works for your requirement

Code:

import java.util.List;

import com.jayway.jsonpath.JsonPath;

public class TestJsonPath {

    public static void main(String[] args) {
        String key = "created_date";
        testJsonPath(key);
    }

    private static void testJsonPath(String key) {

        String json = "{\"list\" : { \"time\": [{\"activity_id\":1,\"created_date\":104,\"note_id\":1},{\"activity_id\":2,\"created_date\":101,\"note_id\":2},{\"activity_id\":3,\"created_date\":105,\"note_id\":3},{\"activity_id\":4,\"created_date\":102,\"note_id\":4},{\"activity_id\":5,\"created_date\":103,\"note_id\":5}] } }";
        System.out.println(json);
        List<Object> createdDate = JsonPath.read(json, String.format("$.list.time[*].%s", key));
        System.out.println(createdDate);

    }

}

edited Apr 16, 2020 at 9:23

answered Apr 16, 2020 at 8:12

Sri

4361 gold badge4 silver badges13 bronze badges

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

4 Comments

Mahesh Chand Over a year ago

Thanks for the response. I found the values using $..created_date. I have updated this in question as well. But I will get key value from parameters so I have no idea What will be there it could be note_id, activity_id or created_date

Sri Over a year ago

@MaheshChand U get compare key & value using this stackoverflow.com/questions/43798853/… and once u get the proper key value match , write on method and pass that key to "JsonPath.read(json, "$.list.time[*].<<key>>");"

Mahesh Chand Over a year ago

Thanks again but this I am getting JSON from third party API. I can't modify it. So can you help me without using time or list. Even I am able to find d.key("$..created_date") .

Mahesh Chand Over a year ago

Hey, thanks you have helped me a lot. I found a way to do this. Modify your answer I will give you points. d.read(String.format("$..%s", sortingKey)) sortingKey is that key which holds the value.

Collectives™ on Stack Overflow

How to find value of given key from json using JsonPath?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related