JSON Input
Structure Explorer
Paste JSON and click "Parse JSON" to see structure
JSONata Query
JSONata Examples:
$ - Root object
store.book - Books array
store.book[price < 10] - Filter
store.book.title - All titles
store.book{title: title, author: author} - Transform
$count(store.book) - Count function
$ - Root object
store.book - Books array
store.book[price < 10] - Filter
store.book.title - All titles
store.book{title: title, author: author} - Transform
$count(store.book) - Count function
All books
store.book
All titles
store.book.title
Books under $10
store.book[price < 10]
Fiction only
store.book[category = "fiction"]
Title → price map
store.book{title: price}
Sort by price
store.book^(price)
Count books
$count(store.book)
Total price
$sum(store.book.price)
Most expensive
$max(store.book.price)
ISBN or "no ISBN" if missing
store.book.isbn ?? "no ISBN"
Edition or "1st" if not set
store.book.(edition ?: "1st")