json-formula Testing
Input JSON
Expression
Result
Debug Info
mimic fields
Select Expression
address.street
substitute(address.street, "Oak", "Maple")
items[*]
items[? @.price > 2]
items[*].price
items[*].price * items[*].quantity
sum(items[*].price * items[*].quantity)
map(items, &price * quantity)
items[*].{subtotal: price * quantity}
items[*].merge(@, {subtotal: price*quantity})
sum(items[*].price * items[*].quantity) * tax
round(sum(items[*].price * items[*].quantity) * tax, 2)
address.phone | "(" & mid(@, 0, 3) & ")" & mid(@, 3, 3) & "-" & mid(@, 6, 4)
Reset Data
Syntax Railroad Diagram
Antlr4 Grammar