jq – Page 12 – Tarik Billa

How to get key names from JSON using jq

October 12, 2022 by Tarik

You can use: jq ‘keys’ file.json Complete example $ cat file.json { “Archiver-Version” : “Plexus Archiver”, “Build-Id” : “”, “Build-Jdk” : “1.7.0_07”, “Build-Number” : “”, “Build-Tag” : “”, “Built-By” : “cporter”, “Created-By” : “Apache Maven”, “Implementation-Title” : “northstar”, “Implementation-Vendor-Id” : “com.test.testPack”, “Implementation-Version” : “testBox”, “Manifest-Version” : “1.0”, “appname” : “testApp”, “build-date” : “02-03-2014-13:41”, “version” : … Read more

How to use `jq` in a shell pipeline?

October 10, 2022 by Tarik

You need to supply a filter as an argument. To pass the JSON through unmodified other than the pretty printing jq provides by default, use the identity filter .: curl -s https://api.github.com/users/octocat/repos | jq ‘.’ | cat

How to count items in JSON object using command line?

September 29, 2022 by Tarik

Just throwing another solution in the mix… Try jq, a lightweight and flexible command-line JSON processor: jq length /tmp/test.json Prints the length of the array of objects.

How to filter an array of objects based on values in an inner array with jq?

September 22, 2022 by Tarik

Very close! In your select expression, you have to use a pipe (|) before contains. This filter produces the expected output. . – map(select(.Names[] | contains (“data”))) | .[] .Id The jq Cookbook has an example of the syntax. Filter objects based on the contents of a key E.g., I only want objects whose genre … Read more

Select objects based on value of variable in object using jq

September 22, 2022 by Tarik

Adapted from this post on Processing JSON with jq, you can use the select(bool) like this: $ jq ‘.[] | select(.location==”Stockholm”)’ json { “location”: “Stockholm”, “name”: “Walt” } { “location”: “Stockholm”, “name”: “Donald” }

Using jq to parse and display multiple fields in a json serially

September 21, 2022 by Tarik

I recommend using String Interpolation: jq ‘.users[] | “\(.first) \(.last)”‘ We are piping down the result of .users[] to generate the string “.first .last” using string interpolation. \(foo) syntax is used for string interpolation in jq. So, for the above example, it becomes “Stevie Wonder” (“.users[].first .users[].second” working elementwise) and “Michael Jackson”. jq reference: String … Read more

How to remove double-quotes in jq output for parsing json files in bash?

September 14, 2022 by Tarik

Use the -r (or –raw-output) option to emit raw strings as output: jq -r ‘.name’ <json.txt