JPATH语法问题，如何选出指定的数据

Question

客户给了个比较挑战的JSON格式，想用JPATH，必须是用JPATH来处理

{
"a": {
"itemcode": "a",
"quantity": 50,
"sort": 1,
"remark": "",
"dcscope": "0"
},
"b": {
"itemcode": "b",
"quantity": 20,
"sort": 2,
"remark": "",
"dcscope": "0"
},
"c": {
"itemcode": "c",
"quantity": 30,
"sort": 3,
"remark": "",
"dcscope": "0"
}
}

我的目标是把"a","b","c"的三个节点干扰干掉
最终形成类似
“data":
{
{
"itemcode": "c",
"quantity": 30,
"sort": 3,
"remark": "",
"dcscope": "0"
},
{
"itemcode": "b",
"quantity": 20,
"sort": 2,
"remark": "",
"dcscope": "0"
}
}

这样的结构
我尝试用了$..*等类似的JPATH语法，始终无法完全达到效果

Answer 1

你的目标是想把json第一层里面的value抽取出来转成一个json数组吧。格式如下:

[
{
"itemcode": "c",
"quantity": 30,
"sort": 3,
"remark": "",
"dcscope": "0"
},
{
"itemcode": "b",
"quantity": 20,
"sort": 2,
"remark": "",
"dcscope": "0"
}
]