如何使用Python在JSON中查找和迭代值列表[duplicate]

Question

上周我刚开始在工作中学习Python。我正在尝试与我们的人力资源系统集成，并使用每个API将信息上传到Okta（我们的SSO提供商）。

HR API以以下格式输出一个json文件

{
    "isError": false,
    "Status": 0,
    "Message": "The request processed successfully.",
    "Result": [
        {
            "EmployeeId": {
                "DisplayValue": "004",
                "FieldHistory": []
            },
            "Title": {
                "DisplayValue": "",
                "FieldHistory": []
            },
            "FirstName": {
                "DisplayValue": "John",
                "FieldHistory": []
            },
            "LastName": {
                "DisplayValue": "Smith",
                "FieldHistory": []
            },
        }]
}

然后，我想将它输入到一个名为employeeID的变量中，并将其放在我的代码中：

PHRPayload = {
  "APIKey": PHRAPI,
  "Action": PHRAction,
  "EmployeeId": EmployeeID,
  }

我希望遍历Result>EmployeeId>DisplayValue并将它们打印到一个dict中，然后在代码的另一部分中遍历这些

OktaURL = "https://company.okta.com/api/v1/users/" + PHRPost.json()['Result']['EmailId']['DisplayValue']

Answer 1

只需对结果进行迭代：

PHRAPI = 'yourCode'
PHRAction = 'yourCode'
data = {} #Your result from the api

for res in data['Result']:
    EmployeeID = res['EmployeeId']['DisplayValue']

    #Call API and so on
    PHRPayload = {
        "APIKey": PHRAPI,
        "Action": PHRAction,
        "EmployeeId": EmployeeID,
     }
    #....