JSONata playground

Last updated on 8 Nov 2025

Overview

Inspired by the original JSONata Exerciser, this is an online code editor for evaluating and debuging JSONata expressions that offers additonal features such as:

  • intuitive user interface
  • automatic completion for built-in JSONata functions
  • ability to save work to local or remote storage
  • Excel to JSON conversion
  • table view for flat JSON objects
  • javascript bindings
  • conversational AI assistant

Developing JSONata expressions

To offer a great development experience when writing JSONata expressions, the JSONata editor has useful IntelliSense features.

Code completion

Typing a $ symbol will show a list of built-in JSONata functions including the arguments a function expects

Quick info

Hovering over a function within a block will bring up a tooltip with the function signature.

Member lists

Typing a . symbol after the context reference $ will show a list of properties of the JSON input if it is an object.

Saving playgrounds

You can save playgrounds to local and remote storage.

Local playgrounds are stored in your browser and are accessible only on the device they were saved from. You do not need to register an account to save playgrounds localy.

Remote playgrounds are stored in a database and are accessible on any device connected to the internet. You need to register an account and purchase a subscription to save playgrounds remotely. See pricing for more information.

Like with sharing playgrounds, a JSONata expression is the only input required for saving a playground. The JSON input and bindings are optional. The JSON output is never stored but is always evaluated when the playground loads.

Sharing playgrounds

Only registered users can create public links to JSONata playgrounds, and unregistered users can only view them.

When you share a playground, the generated link will allow anyone access to the playground even if they don't have an account at JSONata Studio.

Like with saving playgrounds, a JSONata expression is the only input required for sharing a playground. The JSON input and bindings are optional. The JSON output is never stored but is always evaluated when the playground loads.

Debugging playgrounds

When there's an issue with one of the inputs, the output editor will show a message pointing to the cause of the issue. For examples of common types of error messages, see the JSON output editor.

If the JSON output is not sufficient in helping you resolve an issue, consider utilising the built-in AI assistant.

Managing playgrounds

To view, update or delete any of your saved or shared playgrounds, you can do so via the Admin Dashboard.