jq
count items in array
jq --raw-output '.["aktes"] | length' 2437.json
join array
jq --raw-output '.["@graph"][] | [.id, .orde, .vleu_huisnummer, (try .relaties|join("|")) ] | @csv' vleu-ab-bouwvergunning_1_2299_flexis.json > bouwvergunningen.txt
unusually named fields at top-level (use [""])
jq --raw-output '.["@graph"][].straatnaam' vleu-con_strn_2299_flexis.json > straatnamen.txt
2 columns
jq --raw-output '.results.bindings[] | .sub.value + "," + .label.value' < rce-cht.json > rce-cht.csv```
live testing jq queries
interesting post
http://www.compciv.org/recipes/cli/jq-for-parsing-json
format json
cat input.json | jq -r . > formatted.json
get all id's from array and display as raw list
cat docs.json | jq -r ".rows[] .id"