jq - JSON processor

jq is a powerful expression language for filtering and transforming structured JSON data

Helpful Resources

• jqplay: A playground for jq 1.6
• jq Manual: has runnable examples of each operator
• jq Homepage
• jq tag on StackOverflow

Brick Arguments

The jq brick takes two input arguments:

• data: an object, array, or single value which is passed to jq
• filter: the jq "filter", which controls how to filter/transform the data

Filter Examples

Creating a new object from the input

View on jqplay

{foo: 42, bar: .}

Parsing and summing values

View on jqplay

.transactions | map(.amount | capture("(?<val>\\d+) USD") | .val | tonumber) | add

Filtering an array

View on jqplay

Assign the query to a variable so you can use it in the select clause

.query as $query | [.items[] | select(.text == $query)]