How to save values of json fields in a list using Python

Question

I have the following JSON structure:

{
    "Users": [
        {
            "UserName": "Administrator",  
            "CreateDate": "2018-01-26T13:07:28Z", 
            "UserId": "YYYYY", 
        }, 
        {
            "UserName": "test_user1", 
            "CreateDate": "2018-01-26T14:32:13Z", 
            "UserId": "XXXXX", 
        }, 
    ]
}

I read this file this way:

jsonIAMUsers = open('reports/1.16-IAM.json', 'r')
IAMUsers = json.load(jsonIAMUsers)
jsonIAMUsers.close()

Ho do I save the values of every UserName field into a list in order to iterate over it? I mean how can I put Administrator and test_user1 in a list?

Andrii Rusanov · Accepted Answer · 2018-01-31 14:21:24Z

3

Just do a list comprehension!

with open('reports/1.16-IAM.json') as jsonIAMUsers:
    IAMUsers = json.load(jsonIAMUsers)
usernames = [u['UserName'] for u in IAMUsers['Users']]

Note with part. It is context manager, which will do all file-related routine(close, etc) for you.

Default mode for open function is r, so it might be skipped.

edited Jan 31, 2018 at 14:21

answered Jan 31, 2018 at 14:12

Andrii Rusanov

4,6262 gold badges41 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Riccardo Over a year ago

@Rusanov It gives me the following error: TypeError: string indices must be integers

Andrii Rusanov Over a year ago

@Riccardo, my bad, fixed now.

Collectives™ on Stack Overflow

How to save values of json fields in a list using Python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related