How to extract a subset of json array from value in sub array, in java?

Question

Following is my json :

{
    "id": null,
    "extId": "720916740",
    "legacyId": null,
    "customerId": null,
    "accountId": null,
    "clientId": null,
    "publisherId": null,
    "name": "AllColumns1_1482141239819",
    "status": "ACTIVE",
    "operationStatus": null,
    "startDate": "20180101",
    "endDate": null,
    "channel": "SEARCH",
    "lastSyncDate": null,
    "linkStatus": "NOT_LINKED"
  },
  {
    "id": null,
    "extId": "720916743",
    "legacyId": null,
    "customerId": null,
    "accountId": null,
    "clientId": null,
    "publisherId": null,
    "name": "AllColumns2_1482141239819",
    "status": "ACTIVE",
    "operationStatus": null,
    "startDate": "20180101",
    "endDate": null,
    "channel": "SEARCH",
    "lastSyncDate": null,
    "linkStatus": "NOT_LINKED"
  },
  {
    "id": null,
    "extId": "720933833",
    "legacyId": null,
    "customerId": null,
    "accountId": null,
    "clientId": null,
    "publisherId": null,
    "name": "2TestCamp2_1482149078243",
    "status": "ACTIVE",
    "operationStatus": null,
    "startDate": "20180101",
    "endDate": null,
    "channel": "SEARCH",
    "lastSyncDate": null,
    "linkStatus": "NOT_LINKED"
  }

From above json, I want to get id and extid of where name is "2TestCamp2_1482149078243". How can I get this in JAVA ?

In general, From a json array, first I want to find that sub-array, where value is "2TestCamp2_1482149078243"; and then from that sub-array, get values of keys id and ext id.

Thanks. Would be great if someone helps me in this. I am new to java and json.

Possible duplicate of [How to parse JSON in Java](http://stackoverflow.com/questions/2591098/how-to-parse-json-in-java) — Pavneet_Singh, Feb 05 '17 at 14:13
By sub-array, you mean JSON object right? Are you already manipulating a `JsonArray` ? You might want to add the `[]` around the JSON you've posted because it currently isn't a valid JSON value. — Aaron, Feb 05 '17 at 14:14

score 0 · Answer 1 · answered Feb 07 '17 at 08:39

String validate_name="2TestCamp2_1482149078243";

JSONObject object = new JSONObject(YOUR-JSON-Object);
JSONArray getArray = object.getJSONArray("Result");

for(JSONObject value:getArray)  //For Each loop to iterate the Objects from JSONArray
{
    if(value.getString("name").equals(validate_name))
    {
        value.getString("id");
        value.getString("extId");
    }
}

How to extract a subset of json array from value in sub array, in java?

1 Answers1