Data / Query

JSONata Playground

Functional query language for JSON - filter, project, aggregate, transform.

Runtime: jsonata

JSON input

JSONata expression

Loading JSONata…

Result

About this playground

JSONata is to JSON what XPath is to XML - a path-and-function expression language that lets you reshape JSON with one-liners. The playground loads the official jsonata library (~150 KB) and evaluates your expression against the JSON on the left, showing the result on the right.

FAQs

How is JSONata different from JSONPath?

JSONPath is purely a path syntax. JSONata adds functions, aggregation, sorting, conditionals - it's a full expression language. Great for ETL-style transformation, not just selection.

Common use cases?

API response shaping, webhook payload transformation, no-code platforms (it's the expression language in Node-RED and IBM Cloud Pak).

Can I use lambda / custom functions?

Yes - define helper functions inline (e.g. `$bonus := function($x) { $x * 0.1 }`) and call them from the rest of the expression.

Other playgrounds