Get list of string from list of Json object

Question

I am trying to extract list of string from following Json

"example":{[
{"@name":"name1"},
{"@name":"name2"},
{"@name":"name3"},
{"@name":"name4"}
]}

I want to get the list of @name values. I am using jayway jsonpath to do this.

I tried the following code,

List<String> response = null;
    try{
      ReadContext ctx = JsonPath.parse(data);
      response = ctx.read(xPath);
    }catch(Exception e){
      AppLogger.EventLogger.error(e.getMessage());
      response = null;
    }
    return response;

but got an exception saying could not find the specified path. I have used the following jsonPath example.@name

Can someone tell me What went wrong in my code? how to extract list @name values.

Expected output :

[name1,name2,name3,name4]

First of all it doesn't look like valid json...

rohitanand
– rohitanand

2017-07-19 06:57:41 +00:00
Commented Jul 19, 2017 at 6:57 — rohitanand
– rohitanand, Commented Jul 19, 2017 at 6:57
@SouravGanguly, Thanks. but consider it is valid Json :)

backtrack
– backtrack

2017-07-19 07:19:07 +00:00
Commented Jul 19, 2017 at 7:19 — backtrack
– backtrack, Commented Jul 19, 2017 at 7:19

maiorovi · Accepted Answer · 2017-07-19 07:21:11Z

2

I have made small changes to your json in order to make it valid.

{"example":[
{"@name":"name1"},
{"@name":"name2"},
{"@name":"name3"},
{"@name":"name4"}
]}

and the code which specified works perfectly fine with the following expression: $.example[*].@name

There are a lot of online services which can help validate your json. One of them is jsonlint.com

I would also recommend to look at json.org.

edited Jul 19, 2017 at 7:21

answered Jul 19, 2017 at 7:16

maiorovi

811 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

Get list of string from list of Json object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related