How to parse json data python django?

django, json, python

Solution

You say your json data is:

[{"status": "Registered", "credential": "10000323xsds", "scan_time": "Jan.15,2014, 03:30 pm", "asset_code": "cls103", "emp_id": "LS07", "location": "BLR-10", "auth_code": "DSC(Verisign", "operator": "pradeep", "id": 538}]

This means when you do `j_obj = json.load(j)` your `j_obj` is a list. (Note the `[ ]` on the outside). That is why when you did `print j_obj.status` you got the error "'list' object has no attribute 'status'"

Your updated code does:

for jo in j_obj: 
    print j_obj[jo]['status']

This is the wrong way to use a `for _ in _` loop in Python, you are doing it like you would in Javascript. In Python you would write it like this:

for jo in j_obj: 
    print jo['status']

This will loop through items in the outer list (you have a single item, which is a dict) and print the `'status'` key of that dict.

You can see the `for _ in _` loop gives you the actual item from the list you're looping over, not an index. So in your case `jo` is a dict, this is why you were getting the error "list indices must be integers, not dict" when you tried to do `j_obj[jo]`.

See tutorial here: https://wiki.python.org/moin/ForLoop

Problem

Original source