How to parse this format of JSON using Gson

Question

I am having Json in this format

{
    "Sheet1":
        [
            {
                "Title":"facebook",
                "Link":"facebook.com"
            },{
                "Title":"gmail",
                "Link":"mail.google.com"
            }
        ]
}

When I try to convert it using pojo I am getting two classes and I am not able to implement there is force close error Please Help me out.

Possible duplicate of [How to Parse JSON Array with Gson](https://stackoverflow.com/questions/8371274/how-to-parse-json-array-with-gson) — Mitesh Vanaliya, Oct 26 '17 at 12:22

score 0 · Answer 1 · answered Oct 23 '17 at 17:16

0

Sheet1 is an array.

JSONArray array = (JSONArray) object.get("Sheet1");

for (int i = 0; i < array.length(); i++) {
    String title = array.getJSONObject(i).getString("Title");
    String link = array.getJSONObject(i).getString("Link");
}

answered Oct 23 '17 at 17:16

letsCode

2,774
1
13
37

I am using Gson and volley library. – Profreak Oct 23 '17 at 17:19
you asked how to parse the json... thats how you parse the json. – letsCode Oct 23 '17 at 17:21

score 0 · Answer 2 · answered Oct 23 '17 at 17:21

0

This class structure will work for Gson:

public class Response {

    private List<Sheet> Sheet1;
}

public class Sheet {

    private String Title;
    private String Link;
}

Your top-level response has one element, "Sheet1", which is a list of items. Each item in the list has two elements, "Title" and "Link".

answered Oct 23 '17 at 17:21

Ben P.

52,661
6
95
123

What about getters and setters – Profreak Oct 23 '17 at 17:37
Add them if you want – Ben P. Oct 23 '17 at 18:05

score 0 · Answer 3 · answered Oct 23 '17 at 17:32

Create the classes:

public class Sheet {
    String Title;
    String Link;
}

and

public class Sheets {
    Collection<Sheet> Sheet1;
}

and after deserialize with:

        public static void main(String[] args) throws Exception {
        Gson gson = new Gson();
        String filename="pathTo/sheet.json";
        JsonReader reader = new JsonReader(new FileReader(filename));
        Sheets sheet1= gson.fromJson(reader, Sheets.class);
        System.out.println(gson.toJson(sheet1));
    }

score 0 · Answer 4 · edited Oct 26 '17 at 12:38

0

This class structure will work for Gson:

public class Response 
{ 
  private List<Sheet> Sheet1; 
} 
public class Sheet 
{ 
  private String Title; 
  private String Link; 
}

Your top-level response has one element, "Sheet1", which is a list of items. Each item in the list has two elements, "Title" and "Link".

edited Oct 26 '17 at 12:38

Mitesh Vanaliya

2,491
24
39

answered Oct 24 '17 at 08:07

Profreak

53
9

How to parse this format of JSON using Gson

4 Answers4