How do i get a value buried in a OrderedDict

Question

I have a variable "case" that calls OrderedDict:

OrderedDict([('totalSize', 1),
         ('done', True),
         ('records',
          [OrderedDict([('attributes',
                         OrderedDict([('type', 'Case'),
                                      ('url',
                                       '/services/data/v38.0/sobjects/Case/5003700000ReKcJAAV')])),
                        ('Id', '5003700000ReKcJAAV')])])])

I want a variable 'Id' to return '5003700000ReKcJAAV'. Is there a way to do that?

I'm using Python 3.6.5

It sounds like you need to implement a tree traversal of your nested data structure. — merlin2011, Jul 16 '18 at 06:24
`print(d['records'][0]['Id'])` - you need to loop through `d['records']`. — Burhan Khalid, Jul 16 '18 at 06:28

Soumendra · Accepted Answer · 2018-07-16T06:43:35.397

1

This looks ugly but, works.

from collections import OrderedDict
z = OrderedDict([('totalSize', 1),
         ('done', True),
         ('records',
          [OrderedDict([('attributes',
                         OrderedDict([('type', 'Case'),
                                      ('url',
                                       '/services/data/v38.0/sobjects/Case/5003700000ReKcJAAV')])),
                        ('Id', '5003700000ReKcJAAV')])])])
print(z.get('records')[0].get('Id'))

Output:

5003700000ReKcJAAV

edited Jul 16 '18 at 06:43

answered Jul 16 '18 at 06:29

Soumendra

1,518
3
27
54

Strange, I've got: File "", line 9 print z.get('records')[0].get('Id') ^ SyntaxError: invalid syntax – RomanK Jul 16 '18 at 06:33
my Python 3.6.5 – RomanK Jul 16 '18 at 06:35
@RomanKulakov, now please check. Done changes for Python 3.6. – Soumendra Jul 16 '18 at 06:43

score 0 · Answer 2 · answered Jul 16 '18 at 06:36

You can also try the below code.

from collections import OrderedDict
import json

l = [('totalSize', 1),
         ('done', True),
         ('records',
          [OrderedDict([('attributes',
                         OrderedDict([('type', 'Case'),
                                      ('url',
                                       '/services/data/v38.0/sobjects/Case/5003700000ReKcJAAV')])),
                        ('Id', '5003700000ReKcJAAV')])])]
ordDict = OrderedDict(l)

print json.dumps(ordDict, indent=4)
"""
{
    "totalSize": 1,
    "done": true,
    "records": [
        {
            "attributes": {
                "type": "Case",
                "url": "/services/data/v38.0/sobjects/Case/5003700000ReKcJAAV"
            },
            "Id": "5003700000ReKcJAAV"
        }
    ]
}
"""

print ordDict['records'][0]['Id'] # 5003700000ReKcJAAV

score 0 · Answer 3 · answered Jul 16 '18 at 06:43

0

It was easier, then i was expecting. I just needed to:

Id = case['records'][0]['Id']

answered Jul 16 '18 at 06:43

RomanK

111
1
8

This is fine. However, will throw error if key not found. https://stackoverflow.com/a/11041421/5014656 – Soumendra Jul 16 '18 at 06:50

How do i get a value buried in a OrderedDict

3 Answers3