Data Processing
Preview JSONata-style queries and transformations, compare results across sample payloads, and export the transformed output as JSON, CSV, YAML, or Markdown
Call this tool from your code in three languages.
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"}'Send a POST request with your inputs as JSON. File parameters require a separate upload first.
POST https://api.elysiatools.com/en/api/tools/jsonata-query-transform-studio| Name | Type | Required | Description |
|---|---|---|---|
| jsonInput | textarea | Yes | — |
| expression | textarea | Yes | — |
| compareJsonInput | textarea | No | — |
| outputFormat | select | No | — |
| saveExpression | checkbox | No | — |
Add this tool to your Model Context Protocol server so AI agents can list and call it.
Add this block to your MCP client configuration:
{
"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"
}
}
}After connecting to the SSE endpoint, list the exposed tools:
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/list"
}Invoke the tool by its id, passing arguments built from its parameters:
{
"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"
}
}
}| templateName |
| text |
| No |
| — |
HTML result
{
"result": "<div>Processed HTML content</div>",
"error": "Error message (optional)",
"message": "Notification message (optional)",
"metadata": {
"key": "value"
}
}Questions or issues? Contact [email protected]