Parsing properties of unknown JSON object

Question

I'm trying to use the MediaWiki API to get articles from Wikipedia.

However, the JSON data that is returned contains the pageid as the identifier for the Object, but the pageid is random.

Here's what my code looks like:

$.getJSON("http://en.wikipedia.org/w/api.php?action=query&generator=random&grnnamespace=0&prop=extracts&exchars=50000&format=json&callback=?", function (data) {
    console.log(data.query.pages);
});

The JSON for the first page that is returned is like this:

37889571: Object
    extract: "<p></p>↵<p></p>↵<p><b>Frank A Delaney IV</b>, Born Feb 4, 1963, Denville New Jersey.</p>↵<p>Mr Delaney is the son of Frank A Delaney III, ..."
    ns: 0
    pageid: 37889571
    title: "Frank A Delaney IV"

I would like to grab properties like the extract or the title console.log(data.query.pages.37889571.extract);, but since the pageid is random, I'm not sure how I can reach it. What would be a good way to accomplish this?

For those who are interested, here is the JSON:

{

    "query":{
        "pages":{
            "1302977":{
                "pageid":1302977,
                "ns":0,
                "title":"Russ O'Hara",
                "extract":"<p><b>Russell Eugene Nealeigh O'Hara</b> is a one-time Los Angeles, USA radio personality whose career began at the forefront of the Boss Radio/Top 40 format.</p>\n<p>O'Hara is best known among LA radio listeners for his work on KKDJ<sup class=\"plainlinks noprint Inline-Template\" style=\"vertical-align:text-top;white-space:nowrap;\">[<i>disambiguation needed</i>]</sup> and his longtime solo work on KRLA where he went by the occasional moniker of \"Russ O'Hungry.\" Highly visible among Los Angeles radio personalities, O'Hara had the privilege of introducing headliners at major concerts, including Janis Joplin at the Hollywood Bowl; he also introduced The Rolling Stones, Jimi Hendrix and Three Dog Night among many others.</p>\n<p>He remains active as a broadcaster and currently hosts afternoons on KDES-FM, an oldies station in Palm Springs, California.</p>\n<p>O'Hara worked at the following Los Angeles stations in the course of his career:</p>\n<ul><li>(KBLA), 1964-65.</li>\n<li>KGFJ, 1968-60.</li>\n<li>KRLA, 1969-72.</li>\n<li>KKDJ<sup class=\"plainlinks noprint Inline-Template\" style=\"vertical-align:text-top;white-space:nowrap;\">[<i>disambiguation needed</i>]</sup>, 1972-74.</li>\n<li>KEZY (Anaheim) 1975-77.</li>\n<li>KROQ-FM, 1978-79.</li>\n<li>Return to KRLA, 1981\u201382; 1992-93.</li>\n<li>KEZN Palm Desert 1993-2001.</li>\n</ul><h2>External links</h2>\n<ul><li>KDES webpage</li>\n</ul><p><br></p>"
            }
        }
    }

}

As I read your (rather poor) rendition of the JSON, you have a JSON object that contains more JSON objects. One of the contained objects is named 37889571. That object in turn contains a string named "extract". You can always iterate through all the entries in the outer object and get all the "extract" strings. But obviously to get a particular one you need to know its "name" or some other identifier. — Hot Licks
– Hot Licks, Commented Nov 24, 2013 at 3:14
A new site is needed for the dozens of nearly identical JSON questions that come in every day: jsonoverflow.com — Dexygen
– Dexygen, Commented Nov 24, 2013 at 3:28
Related: This recent question asks essentially the same thing, but for Python. — Ilmari Karonen
– Ilmari Karonen, Commented Nov 25, 2013 at 22:14

theintellects · Accepted Answer · 2013-11-24 03:16:49Z

1

I'm able to get to the properties by using:

for(var id in data.query.pages) {
  console.log(data.query.pages[id]);
}

but I'm not certain if that's the best/only way.

answered Nov 24, 2013 at 3:16

theintellects

1,3783 gold badges16 silver badges31 bronze badges

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

1 Comment

Ilmari Karonen Over a year ago

This is the way I would recommend myself. That said, if you don't want to use a for..in loop for some reason, you can also ask MediaWiki to give you an explicit list of the page IDs in a separate part of the response.

Hunter · Accepted Answer · 2017-04-10 17:00:34Z

0

You can now add &indexpageids in your request and you will get the pageids.

For example:
https://en.wikipedia.org/w/api.php?action=query&titles=Leipzig&prop=pageimages&format=json&pithumbsize=1000&indexpageids

answered Apr 10, 2017 at 17:00

Hunter

3,37223 silver badges23 bronze badges

Collectives™ on Stack Overflow

Parsing properties of unknown JSON object

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related