根据名称过滤JSON API响应

Question

我已经解决了许多其他类似的问题/线程，但没有一个可以帮助我。我有这个api响应，它给了我一个vm上运行的作业列表。我想总结一个名为"发布名称"的特定作业的运行时间:"数据抓取">

"value": [
{
"EndTime": "2021-02-03T05:25:00.643Z",
"Info": "Job completed",
"JobPriority": "Normal",
"ReleaseName": "Data scraping",
"RuntimeType": "Unattended",
"StartTime": "2021-02-03T05:00:07.183Z",
},
{
"EndTime": "2021-02-03T05:25:00.643Z",
"Info": "Job completed",
"JobPriority": "Normal",
"ReleaseName": "Data scraping",
"RuntimeType": "Unattended",
"StartTime": "2021-02-03T05:00:07.183Z",
},
{
"EndTime": "2021-02-03T05:25:00.643Z",
"Info": "Job completed",
"JobPriority": "Normal",
"ReleaseName": "Other Process",
"RuntimeType": "Unattended",
"StartTime": "2021-02-03T05:00:07.183Z",
},
{
"EndTime": "2021-02-03T05:25:00.643Z",
"Info": "Job completed",
"JobPriority": "Normal",
"ReleaseName": "Other Process",
"RuntimeType": "Unattended",
"StartTime": "2021-02-03T05:00:07.183Z",
}
]

在第一步中，我想过滤JSON数据，只保留有关那些名为"数据抓取"的作业的信息。最好的方法是什么?

Answer 1

要过滤，应该使用filter:)

values = response['value'] #is a list
filtered = list(filter(lambda entry:entry['ReleaseName'] == 'Data scraping', values))

lambda函数将保留计算结果为true的值