Parsing JSON with Python: TypeError: index indices must be integer, not str

I am using Python to parse some JSON data for specific values. Specifically, I want to do the following:

  • author_id
  • created_at
  • the public

Python code looks like this:

import json
import requests

# Set the request parameters
url = 'https:<MYURL.json'
user = 'MY_USER'
pwd = 'MY_PWD'

# Do the HTTP get request
response = requests.get(url, auth=(user, pwd))

# Check for HTTP codes other than 200
if response.status_code != 200: 
print('Status:', response.status_code, 'Problem with the request. Exiting.')
exit()

# Decode the JSON response
data = response.json()

# Print each value

field_list = data['audits']
for fields in field_list:
print(fields['author_id'])
print(fields['created_at'])
print(fields['events']['public'])
print '\n'

      

My code errors:

File "get_ticket_updates.py", line 27, in <module>
print(fields['events']['public'])
TypeError: list indices must be integers, not str

      

I understand that the public value is a string and it must be integer, so how can I work with that?

The data looks like this:

{

"audits": [
    {

        "id": 20994687984,
        "ticket_id": ####,
        "created_at": "2014-09-15T16:30:11Z",
        "author_id": 312016568,
        "via": {
            "channel": "email",
            "source": {
                "from": {
                    "address": "email@domain.com",
                    "name": "user name",
                    "original_recipients": [
                        "email@domain.com",
                        "email@domain.com"
                    ]
                },
                "to": {
                    "address": "email@domain.com",
                    "name": "My Portal"
                },
                "rel": null
            }
        },
    },
 {
        "id": 20994845144,
        "ticket_id": ####,
        "created_at": "2014-09-15T16:32:18Z",
        "author_id": 233915468,
        "via": {
            "channel": "web",
            "source": {
                "from": {},
                "to": {},
                "rel": null
            }
        },
        "events": [
            {
                "id": 20994845154,
                "type": "Comment",
                "author_id": 233915468,
                "body": "<SOME TEXT>",
                "public": true,
                "attachments": []
            },

      

+3


source to share


3 answers


Configured fields['events']['public']

should befields['events'][0]['public']



+16


source


print(fields['events'][0]['public'])

      



fields['events']

is a list, so you need to use ['events'][0]

to access the dict inside the list.

+2


source


This is exactly the same as the error says. fields['events']

is a list, so you cannot index it with ['public']

. You need to iterate over values, each of which is a dictionary.

for event in fields['events']:
    print event['public']

      

+2


source







All Articles