json路径语法排序值

Question

我正在做API测试在我当前的项目。我得到以下json数据来验证一些表值。但是我不知道如何对卷进行排序。区域应该按升序排序。

{
"type": "Financial Risk",
"category_volume_list": [{
"category_type": "Volume as Acquirer",
"volumes": [{
"region": "NA",
"volume": 1279550601.24,
"currency": "USD"
},
{
"region": "EUR",
"volume": 1642489095.24,
"currency": "USD"
},
{
"region": "LAC",
"volume": 3149627.36,
"currency": "USD"
},
{
"region": "CEMEA",
"volume": 1106493.08,
"currency": "USD"
},
{
"region": "AP",
"volume": 118011586.85,
"currency": "USD"
}

Answer 1

这对我有用

import json
from jsonpath_ng import parse
json_data = json.loads(json_string)
jsonpath_expression = parse('$..region')
region_list_origin = [match.value for match in jsonpath_expression.find(json_data)]
region_list_copy = region_list_origin.copy()
region_list_copy.sort()
print(region_list_origin) //['NA', 'EUR', 'LAC', 'CEMEA', 'AP']
print(region_list_copy)   //['AP', 'CEMEA', 'EUR', 'LAC', 'NA']