Difference between revisions of "Jq"
Jump to navigation
Jump to search
| (22 intermediate revisions by 3 users not shown) | |||
| Line 3: | Line 3: | ||
* Homepage: https://stedolan.github.io/jq/ | * Homepage: https://stedolan.github.io/jq/ | ||
* Ubuntu: <code>[[apt install jq]]</code> | * Ubuntu: <code>[[apt install jq]]</code> | ||
| + | |||
| + | [[jq -r]] | ||
| + | [[jq -c]] | ||
== Examples == | == Examples == | ||
| + | |||
jq . yourfile.[[json]] | jq . yourfile.[[json]] | ||
| − | jq | + | jq -r . yourfile.[[json]] |
[[jq length]] yourfile.[[json]] | [[jq length]] yourfile.[[json]] | ||
[[jq keys]] yourfile.[[json]] | [[jq keys]] yourfile.[[json]] | ||
| − | jq '.[] | [[select]](.color=="blue")' your_json_file.json | + | <code>[[jq -r]] .YourReg.Yourfield yourfile.[[json]]</code> |
| + | |||
| + | <code>jq -r '. | .YourReg[].Yourfield.yoursubfiel'</code> | ||
| + | |||
| + | <code>jq '.[] | [[select]](.color=="blue")' your_json_file.json</code> | ||
| + | |||
| + | To merge: | ||
| + | |||
| + | <code>jq -s '.[0] * .[1]' file1 file2</code> | ||
| + | |||
| + | * <code>[[aws secretsmanager]] get-secret-value --secret-id test/pass | [[jq -r]] '.SecretString' | jq -r '.password'</code> | ||
| + | |||
| + | [[jq --help]] | ||
| + | -r output raw strings, not JSON texts; | ||
| + | |||
| + | * <code>[[jq]] '[[sort_by]](.your_field) | reverse'</code> | ||
| + | |||
| + | 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 == | ||
| + | * <code>[[parse error]]: Invalid numeric literal at line 1, column 2</code> | ||
| − | == Related | + | == Related == |
* [[MongoDB]] | * [[MongoDB]] | ||
* [[ElasticSearch]] | * [[ElasticSearch]] | ||
* [[SQL]] | * [[SQL]] | ||
* <code>[[yq]]</code> | * <code>[[yq]]</code> | ||
| + | * Miller: <code>[[mlr]]</code> | ||
| + | * <code>[[mapfile]] -t arr < <(jq -r 'keys[]' yourfile.json)</code> | ||
| + | * <code>[[Cannot iterate over null]]</code> | ||
| + | * <code>[[Cannot index string with string]]</code> | ||
== Activities == | == Activities == | ||
| Line 25: | Line 56: | ||
* {{JSON}} | * {{JSON}} | ||
| − | [[Category: | + | [[Category:jq]] |
| + | [[Category:JSON]] | ||
Latest revision as of 14:21, 22 May 2024
jq is a lightweight and flexible command-line JSON processor.
- Homepage: https://stedolan.github.io/jq/
- Ubuntu:
apt install jq
jq -r jq -c
Contents
Examples[edit]
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;
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[edit]
parse error: Invalid numeric literal at line 1, column 2
Related[edit]
- MongoDB
- ElasticSearch
- SQL
yq- Miller:
mlr mapfile -t arr < <(jq -r 'keys[]' yourfile.json)Cannot iterate over nullCannot index string with string
Activities[edit]
See also[edit]
Advertising:
