Parsing a JSON array into Object (Nested JSON)

Question

I have a JSON File like this -

{
  "users": [
    {
      "displayName": "Amanda Polly",
      "givenName": "Amanda",
      "surname": "Polly",
      "extension_user_type": "user",
      "identities": [
        {
          "signInType": "emailAddress",
          "issuerAssignedId": "[email protected]"
        }
      ],
      "extension_timezone": "PST",
      "extension_locale": "en-US",
      "extension_tenant": "EG1234"
    },
    {
      "displayName": "Lowa Doe",
      "givenName": "Lowa",
      "surname": "Doe",
      "extension_user_type": "user",
      "identities": [
        {
          "signInType": "userName",
          "issuerAssignedId": "lowadow123"
        }
      ],
      "extension_timezone": "PST",
      "extension_locale": "en-US",
      "extension_tenant": "EG1234"
    }
   ]
}

If you can see there are 2 users (Amanda and Lowa) wrapped inside an array "users". I parsed the file and converted all of this into a single string.

Now I am trying to iterate through all the fields like displayName, givenName, surname and so on! but if you see identities is again a wrapper for "signInType" and "issuerAssignedId".

I wrote a code that iterates through all the users but I am not able to get "identites" field. Below is my code:

Here the parameter for JSONObject is jsonAsString (which is my string that has the above JSON), now I created a JSONArray and pass the wrapper "users".

the below code is working fine but can someone please help in iterating through "identites" field for each user.

JSONObject jsonObject = new JSONObject(jsonAsString);
org.json.JSONArray jsonArray = jsonObject.getJSONArray("users");

System.out.println(jsonArray.length());

for(int i = 0; i< jsonArray.length();i++)
{
        displayName = jsonArray.getJSONObject(i).getString("displayName");
        givenName = jsonArray.getJSONObject(i).getString("givenName");
        surname = jsonArray.getJSONObject(i).getString("surname");
        extension_user_type = jsonArray.getJSONObject(i).getString("extension_user_type");
        
        
        try
        {
            extension_timezone = jsonArray.getJSONObject(i).getString("extension_timezone");
            extension_locale = jsonArray.getJSONObject(i).getString("extension_locale");
            extension_tenant = jsonArray.getJSONObject(i).getString("extension_tenant");
        }
        catch(JSONException e)
        {
            System.out.println("\nSome attribute was not found!");
        }
        
        System.out.println("\ndisplayName : "+displayName);
        System.out.println("\ngivenName : "+givenName);
        System.out.println("\nsurname : "+surname);
        System.out.println("\nextension_user_type : "+extension_user_type);
        System.out.println("\nextension_timezone : "+extension_timezone);
        System.out.println("\nextension_locale : "+extension_locale);
        System.out.println("\nextension_tenant : "+extension_tenant);

Put your JSON into this site to convert it into the appropriate C# data classes, and then just use Root deserialized = JsonConvert.DeserializeObject(myJson); to deserialize the whole thing — Robert Harvey
– Robert Harvey, Commented Aug 24, 2020 at 14:11
I actually wanted to to it in similar way, but due to constraints, i can not. Howerver next time i will use this way for sure, since this is a better approach — Sharad esdee Dutta
– Sharad esdee Dutta, Commented Aug 24, 2020 at 18:29

Surya Gaikwad · Accepted Answer · 2020-08-24 15:41:27Z

Use below code :

JSONObject jsonObject = new JSONObject(jsonAsString); org.json.JSONArray jsonArray = jsonObject.getJSONArray("users");

System.out.println(jsonArray.length());

for(int i = 0; i< jsonArray.length();i++)
{
        displayName = jsonArray.getJSONObject(i).getString("displayName");
        givenName = jsonArray.getJSONObject(i).getString("givenName");
        surname = jsonArray.getJSONObject(i).getString("surname");
        extension_user_type = jsonArray.getJSONObject(i).getString("extension_user_type");

        org.json.JSONArray jsonIdentitiesArray = jsonArray.getJSONObject(i).getJSONArray("identities");
        for(int j = 0; j< jsonIdentitiesArray.length();j++)
        {
            String signInType=jsonIdentitiesArray.getJSONObject(j).getString("signInType");
             System.out.println("signInType : "+signInType);
            String issuerAssignedId=jsonIdentitiesArray.getJSONObject(j).getString("issuerAssignedId");
             System.out.println("issuerAssignedId : "+issuerAssignedId);
        }
        
        try
        {
            extension_timezone = jsonArray.getJSONObject(i).getString("extension_timezone");
            extension_locale = jsonArray.getJSONObject(i).getString("extension_locale");
            extension_tenant = jsonArray.getJSONObject(i).getString("extension_tenant");
        }
        catch(JSONException e)
        {
            System.out.println("\nSome attribute was not found!");
        }
        
        System.out.println("\ndisplayName : "+displayName);
        System.out.println("\ngivenName : "+givenName);
        System.out.println("\nsurname : "+surname);
        System.out.println("\nextension_user_type : "+extension_user_type);
        System.out.println("\nextension_timezone : "+extension_timezone);
        System.out.println("\nextension_locale : "+extension_locale);
        System.out.println("\nextension_tenant : "+extension_tenant);

Ariks · Accepted Answer · 2020-08-24 15:16:33Z

1

i think you can achieve that by doing the same process that you did with the user json arr, for each user use get function to get the identities json array and iterate it for each user.

JSONObject currentUserJsonObj = (JSONObject)jsonArray.getJSONObject(i);

JSONArray idnts=(jsonArray)(currentUserJsonObj.get("identities"));

edited Aug 24, 2020 at 15:16

answered Aug 24, 2020 at 14:44

Ariks

1186 bronze badges

Collectives™ on Stack Overflow

Parsing a JSON array into Object (Nested JSON)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related