Uploading Json to django model database results in Key Error

Question

I have a custom manage.py command which I am using to upload a json file (a list of dictionaries) to my model. It appears to upload two records fine, but then throws a key error:

KeyError: 'headline'

My code is as follows:

class Command(BaseCommand):

def handle(self,*args,**options):
  filename = '/DoJ_Data_01-12-18.json'
  newpath = str(Path(home))+filename
  with open(newpath) as json_file:  
    data = json.load(json_file)
    for d in data:

      q = doj(headline=d['headline'],topics=d['topics'],text=d['text'],url=d['url'],date=d['date'])
      q.save()

As far as I can tell the json is valid. What am I missing?

This was the correct approach. Using dict.get(key) worked. – Owais Arshad Dec 03 '18 at 00:30 — Owais Arshad, Dec 03 '18 at 00:30

score 0 · Answer 1 · answered Dec 03 '18 at 00:29

0

So based on the comment by Red Cricket, the problem was solved using d.get['headline']. There appears to have been dictionaries without the headline key.

answered Dec 03 '18 at 00:29

Owais Arshad

303
4
18

Uploading Json to django model database results in Key Error

1 Answers1