PowerShell, as is, has all the tools you need to query JSON and then reshape, re-purpose it to what you need. $json = @" { "locations": [ {"name": "Seattle", "state": "WA"}, {"name": "New York", "state": "NY"}, {"name": "Bellevue", "state": "WA"}, {"name": "Olympia", "state": "WA"} ] } "@ | ConvertFrom-Json $names=(($json.locations | ? state -eq 'wa').name | Sort) -join ',' @{WashingtonCities = $
![PowerShell is a Query Language for JSON – Development in a Blink](https://cdn-ak-scissors.b.st-hatena.com/image/square/8d71ff5111e05619a10d29bb40d7aebaa75c8fbc/height=288;version=1;width=512/https%3A%2F%2Fs0.wp.com%2Fi%2Fblank.jpg)