Django json nested list .get()

Question

I am stuck with a silly problem.

I have a json data and trying to save it in my model.

Here is the code.

response = response.json() #this gives json data
response = json.loads(response) #loads string to json           
json_string = response #ready to get data from list
modelfielda = json_string.get("abc") # this works fine
modelfieldb = json_string.get('["c"]["d"]["e"]') #this does not give data though data is present.

My json data comes like this:

{  
   "abc":"AP003",
   "c":[  
      {  
         "d":{  
            "e":"some data",
            "f":"some data"
         }
      }
   ]
}

So my question is how to get data inside c.

@Chiefir That will give full list and not specific item in e. — Sapna Sharma
– Sapna Sharma, Commented May 3, 2018 at 14:33
Try this for e -> bnm = json_string.get('c').get('d').get('e') — Chiefir
– Chiefir, Commented May 3, 2018 at 14:33

Chiefir · Accepted Answer · 2018-05-03 14:36:32Z

2

Try this for e:
bnm = json_string.get('c').get('d').get('e')
or with list:
bnm = json_string.get('c')[0].get('d').get('e')

answered May 3, 2018 at 14:36

Chiefir

2,6712 gold badges31 silver badges47 bronze badges

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

Comments

willeM_ Van Onsem · Accepted Answer · 2018-05-03 14:34:40Z

1

By using multiple .gets:

bnm = json_string.get('c')[0].get('d').get('e')  # bnm = 'some data'

Or perhaps better (since it will error in case the key does not exists):

bnm = json_string['c'][0]['d']['e']  # bnm = 'some data'

Since you converted it to a Python dictionary, you basically work with a dictionary, and you can obtain the value corresponding to a key by using some_dict[some_key]. Since we here have a cascade of dictionaries, we thus obtain the subdictionary for which we again obtain the corresponding value. The value corresponding to c is a list, and we can obtain the first element by writing [0].

answered May 3, 2018 at 14:34

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

2 Comments

Sapna Sharma Over a year ago

The answer is correct for my question. But in case there are multiple list inside c, one has to manually use [0] or there is any short code for that. Thanks

willeM_ Van Onsem Over a year ago

@SapnaSharma: well the question is what do you want to do with that lists? Return all elements, only the first one, but indeed, you should add [0], or we can write a function that solves the logic.

Collectives™ on Stack Overflow

Django json nested list .get()

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related