json-tools

JSON Tools

Parse and transform JSON using jq.

Query

• Pretty print: echo '<json>' | jq .
• Get field: echo '<json>' | jq '.field'
• Nested field: echo '<json>' | jq '.a.b.c'
• Array element: echo '<json>' | jq '.[0]'
• Array length: echo '<json>' | jq 'length'

Filter and transform

• Select fields: echo '<json>' | jq '{name: .name, id: .id}'
• Filter array: echo '<json>' | jq '.[] | select(.status == "active")'
• Map: echo '<json>' | jq '[.[] | .name]'
• Sort: echo '<json>' | jq 'sort_by(.date)'
• Group: echo '<json>' | jq 'group_by(.type)'
• Unique: echo '<json>' | jq '[.[].category] | unique'

File operations

• Read and query: jq '.key' file.json
• Compact: jq -c . file.json
• Raw strings (no quotes): jq -r '.name' file.json
• Convert to CSV: jq -r '.[] | [.name, .value] | @csv' file.json