Extracting data from JSON array

Question

I know its an array, but I am completely new to JSON and need help comprehending how this is structured, here is my attempt at extracting data:

String JSonString = readURL("//my URL is here");
JSONArray s = JSONArray.fromObject(JSonString);
JSONObject Data =(JSONObject)(s.getJSONObject(0));
System.out.println(Data.get("name"));

My JSON data that I have goes like this :

 {
"sports": [
    {
        "name": "basketball",
        "id": 40,
        "uid": "s:40",
        "leagues": [
            {
                "name": "National Basketball Assoc.",
                "abbreviation": "nba",
                "id": 46,
                "uid": "s:40~l:46",
                "groupId": 7,
                "shortName": "NBA",
                "athletes": []
            }
        ]
    }
],
"resultsOffset": 10,
"resultsLimit": 10,
"resultsCount": 1,
"timestamp": "2013-11-18T03:15:43Z",
"status": "success"
}

I dont really have a strong grasp of this stuff so all the help is appreciated.

like I said, Im clueless as to how this is structured so code examples would help. — user2855405
– user2855405, Commented Nov 18, 2013 at 21:27
The JSON data in your question is an object (and not an array) and it's invalid. (Try jsonlint.com or a similar tool.) — Codo
– Codo, Commented Nov 18, 2013 at 21:27
An opening curly brace starts a JSON object. An opening bracket starts an array. Your data starts with a curly brace (object) and ends with a closing bracket (invalid). — Codo
– Codo, Commented Nov 18, 2013 at 21:32

Sahil Singh · Accepted Answer · 2020-06-14 15:40:22Z

15

Here is the idea :

JSONObject root = new JSONObject(yourJsonString);
JSONArray sportsArray = root.getJSONArray("sports");

// now get the first element:
JSONObject firstSport = sportsArray.getJSONObject(0);

// and details of the first element
String name = firstSport.getString("name"); // basketball
int id = firstSport.getInt("id"); // 40
JSONArray leaguesArray = firstSport.getJSONArray("leagues");

// and so on, you can process leaguesArray similarly

It should work (feel free to complain about compile errors if there are any)

edited Jun 14, 2020 at 15:40

Sahil Singh

621 silver badge7 bronze badges

answered Nov 18, 2013 at 21:46

kiruwka

9,5104 gold badges32 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

vikramvi Over a year ago

Thanks for help 1 decade back, it helped me to solve a problem today :) stackoverflow.com/questions/75519681/…

Codo · Accepted Answer · 2013-11-18 21:47:18Z

3

Your JSON data is an object (it starts with a curly brace). In the next inner layer, there is a single array (at key "sports"):

String jsonString = readURL("//my URL is here");
JSONObject result = JSONObject(jsonString);
JSONArray sports = result.getJSONArray("sports");
JSONObject sport = sport.getJSONObject(0);
System.out.println(sport.getString("name"));

I might have used another JSON library than you.

answered Nov 18, 2013 at 21:47

Codo

79.6k18 gold badges176 silver badges218 bronze badges

Comments

BSS · Accepted Answer · 2013-11-18 21:43:35Z

0

JSON means JavaScript Object Notation.

Objects in javascripts are just containers and can be represented by key-value pairs. Please find below notations to understand about json.

Represent objects in json: E.g. Student

{"name" : "Robin", "rollnumber" : "1"}

Represent array in json : E.g. Array of students

[{"name" : "Robin", "rollnumber" : "1"}, {"name" : "Mark", "rollnumber" : "2"}]

You can understand more on JSON from diagrams on this link http://www.json.org/fatfree.html

There are various ways available to to convert JSON to javaobject and javaobject to JSON : One of them is http://wiki.fasterxml.com/JacksonInFiveMinutes

answered Nov 18, 2013 at 21:43

BSS

762 bronze badges

Comments

Saket Mittal · Accepted Answer · 2015-07-26 21:12:18Z

0

Adding detailed code here along with the imports .

If this helps.

import org.json.JSONException;
import org.json.JSONObject;

public class extractingJSON {

    public static void main(String[] args) throws JSONException {
        // TODO Auto-generated method stub

        String jsonStr = "{\"name\":\"SK\",\"arr\":{\"a\":\"1\",\"b\":\"2\"},\"arrArray\":[{\"a\":\"1\",\"b\":\"2\"}]}";
        JSONObject jsonObj = new JSONObject(jsonStr);
        String name = jsonObj.getString("name");
        System.out.println(name);

        String first = jsonObj.getJSONObject("arr").getString("a");
        System.out.println(first);

        first = jsonObj.getJSONArray("arrArray").getJSONObject(0).getString("a");
        System.out.println(first);



    }


}

edited Jul 26, 2015 at 21:12

Saket Mittal

3,9123 gold badges32 silver badges49 bronze badges

answered Jul 26, 2015 at 20:25

user3251882

9801 gold badge11 silver badges21 bronze badges

Collectives™ on Stack Overflow

Extracting data from JSON array

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related