Insert data into SQLite but getting KeyError - Python

Question

Trying to insert data into database but I keep getting this error:

Traceback (most recent call last):
  File "business.py", line 25, in <module>
    data = fetch_data(con)
  File "business.py", line 18, in fetch_data
   result.append((entry['address'], entry['postalcode'],
KeyError: 'address'

Still new to python and coding. Appreciate your help, folks!

What I have so far:

import requests
import sqlite3

URL = 'http://url/url/url/{}.json'
def fetch_data(con):
    cur = con.cursor()
    cur.execute("SELECT identifier FROM restaurant WHERE res_creditnote = 'No' LIMIT 6")
    result = []
    for row in cur:
        r = requests.get(URL.format(row[0]))
        entry = r.json()
        result.append((entry['address'], entry['postalcode'],
                       entry['postal'], entry['statenumber'], entry['state'],
                       entry['countrycode'], entry['country']))
    return result

con = sqlite3.connect("business.db")
data = fetch_data(con)
cur = con.cursor()
cur.executemany('INSERT INTO hotel (address, postalcode, '
                'postal, statenumber, state, '
                'countrycode, country) VALUES (?, ?, ?, ?, ?, ?, ?);', data)
con.commit()
con.close()

EDIT

I try to fetch json data like this:

"businessaddress":{"address":"Stockholm road 11","postalcode":"045432","postal":"Stockholm","statenumber":"45141","state":"Stockholm","countrycode":"SW","country":"Sweden"}

What are you confused about? The error is telling you that the JSON you have downloaded does not contain an "address" key. — Daniel Roseman
– Daniel Roseman, Commented Apr 14, 2018 at 18:58

Daniel Roseman · Accepted Answer · 2018-04-14 19:17:25Z

1

Your data appears to a dictionary containing a key "businessaddress" which itself is a dictionary containing the other keys. So you need to access it that way, either via entry['businessaddress']['address'] etc or by assigning the inner dictionary to a temporary variable and using that:

entry = r.json()['businessaddress']

answered Apr 14, 2018 at 19:17

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

1 Comment

Niknak Over a year ago

Thank you, Daniel! Do you have time to chat in a private room? I have a few other important questions I really want to ask you about. I do not know how to invite you to a private chat. That is if you are available, thanks.

Joost · Accepted Answer · 2018-04-14 19:00:19Z

1

It has nothing to do with SQL, but with your dictionary called entry. Apparently the JSON you're retrieving does not have a address key in it. You can try debugging by printing then entry dictionary after this line entry = r.json()

answered Apr 14, 2018 at 19:00

Joost

3,7492 gold badges15 silver badges30 bronze badges

Collectives™ on Stack Overflow

Insert data into SQLite but getting KeyError - Python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related