我试图提取嵌套在匿名JSON块中的键的值。以下是result
:
"extras": [
{
"key": "alternative_name",
"value": "catr"
},
{
"key": "lineage",
"value": "This dataset was amalgamated, optimised and published by the Spatial hub. For more information visit www.spatialhub.scot."
},
{
"key": "ssdi_link",
"value": "https://www.spatialdata.gov.scot/geonetwork/srv/eng/catalog.search#/metadata/4826c148-c1eb-4eaa-abad-ca4b1ec65230"
},
{
"key": "update_frequency",
"value": "annually"
}
],
我要做的是提取值annually
,但我不能使用索引,因为其他一些数据集在extras
部分下有更多的键。我正试图编写一个jsonpath表达式,提取value
,其中key
是update_frequency
到目前为止,我所尝试的是:
$.result.extras[*].value[?(key='update_frequency')]
仍然没有运气。
你知道哪里出错了吗?
应该可以:
$.result.extras[?(@.key=="update_frequency")].value