Decoding JSON file using python
MRAB
python at mrabarnett.plus.com
Wed May 27 23:54:23 EDT 2015
On 2015-05-28 00:51, Karthik Sharma wrote:
> I tried modifying the program as follows as per your suggestion.Doesn't seem to work.
>
> import simplejson as json
> import cjson
>
> 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"
> }
>
> print('json input original {} \n\n'.format(json_input))
>
> data = json_input['data']
>
> print('data {} \n\n'.format(data))
>
> message = json.loads(data)
>
> print('message {} \n\n'.format(message['Message']))
>
> I get the following error.
>
> Traceback (most recent call last):
> File "test_json.py", line 23, in <module>
> print('message {} \n\n'.format(message['Message']))
> TypeError: list indices must be integers, not str
> karthik.sharma at aukksharma2:~$ vim test_json.py
>
You have a different error message now. It says that 'message' is a
list.
Have a look at the JSON data. It represents a list that contains a dict.
>
> On Thursday, 28 May 2015 11:14:44 UTC+12, Cameron Simpson wrote:
>> 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']
>>
More information about the Python-list
mailing list