Trying to Read inner key, value from unicode JSON in python

Question

I am trying to get key value from below unicode JSON is python

messagejson={
u'Records': 
[
{
u'requestParameters': {u'sourceIPAddress': u'113.112.10.06'}, 
u'sql': {u'configurationId': u'note', 
u'object': {u'eTag': u'ed3645fa5ee', u'sequencer': u'005', u'key': u'src-1.txt', u'size': 606}, 
u'mysql': {u'dn': u'url', u'name': u'invoice',
u'ownerIdentity': {u'principalId': u'A3UJ54'}
}, 
u'myval': u'1.0'
}, 
u'ee': {u'abc': u'tcCh6T', u'x': u'487DBE36E1'}, 
u'userIdentity': {u'principalId': u'AWS:AIDAIOJ4'}, 
u'eventSource': u'source'
}
]
}

Tried by using

print messagejson['Records'][0]['sql']['key']

getting error

TypeError: list indices must be integers, not str

can someone help

`messagejson['Records'][0]['sql']['object']['key']` – roganjosh Oct 08 '18 at 19:05 — roganjosh, Oct 08 '18 at 19:05

score 2 · Accepted Answer · answered Oct 08 '18 at 19:07

2

You are missing one level in your dict get.

run this and you will see.

print messagejson['Records'][0]['sql']

The 'key' is within the value of the 'object' key, so you need to add 'object' before you get 'key'

print messagejson['Records'][0]['sql']['object']['key']

answered Oct 08 '18 at 19:07

dfundako

8,022
3
18
34

Tried it, no luck. Updated the question – Charan Oct 08 '18 at 19:13
@Charan Well then you are doing something incorrect. I just took your new example, took all the indents out of it, and it works fine. – dfundako Oct 08 '18 at 19:18
Also, in Python3, variable= by itself is incorrect syntax. Not sure if thats the same for Python2. – dfundako Oct 08 '18 at 19:21
^ This is also invalid syntax in Python2. – andrew_reece Oct 08 '18 at 19:28
1

@andrew_reece I updated the post to make it copy/paste-able into cmd. – dfundako Oct 08 '18 at 19:31

score 1 · Answer 2 · answered Oct 08 '18 at 19:07

1

You're missing the object level in your indexing:

messagejson['Records'][0]['sql']['object']['key']
# src-1.txt

answered Oct 08 '18 at 19:07

andrew_reece

20,390
3
33
58

Trying to Read inner key, value from unicode JSON in python

2 Answers2