Databases
StackOverflow2013
Postsdbo
POJSON Parsing using minimal-json and Gson
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJSON Parsing using minimal-json and Gson
    primarykey
    data
    text
    <p>I have a java program which retrieves data for a particular TV show and returns a JSON response with the details. My problem is with parsing the JSON response to get one particular key-value pair, namely the "first_aired_iso" string, which gives the air date for that episode.</p> <p>Here is the URL which calls the API</p> <p><code>String api_url = "http://api.trakt.tv/show/season.json/&lt;api-key&gt;/the-walking-dead/1";</code></p> <p>And here is the corresponding JSON response</p> <hr> <blockquote> <p>! <code>[ { "season":1, "episode":1, "number":1, "tvdb_id":2493011, "title":"Days Gone Bye", "overview":"Rick searches for his family after emerging from a coma into a world terrorized by the walking dead. Morgan and Duane, whom he meets along the way, help teach Rick the new rules for survival.", "first_aired":1288584000, "first_aired_iso":"2010-10-31T21:00:00-05:00", "first_aired_utc":1288598400, "url":"http://trakt.tv/show/the-walking-dead/season/1/episode/1", "screen":"http://slurm.trakt.us/images/episodes/124-1-1.22.jpg", "images":{ "screen":"http://slurm.trakt.us/images/episodes/124-1-1.22.jpg" }, "ratings":{ "percentage":89, "votes":763, "loved":733, "hated":30 }, "watched":true, "in_collection":true, "in_watchlist":false, "rating":false, "rating_advanced":0 }, { "season":1, "episode":2, "number":2, "tvdb_id":2493181, "title":"Guts", "overview":"Rick unknowingly causes a group of survivors to be trapped by walkers. The group dynamic devolves from accusations to violence, as Rick must confront an enemy far more dangerous than the undead.", "first_aired":1289192400, "first_aired_iso":"2010-11-07T21:00:00-06:00", "first_aired_utc":1289210400, "url":"http://trakt.tv/show/the-walking-dead/season/1/episode/2", "screen":"http://slurm.trakt.us/images/episodes/124-1-2.22.jpg", "images":{ "screen":"http://slurm.trakt.us/images/episodes/124-1-2.22.jpg" }, "ratings":{ "percentage":87, "votes":533, "loved":507, "hated":26 }, "watched":true, "in_collection":true, "in_watchlist":false, "rating":false, "rating_advanced":0 }, { "season":1, "episode":3, "number":3, "tvdb_id":2656081, "title":"Tell It to the Frogs", "overview":"After returning to the camp with the department store survivors and an emotional reunion with his wife and son, Rick decides to go against Shane's advice and go back to Atlanta for Merle Dixon and his dropped bag of guns accompanied by Merle's younger brother, Darryl Dixon, as well as Glenn and T-Dog.", "first_aired":1289797200, "first_aired_iso":"2010-11-14T21:00:00-06:00", "first_aired_utc":1289815200, "url":"http://trakt.tv/show/the-walking-dead/season/1/episode/3", "screen":"http://slurm.trakt.us/images/episodes/124-1-3.22.jpg", "images":{ "screen":"http://slurm.trakt.us/images/episodes/124-1-3.22.jpg" }, "ratings":{ "percentage":85, "votes":484, "loved":458, "hated":26 }, "watched":true, "in_collection":true, "in_watchlist":false, "rating":false, "rating_advanced":0 }, { "season":1, "episode":4, "number":4, "tvdb_id":2656091, "title":"Vatos", "overview":"While still in search of Merle, the group tries to retrieve the bag of guns but are attacked by several living men who are also after the weapons. The group manages to grab the injured attacker; however, several of the attackers escape and take Glenn hostage. Back at camp a large group of walkers venture up the hill and take the survivors by surprise.", "first_aired":1290402000, "first_aired_iso":"2010-11-21T21:00:00-06:00", "first_aired_utc":1290420000, "url":"http://trakt.tv/show/the-walking-dead/season/1/episode/4", "screen":"http://slurm.trakt.us/images/episodes/124-1-4.22.jpg", "images":{ "screen":"http://slurm.trakt.us/images/episodes/124-1-4.22.jpg" }, "ratings":{ "percentage":88, "votes":490, "loved":467, "hated":23 }, "watched":true, "in_collection":true, "in_watchlist":false, "rating":false, "rating_advanced":0 }, { "season":1, "episode":5, "number":5, "tvdb_id":2656101, "title":"Wildfire", "overview":"Rick leads the group to the CDC after the attack on the camp. Jim must make a terrible life and death decision.", "first_aired":1291006800, "first_aired_iso":"2010-11-28T21:00:00-06:00", "first_aired_utc":1291024800, "url":"http://trakt.tv/show/the-walking-dead/season/1/episode/5", "screen":"http://slurm.trakt.us/images/episodes/124-1-5.22.jpg", "images":{ "screen":"http://slurm.trakt.us/images/episodes/124-1-5.22.jpg" }, "ratings":{ "percentage":87, "votes":460, "loved":443, "hated":17 }, "watched":true, "in_collection":true, "in_watchlist":false, "rating":"love", "rating_advanced":10 }, { "season":1, "episode":6, "number":6, "tvdb_id":2656111, "title":"TS-19", "overview":"Rick and the group are allowed into the CDC by a strange doctor, but all is not what it seems in their newfound haven. ", "first_aired":1291611600, "first_aired_iso":"2010-12-05T21:00:00-06:00", "first_aired_utc":1291629600, "url":"http://trakt.tv/show/the-walking-dead/season/1/episode/6", "screen":"http://slurm.trakt.us/images/episodes/124-1-6.22.jpg", "images":{ "screen":"http://slurm.trakt.us/images/episodes/124-1-6.22.jpg" }, "ratings":{ "percentage":87, "votes":465, "loved":440, "hated":25 }, "watched":true, "in_collection":true, "in_watchlist":false, "rating":"love", "rating_advanced":10 } ]</code></p> </blockquote> <hr> <p>Well, you get the idea... I just need to extract the key value for "first_aired_iso" for each episode.</p> <p>Here is my code to do that</p> <pre><code> String s = response.toString(); Gson gson = new Gson(); String jsonstr = gson.toJson(s); System.out.println(jsonstr); JsonArray json = JsonArray.readFrom(jsonstr); for (int i = 0; i &lt; 15; i++) { System.out.println(json.get(i).asString()); } </code></pre> <p>Problem is, there is absolutely no response after printing the raw JSON output. I can't get it to enter the loop at all.</p> <p>For reference, please check <a href="http://eclipsesource.com/blogs/2013/04/18/minimal-json-parser-for-java/" rel="nofollow">http://eclipsesource.com/blogs/2013/04/18/minimal-json-parser-for-java/</a></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKanishka Ganguly
    1. USKanishka Ganguly
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJSON Parsing using minimal-json and Gson
      1. This table or related slice is empty.
      1. VTUpMod
    1. COBasically, you've got an array of "objects" (maps/dictionaries), though some details (such as ratings) are maps within the individual program maps. "first_aired_iso" would be an entry in each map of the array, with a String for a value. Iterate through each JSON array element, cast the element to a JsonObject (??), then use, probably, `get("first_aired_iso")` to extract the String result.
      singulars
      1. POJSON Parsing using minimal-json and Gson
      1. USHot Licks
    2. COI tried that. Didn't return anything. Used every possible JSON parser out there. Gson, org.JSON, simple-json, Jackson, minimal-json, everything.
      singulars
      1. POJSON Parsing using minimal-json and Gson
      1. USKanishka Ganguly
    3. COI doubt it. To extract the individual element use `JsonObject show = (JsonObject)(json.get(i));`. (Or perhaps `JsonObject show = json.get(i).asObject();`.) Then `String time = show.get("first_aired_iso").asString();`.
      singulars
      1. POJSON Parsing using minimal-json and Gson
      1. USHot Licks
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload