Unable to parse json response with python

Question

So I ran into an issue while importing API data into my code. Any help is much appreciated.

from urllib2 import Request, urlopen, URLError
import json, requests

data = requests.get('https://masari.superpools.net/api/live_stats?update=1522693430318').json()
data_parsed = json.loads(open(data,"r").read())
print data_parsed

I'm still quite new to python, and I ran into this error:

>C:\Users\bot2>python C:\Users\bot2\Desktop\Python_Code\helloworld.py
Traceback (most recent call last):
  File "C:\Users\bot2\Desktop\Python_Code\helloworld.py", line 5, in <module>
    data_parsed = json.loads(open(data,"r").read())
TypeError: coercing to Unicode: need string or buffer, dict found

You don't need the open statement in json.loads here; that's just for file reading. Just use json.loads(data). See docs — patrick
– patrick, Commented Apr 2, 2018 at 20:29
@patrick data is already a dictionary as .json() was added to request — Günther Jena
– Günther Jena, Commented Apr 2, 2018 at 20:30

Günther Jena · Accepted Answer · 2018-04-02 20:32:15Z

0

data is already received as a json object (which is a dict in this case). Just do the following:

data = requests.get('https://masari.superpools.net/api/live_stats?update=1522693430318').json()
print data

Use data['network'] for example to access nested dictionaries.

edited Apr 2, 2018 at 20:32

answered Apr 2, 2018 at 20:27

Günther Jena

3,7663 gold badges37 silver badges49 bronze badges

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

1 Comment

John Gentry Over a year ago

Thank you, I have an additional question, how would I pull specific data from the API? I would like to pull all data from the category "network" in the API.

Collectives™ on Stack Overflow

Unable to parse json response with python

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