Get Data from JSON Python? [duplicate]

Question

I'm working on doing a live currency converter in Python. I've successfully fetched all the data needed from the URL into Python. However I'm now trying to call a specific string in the url. Here's my current code:

import urllib.request
import json

##Define JSON API Url
with urllib.request.urlopen("http://openexchangerates.org/api/latest.json?app_id=XXX") as url:
    response = url.read()

##Print Fetched data
print (response)

As you can see I've printed all the data it's fetched, but it's now printing specific strings from it.

My question is, how do i parse specific strings from the url ? I've heard of json.load ,is that something i should use ?

Sorry my question has been edited. Could you explain further with the json.loads ? Thank you for the fast reply — Stewartps
– Stewartps, Commented Mar 9, 2015 at 20:23
better to search documentation first: docs.python.org/3/library/json.html — Jason Hu
– Jason Hu, Commented Mar 9, 2015 at 20:25
Your question would have started out better had you just tried json.loads() first. You may have run into problems, but you could then at least have included the error message here. — Martijn Pieters
– Martijn Pieters, Commented Mar 9, 2015 at 20:31

Martijn Pieters · Accepted Answer · 2015-08-23 17:55:19Z

1

You'll need to load the data as JSON; the json module can do this for you, but you need to decode the data to text first.

import urllib.request
import json

with urllib.request.urlopen("http://openexchangerates.org/api/latest.json?app_id=XXX") as url:
    response = url.read()

charset = url.info(). get_content_charset('utf-8')  # UTF-8 is the JSON default
data = json.loads(response.decode(charset))

From there on out data is a Python object.

Judging by the documenation you should be able to access rates as:

print('Euro rate', data['rates']['EUR'])

for example.

edited Aug 23, 2015 at 17:55

answered Mar 9, 2015 at 20:24

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

Collectives™ on Stack Overflow

Get Data from JSON Python? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related