json-formula: A Query Language for JSON with Spreadsheet Functions

This project hosts an implementation of an expression grammar that operates on JSON documents.
The grammar is a mashup of:
- JMESPath query language.
- Operators and functions from OpenFormula

Given:
``
{
"items": [
{
"desc": "pens",
"quantity": 2,
"price": 3.23
},
{
"desc": "pencils",
"quantity": 4,
"price": 1.34
}
]
}
`

sum(items[].price items[*].quantity) => 11.82

items[].{price: price, quantity: quantity, subtotal: price quantity} =>

`
[
{
"price": 3.23,
"quantity": 2,
"subtotal": 6.46
},
{
"price": 1.34,
"quantity": 4,
"subtotal": 5.36
}
]
``

Try it

Visit the Playground

Documentation

Specification / Reference: HTML / PDF

JavaScript API

Developer Instructions