CODEWITHSUNDEEP
jsonapimediawikiwikipedia
est
est

Reputation: 11845

wikipedia API: parse a table as JSON?

Is it possible to parse this table as array in array JSON?

The output I want is something like:

[
  ["Northwest Caucasian", "Abkhaz", "аҧсуа бызшәа, аҧсшәа", "ab", "abk", "abk", "abk", "abks"], 
  [Afro-Asiatic", "Afar", "Afaraf", "aa", "aar", "aar", "aar", "aars"],
  ...
]

The best I've got is like this, this, or this, which isn't helpful at all.

I need not only the ISO639 table but some other wikipedia tables, so I need a general method of parsing wiki tables as json. Any ideas?

Upvotes: 4

Views: 3547

Answers (2)

darklow
darklow

Reputation: 2329

@est thanks, this helped me a lot.

You can also improve previous code to save the result as json string, just wrap it in JSON.stringify() (Modern browsers only) 

JSON.stringify($('table.sortable tr').map(function() {
    return new Array($('td', this).map(function() {
        return $(this).text()
    }).slice(2, 5).get())
}).get())

Upvotes: 2

est
est

Reputation: 11845

okay, I found the simplest way is to use Javascript in Chrome Developer Console

$('table.sortable tr').map(function() {
    return new Array($('td', this).map(function() {
        return $(this).text()
    }).slice(2, 5).get())
}).get()

It's a pity wikipedia doesn't provide an API like this.

Upvotes: 8

Related Questions