JMESpath
a query language for JSON
Example
Query
locations[?state == 'WA'].name | sort(@) | {WashingtonCities: join(', ', @)}
Input
{
"locations": [
{"name": "Seattle", "state": "WA"},
{"name": "New York", "state": "NY"},
{"name": "Bellevue", "state": "WA"},
{"name": "Olympia", "state": "WA"}
]
}
Result
{
"WashingtonCities": "Bellevue, Olympia, Seattle"
}