What input does Jsonata Query Data Processor accept?

Jsonata Query Data Processor accepts text.

Which settings does Jsonata Query Data Processor provide?

Jsonata Query Data Processor provides controls for Query.

What does Jsonata Query Data Processor return?

Jsonata Query Data Processor returns text.

Jsonata Query Data Processor

Tool workspace

Your input stays in this browser.

Needs input

You can run the tool again after any change.

Input

Options

Query

Your result appears here

Transform structured data with Jsonata Query and review the valid output. Enter the data, choose the formatting options, then validate and copy the result.

This tool runs open-source code from CyberChef by GCHQ (Apache License 2.0). See open-source credits.

Jsonata Query Data Processor evaluates a JSONata expression against JSON data.

7 Processing runs in the browser.

Instructions

Provide text or data for this tool.
Provide valid JSON data and a JSONata expression.
Test path and function behavior with a small fixture.
Validate the output type before using it downstream.

Example

Input: {"items":[{"price":3},{"price":4}]}

Settings: Jsonata Query Data Processor: Use the expression '$sum(items.price)'.

Result: 7

Limits

Jsonata Query Data Processor: Expression behavior depends on JSONata syntax and runtime support.
Jsonata Query Data Processor: A query can return null or an empty result for a missing path.
Jsonata Query Data Processor: Processing stays in the browser.