Jq json file manipulation

From Edgar BV Wiki
Revision as of 08:34, 27 October 2017 by Red (talk | contribs)
Jump to navigation Jump to search

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 '.[0].id' filename
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/