Decoding JSON file using python
Cameron Simpson
cs at zip.com.au
Wed May 27 18:52:49 EDT 2015
On 27May2015 15:23, Karthik Sharma <karthik.sharma at gmail.com> wrote:
>I have the JSON structure shown below and the python code shown below to manipulate the JSON structure.
>
> import json
>
> json_input = {
> "msgType": "0",
> "tid": "1",
> "data": "[{\"Severity\":\"warn\",\"Subject\":\"Reporting \",\"Message\":\"tdetails:{\\\"Product\\\":\\\"Gecko\\\",\\\"CPUs\\\":8,\\\"Language\\\":\\\"en-GB\\\",\\\"isEvent\\\":\\\">
> "Timestamp": "1432703193431",
> "Host": "myserver.com",
> "Agent": "Experience",
> "AppName": "undefined",
> "AppInstance": "my_server",
> "Group": "UndefinedGroup"
> }
>
>
> data = json_input['data']
> tdetails = data['Message']
> print('json_input {} \n\ndata {} \n\n tdetails {}\n\n'.format(json_input,data,tdetails))
>
>I am getting the error.
>
> Traceback (most recent call last):
> File "test_json.py", line 19, in <module>
> tdetails = data['Message']
> TypeError: string indices must be integers, not str
That will be because of this line:
tdetails = data['Message']
because "data" is just the string from your dict.
>The JSON structure is valid as shown by http://jsonlint.com/
> I want to be able to access the different fields inside `data` such as `severity`, `subject` and also fields inside `tdetails` such as `CPUs` and `Product`. How do I do this?
Then you need to decode "data". Example (untested):
data_decoded = json.loads(data)
and then access:
data_decoded['Message']
Cheers,
Cameron Simpson <cs at zip.com.au>
Here's a great .sig I wrote, so good it doesn't rhyme.
Jon Benger <jbenger at agravaine.st.nepean.uws.edu.au>
More information about the Python-list
mailing list