Getting only values of object as array output without keys & Getting All values by property name without chain


Use Common Code -1 as Input in jsonata

https://jsonata.blogspot.com/2021/04/common-code-1.html

IP: "Address": {

"Street": "Hursley Park",
"City": "Winchester",
"Postcode": "SO21 2JN"
},

Query: Address.* OP: [

"Hursley Park",
"Winchester",
"SO21 2JN"
]


To get one values of property query: *.Postcode op:"SO21 2JN"
To get all properties query: **.Postcode
op:[
"SO21 2JN",
"E1 6RF"
]

No comments:

Post a Comment

calling outside object property or parent

 https://try.jsonata.org/dxPC5s-zM { "list1" : [ { "b" : 1 , "list2" : [ { ...