Table to JSON using node.js

Question

I am trying to convert a table to JSON, to search for data easily, the URL is: http://www.tppcrpg.net/rarity.html

I found this package: https://www.npmjs.com/package/tabletojson

I tried to use it like:

'use strict';

const tabletojson = require('tabletojson');

        tabletojson.convertUrl(
            'http://www.tppcrpg.net/rarity.html',
            { useFirstRowForHeadings: true },
            function(tablesAsJson) {
                console.log(tablesAsJson[1]);
            }
        );

However it returns undefined in the console, are there any alternative options or am I using the package wrong?

Yes I want to get the data in JSON because I wouldn't know how to get data from a row in table format — Musa
– Musa, Commented Sep 16, 2018 at 7:01
Ok you are unable to access there data of third party api, but you want that data, so you are trying this am i correct? — Sameer
– Sameer, Commented Sep 16, 2018 at 7:06

Sameer · Accepted Answer · 2018-09-16 07:31:06Z

1

Hey you are actually getting data, change the console.log

Your output have total one array only but you are putting tablesAsJson[1] in console, but array index starts with [0].

'use strict';

    const tabletojson = require('tabletojson');
    tabletojson.convertUrl(
        'http://www.tppcrpg.net/rarity.html',
        function(tablesAsJson) {
            console.log(tablesAsJson[0]);
        }
    );

For better looking code:

const url = 'http://www.tppcrpg.net/rarity.html';
tabletojson.convertUrl(url)
  .then((data) => {
    console.log(data[0]);
  })
  .catch((err) => { 
     console.log('err', err);
   }); // to catch error

edited Sep 16, 2018 at 7:31

answered Sep 16, 2018 at 7:15

Sameer

3,6385 gold badges27 silver badges55 bronze badges

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

1 Comment

Ruben Over a year ago

cheerio and github.com/misterparser/cheerio-tableparser worked for me

Collectives™ on Stack Overflow

Table to JSON using node.js

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related