How do i access the sub details in the JSON using python?
the python program that i am writing calls to an api that returns this json:
How do i access the subdetails? When i run the .keys() it only lists those three top levels. I want to be able to get specific items, e.g. "Utility"
I've tried several solutions but none parse correctly. I have tried calling the list inside the dictionary, to no avail. Originally i thought it was a dictionary inside of a dictionary, but Python thinks its a list nested into a dictionary.
Any help would be appreciated!
Since it's a dict of lists of dicts, simply use an index of
0to access the first item of the list if there is always only one item in each list. For example, if your JSON object is stored as variable
data, then the value of
Utilitycan be accessed with
keys() function only returns the keys of dictionary, so it you call keys(), it will only return the three result. The "subdetails" you are referring to are the values of those keys. For key "SUMMARY" as an example, its value is a list instead of dict (note the "[" after the key). However, the list only has a single element. This is quite common in json. To retrive "Utility", all you need to do is data['SUMMARY']['Utility']
Maybe to help you understand the data structure better, call the "values()" and "items()" function to see what it returns.