Data Processing
JSONata Query & Transform Studio
Preview JSONata-style queries and transformations, compare results across sample payloads, and export the transformed output as JSON, CSV, YAML, or Markdown
html· HTML resultOpen tool
Quick start
Call this tool from your code in three languages.
cURL
curl -X POST 'https://api.elysiatools.com/en/api/tools/jsonata-query-transform-studio' \
-H 'Content-Type: application/json' \
-d '{"jsonInput":"{\"orders\":[{\"id\":1,\"status\":\"paid\",\"total\":120},{\"id\":2,\"status\":\"pending\",\"total\":40}]}","expression":"groupBy(orders, \"status\")","compareJsonInput":"{\"orders\":[{\"id\":2,\"status\":\"pending\",\"total\":55}]}","outputFormat":"json","saveExpression":false,"templateName":"Paid order totals"}'API reference
Send a POST request with your inputs as JSON. File parameters require a separate upload first.
Endpoint
HTTP
POST https://api.elysiatools.com/en/api/tools/jsonata-query-transform-studioParameters
| Name | Type | Required | Description |
|---|---|---|---|
| jsonInput | textarea | Yes | — |
| expression | textarea | Yes | — |
| compareJsonInput | textarea | No | — |
| outputFormat | select | No | — |
| saveExpression | checkbox | No | — |
MCP integration
Add this tool to your Model Context Protocol server so AI agents can list and call it.
Server configuration
Add this block to your MCP client configuration:
mcp.json
{
"mcpServers": {
"elysiatools-jsonata-query-transform-studio": {
"name": "jsonata-query-transform-studio",
"description": "Preview JSONata-style queries and transformations, compare results across sample payloads, and export the transformed output as JSON, CSV, YAML, or Markdown",
"baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=jsonata-query-transform-studio",
"command": "",
"args": [],
"env": {},
"isActive": true,
"type": "sse"
}
}
}List available tools
After connecting to the SSE endpoint, list the exposed tools:
tools/list
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/list"
}Call this tool
Invoke the tool by its id, passing arguments built from its parameters:
tools/call
{
"jsonrpc": "2.0",
"id": 2,
"method": "tools/call",
"params": {
"name": "jsonata-query-transform-studio",
"arguments": {
"jsonInput": "{\"orders\":[{\"id\":1,\"status\":\"paid\",\"total\":120},{\"id\":2,\"status\":\"pending\",\"total\":40}]}",
"expression": "groupBy(orders, \"status\")",
"compareJsonInput": "{\"orders\":[{\"id\":2,\"status\":\"pending\",\"total\":55}]}",
"outputFormat": "json",
"saveExpression": false,
"templateName": "Paid order totals"
}
}
}Chain multiple tools in one session with a comma-separated toolId list, e.g. /mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp (max 20).