JSONPath & jq Cheat Sheet

Filter and extract JSON with path expressions and jq idioms

Core selectors

RootEntire document

$          # JSONPath
.          # jq

Child

$.store.book
.store.book

Index

$.store.book[0]
.store.book[0]

Wildcard

$.store.book[*].author
.store.book[].author

Recursive

$..price
.. | .price? // empty

Compare

$.store.book[?(@.price < 10)]
.store.book[] | select(.price < 10)

Exists

$..book[?(@.isbn)]
.. | objects | select(has("isbn"))

Slice

$.store.book[0:2]
.store.book[0:2]

Keys

keys

Map fields

.store.book[] | {title, price}

Length

.store.book | length

PrettyPipe JSON into jq for formatting