Parse JSON response into a List

Question

I'm trying to parse a JSON response

it's structure is:

{
  "metric": {
    "name": "string",
    "values": [
      "string"
    ]
  }
}

My code so far:

        StringBuilder sb = new StringBuilder();
        String line;
        BufferedReader reader = new BufferedReader(new InputStreamReader(conn.getInputStream()));
        while ((line = reader.readLine()) != null) {
            sb.append(line);
        }
        wr.close();
        reader.close();

        JSONObject json = new JSONObject(sb.toString());
        JSONArray jsonArray = json.getJSONArray("values");
        List<String> list = new ArrayList<>();
        String errorPercent ="";

        for(int i = 0 ; i < json.length() ; i++){
            errorPercent = jsonArray.getJSONArray(i).getString(i);
            list.add(errorPercent);
        }

The output I'm getting is saying that "values " was not found,

am I misunderstanding the structure of the JSON response?

Edit

It appears the structure I was given on the site I'm receiving the response from is not correct. it appears to be a more complicated structure

I have modified my code accordingly:

            JSONObject json = new JSONObject(sb.toString());
            JSONObject metricsData = json.getJSONObject("metric_data");
            JSONArray metrics = metricsData.getJSONArray("metrics");
            System.out.println(metrics.toString());

The print out is as follows:

[{"timeslices":[{"values":{"max_response_time":0,"calls_per_minute":0,"average_be_response_time":0,"error_percentage":0,"min_response_time":0,"requests_per_minute":0,"average_network_time":0,"average_response_time":0,"average_fe_response_time":0,"total_app_time":0,"call_count":0,"fe_time_percentage":0,"total_network_time":0,"total_fe_time":0,"network_time_percentage":0},"from":"2015-10-25T22:39:00+00:00","to":"2015-10-25T22:40:00+00:00"},{"values":{"max_response_time":0,"calls_per_minute":0,"average_be_response_time":0,"error_percentage":0,"min_response_time":0,"requests_per_minute":0,"average_network_time":0,"average_response_time":0,"average_fe_response_time":0,"total_app_time":0,"call_count":0,"fe_time_percentage":0,"total_network_time":0,"total_fe_time":0,"network_time_percentage":0},

There appears to be another array within the array: "timeslices" is that right? how do I get at that array?

I unsuccessfully tried:

JSONArray timeslices = metrics.getJSONArray("timeslices");

score 2 · Accepted Answer · answered Oct 25 '15 at 22:47

2

values is a field inside metric.

You'd need to first get the metric object, then look inside that for values.

JSONObject metric = json.getJSONObject("metric");
JSONArray jsonArray = metric.getJSONArray("values");

answered Oct 25 '15 at 22:47

Andy Turner

137,514
11
162
243

Thanks for your help, you've got me a little further, It's my first time working with JSON, if you could help me with my Edit that would be great. – JTK Oct 25 '15 at 23:21
Where is `metric_data`? That's not in your input. – Andy Turner Oct 25 '15 at 23:51
BTW, I'm not a big fan of moving goalposts. If you have a follow-up question, another question would be better if this answered the question as written. – Andy Turner Oct 25 '15 at 23:53
Sorry was busy with exams all week, I've posted a new question following on from this. https://stackoverflow.com/questions/33425252/clean-way-to-parse-json-object – JTK Oct 29 '15 at 21:52

Parse JSON response into a List

1 Answers1