How to get String value from JSON Array?

Question

I know this has been asked many times but none of the solution provided is working in my case.

Here is my JSON which I am getting as a response from a webservice

{
"size": 1,
"_links": {
"context": "XXXX",
"self": "XXXXXX",
"base": "XXXXXX"
},
"start": 0,
"limit": 50,
"results": [
 {
  "container": {
    "extensions": {
      "position": "none"
    },
    "_links": {
      "webui": "XXXX",
      "tinyui": "XXXX",
      "self": "XXXXXX"
    },
    "id": "XXXXX",
    "type": "page",
    "title": "XXXXX",
    "_expandable": {
      "container": "XXXXX",
      "metadata": "",
      "operations": "",
      "children": "XXXX/child",
      "history": "XXXX/history",
      "ancestors": "",
      "body": "",
      "version": "",
      "descendants": "XXXXX/descendant",
      "space": "XXXXX"
    },
    "status": "current"
  },
  "metadata": {
    "mediaType": "text/plain",
    "comment": ""
  },
  "extensions": {
    "fileSize": 8,
    "mediaType": "text/plain",
    "comment": ""
  },
  "_links": {
    "download": "/download/attachments/XXXXX/MyData1.txt?version=1&modificationDate=1483652732000&api=v2",
    "webui": "XXXXX",
    "self": "XXXXX"
  },
  "id": "attXXXXXX",
  "type": "attachment",
  "title": "MyData1.txt",
  "_expandable": {
    "operations": "",
    "children": "XXXX",
    "history": "XXXXX",
    "ancestors": "",
    "body": "",
    "descendants": "XXXXX",
    "space": "XXXXX"
  },
  "version": {
    "number": 1,
    "minorEdit": false,
    "by": {
      "profilePicture": {
        "path": "XXXXX",
        "isDefault": true,
        "width": 48,
        "height": 48
      },
      "displayName": "XXXXX",
      "type": "known",
      "userKey": "XXXXX",
      "username": "XXXXX"
    },
    "message": "",
    "when": "2017-01-05T16:45:32.000-05:00"
  },
  "status": "current"
}
]
}

I need to find the value of the id which is attXXXXXX and here is my code.

JSONObject page = new JSONObject(pageObj); 
JSONArray jsonArray= page.getJSONArray("results");

for (int i = 0; i < jsonArray.length(); i++) {
JSONObject explrObject = jsonArray.getJSONObject(i);
}

But the above loop just runs once as the lenght of the jsonArray is 1. All the solution provided in other posts are the same i.e. iterating over the json array. Am I missing something ? Suggestion ?

It looks like you're working with java, but you only tagged your question with `json`. Can you include tags for the base technology and json library you are using? — Richard Szalay, Jan 06 '17 at 02:17
If using php Json decode will turn it into a regular php object. You then just reference it by its values at that point. — DEVPROCB, Jan 06 '17 at 02:24

GrabNewTech · Answer 1 · 2017-01-06T04:36:40.720

0

Your JSON string is having only one value in "results" object. So your array size is returning as 1. Which is correct.

If you are expecting more than one array then check the server side code where JSON is built.

Refer to below image for more understanding.

I didn't tested it. Can you try this one. If you got the solution plz up-vote.

JSONObject page = new JSONObject(pageObj); 
JSONArray jsonArray= page.getJSONArray("results");

for (int i = 0; i < jsonArray.length(); i++) {
   JSONObject explrObject = jsonArray.getJSONObject(i);
   explrObject.getString("id")
}

edited Jan 06 '17 at 04:36

answered Jan 06 '17 at 02:34

GrabNewTech

631
6
14

Thanks for making it more clear. Do you have any solution to get the id value ? – Naseem Jan 06 '17 at 02:54
Updated the answer. Plz check. – GrabNewTech Jan 06 '17 at 04:37
Nope... It doesn't find the id value in the first time and second time it come out of the loop because of jsonArray size – Naseem Jan 06 '17 at 15:49

score 0 · Answer 2 · answered Jan 06 '17 at 17:55

0

Ok, So I was able to get the value from the response using Rest Assured API. It's an easy API to get the value from JSON Array. Basically I have to use the following command to get the value

response.path("results.id");

answered Jan 06 '17 at 17:55

Naseem

911
5
18
48

How to get String value from JSON Array?

2 Answers2