jq

jq is a lightweight and flexible command-line JSON processor.

• Homepage: https://stedolan.github.io/jq/
• Ubuntu: apt install jq

jq -r
jq -c

Examples

jq . yourfile.json
jq -r . yourfile.json
jq length yourfile.json
jq keys yourfile.json

jq -r .YourReg.Yourfield yourfile.json

jq -r '. | .YourReg[].Yourfield.yoursubfiel'

jq '.[] | select(.color=="blue")' your_json_file.json

To merge:

jq -s '.[0] * .[1]' file1 file2

• aws secretsmanager get-secret-value --secret-id test/pass | jq -r '.SecretString' | jq -r '.password'

jq --help
-r               output raw strings, not JSON texts;

• jq 'sort_by(.your_field) | reverse'

cat .terraform/terraform.tfstate | jq -c '.backend.config.bucket' | tr -d '"' | grep -c "$(echo $AWS_ENV)"

cat file.txt | jq '.Quotas[] | select(.QuotaName | contains("G and VT")) | {QuotaName, Value, QuotaArn, QuotaCode, Unit}'

Errors

• parse error: Invalid numeric literal at line 1, column 2

Related

• MongoDB
• ElasticSearch
• SQL
• yq
• Miller: mlr
• mapfile -t arr < <(jq -r 'keys[]' yourfile.json)
• Cannot iterate over null
• Cannot index string with string
• @tsv Tab-Separated Values

Activities

• Read: https://stackoverflow.com/questions/tagged/jq?tab=Votes

See also

• jq, JSON, jq -r, jq -c, jid, @tsv
• JSON, jq, jid, mlr, JWT, BSON, Miller, Content-type:, application/json, BadJSON, Webhook, jsonc, ndjson, import json, Google Custom Search JSON API, jsonpath, JSON-LD, JSON tree, JSON-RPC, jsonnet, JSON_TABLE, csv2json, json.tool, JSON Patch