sr 2.5版本,用routine load导入复杂json总是不行,请问这种嵌套的json该怎么配置?
应该是jsonpath配置不对
json样例:
{
“reason”: “suc”,
“error_code”: 0,
“result”: {
“duration”: “”,
“matchs”: [
{
“date”: “2024-10-28”,
“week”: “aa”,
“list”: [
{
“status”: “3”,
“AA”: “114”,
“BB”: “03:30”,
},
{
“status”: “3”,
“AA”: “115”,
“BB”: “06:00”,
}
]
},
{
“date”: “2024-10-29”,
“week”: “周二”,
“list”: [
{
“status”: “3”,
“AA”: “119”,
“BB”: “07:00”
},
{
“status”: “3”,
“AA”: “125”,
“BB”: “07:30”
}
]
}
],
“title”: “test”
}
}
我的routine load配置
PROPERTIES
(
“desired_concurrent_number”=“1”,
“format” = “json”,
“jsonpaths” = “[
‘$.result.matchs[].date’,
'$.result.matchs[].week’,
‘$.result.matchs[].list[].status’,
‘$.result.matchs[].list[].AA’,
‘$.result.matchs[].list[].BB’,
]”,
“json_root” = “$.result.matchs[].list[]”,
“strip_outer_array” = “true”
)
运行报错Attempted to access an element of a JSON array that is beyond its length., msg: failed to access array field: matchs, index: -2