curl and jq 8 cheatsheet

curl and jq 8: jq: filter and transform JSON

14 common curl and jq 8 tasks.

Pretty-print JSON

Format JSON with indentation and colors.

curl -s https://api.example.com/users | jq .

Extract one field from an object.

jq '.name' user.json

Output raw strings instead of JSON strings, handy in scripts.

jq -r '.name' user.json

Output each element of an array.

jq '.users[]' data.json

Output the name of every user.

jq -r '.users[].name' data.json

Keep users older than 30.

jq '.users[] | select(.age > 30)' data.json

Count the items in an array.

jq '.users | length' data.json

Output the keys of an object.

jq 'keys' user.json

Print each result on one line, which suits line-oriented tools.

jq -c '.users[]' data.json

Create objects with only the fields you want.

jq '.users[] | {id, name}' data.json

Sort an array of objects by a field.

jq 'sort_by(.age)' users.json

Group array elements that share a value.

jq 'group_by(.role)' users.json

Turn arrays of values into CSV rows.

jq -r '.users[] | [.id, .name, .age] | @csv' data.json

Use a shell value inside a jq filter without quoting problems.

jq --arg name "Ada" '.users[] | select(.name == $name)' data.json