Jq json file manipulation: Difference between revisions

From Edgar BV Wiki
Jump to navigation Jump to search
(Created page with "viewing the top level structure for all objects <pre> jq '.[]|keys' filename </pre> viewing the top level structure for the first object <pre> jq '.[0]|keys' filename </pre> v...")
 
No edit summary
Line 26: Line 26:
jq '.[].data.category.name' filename | sort -u
jq '.[].data.category.name' filename | sort -u
</pre>
</pre>
http://blog.librato.com/posts/jq-json
https://shapeshed.com/jq-json/#how-to-map-values
http://www.compciv.org/recipes/cli/jq-for-parsing-json/

Revision as of 10:05, 6 October 2017

viewing the top level structure for all objects

jq '.[]|keys' filename

viewing the top level structure for the first object

jq '.[0]|keys' filename

viewing the top level structure for the third object

jq '.[2]|keys' filename

viewing the first key for the first object

jq '.[0] |  keys | .[0] filename


selecting a specific item (from the top level)

jq '.[] | select(.id=bla)' filename

getting specific data from a subkey

jq '.[].data.category.name' filename | sort -u


http://blog.librato.com/posts/jq-json

https://shapeshed.com/jq-json/#how-to-map-values

http://www.compciv.org/recipes/cli/jq-for-parsing-json/