python - JSON 请求出现类型错误

Question

import requests

user = 'my_user'
pwd = 'my_pwd'
headers = {"Content-Type":"application/json","Accept":"application/json"}

url = 'https://my_company.service-now.com/api/now/table/sc_req_item/bfa27ef2db203f00d8909c47db9619f3?sysparm_fields=sys_id%2Crequest'

response = requests.get(url, auth=(user, pwd), headers=headers  )
mydata = response.json()
print(mydata)                  #Print for debug output purposes
for item in mydata["result"]:
    print(item["sys_id"])
    print(item["request"]["value"])

来自print(mydata)的输出:

{'result': {'sys_id': 'bfa27ef2db203f00d8909c47db9619f3', 'request': {'link': 'https://my_company.service-now.com/api/now/table/sc_request/3fa27ef2db203f00d8909c47db9619f3', 'value': '3fa27ef2db203f00d8909c47db9619f3'}}}

错误:

Traceback (most recent call last):
  File "./prod_getUnapprovedSIDs.py", line 42, in <module>
    print(item["sys_id"])
TypeError: string indices must be integers

Answer 1

您需要迭代 JSON 响应的键、值对。试试这个例子:

for key, item in mydata.items():
    print(item["sys_id"])
    print(item["request"]["value"])