Getting data from a complex JSON object

glennmars..

Getting data from a complex JSON object

in Contributed Library Questions • 1 year ago

I want to do some data viz with a website's metrics by grabbing a JSON object through an API.

This is an example of the data I'll be using in the JSON object,

http://api.chartbeat.com/live/toppages/v3/?apikey=317a25eccba186e0f6b558f45214c0e7&host=avc.com

I've managed grab the text back from the URL, but I want to extract the data so that can start visually drawing and plotting. For example, getting the number of visitors on a particular article, or getting the headline of the article, and corresponding data etc etc.

I just need to know how to access the data in a JSON object, finding out a particular stat on a particular article etc.

I've looked at every available tutorial and through the forums, but it's very difficult to make sense of, or not clearly explained for a complete noob.

Any help appreciated.

Replies(6)

PhiLho

Re: Getting data from a complex JSON object

1 year ago

Maybe a more sophisticated Json library like Jackson can be useful in your case.

glennmars..

Re: Getting data from a complex JSON object

1 year ago

I managed to figure it out anyway,

but thanks for suggesting the other library, might look into it.

jamiewaese

Re: Getting data from a complex JSON object

10 months ago

Can you describe how you solved the problem?

I'm trying to build a web tool that queries a database and gets a pile of data back in JSON format. But I don't know how to scrape the data out of the JSON formatted text: {"At1g01010": {"ATGE_26_B": "30.150", "ATGE_26_C": "36.350"}}.

I don't know if there are any JSON libraries that are friendly to processing.js. Do you?

PhiLho

Re: Getting data from a complex JSON object

10 months ago

"I don't know if there are any JSON libraries that are friendly to processing.js."
You won't have a library working for both Java and PJS...
If that's the latter you target, actually you don't need a library: JSON is JavaScript Object Notation, which is explicitly supported natively by JS, since that's pure JS code! Usually, it is just parsed by eval() and then the program access the properties of the generated object.

jamiewaese

RE: Re:[WatchList] Getting data from a complex JSON object

10 months ago - via EMail-to-forum

That sounds promising. I'm building web tools so the Java libraries won't help. Would you mind using eval() in a Processing-style sentence? I'm not really a JavaScript programmer and I'm not sure how to use it in Processing syntax.

For those of you struggling with the same problem, my work-around has involved using getIndex of the category name, then getIndex of the ":" before the value, then getIndex of the final quote around the value, then using subString to pull the actual characters I'm looking for out, then converting those characters to a float. It works but feels very ungraceful. It would be great if there was a real function to pull data values out of a JSON-formatted string of characters.

Maybe it's eval() ??

eignxing00

Re: Getting data from a complex JSON object

9 months ago

You might also look into JSON.parse()

Top Reply

Statistics

6 Replies
968 Views
2 Followers

Actions

Permalink