JSONata

​

Overview

• Evaluating complex transformation expressions against JSON data
• Outputting results to the data field or children array
• Setting an evaluation timeout to prevent runaway expressions

​

Command Type

​

Parameters

​

Usage Examples

​

Sum a Field Across an Array

{
  "command": "jsonata",
  "params": {
    "expression": "$sum(items.price)",
    "timeout": 5000
  }
}

​

Transform and Restructure Data

{
  "command": "jsonata",
  "params": {
    "expression": "items.{ 'id': id, 'label': name & ' (' & status & ')' }",
    "timeout": 5000,
    "key": "children"
  }
}

​

Filter with Expression

{
  "command": "jsonata",
  "params": {
    "expression": "items[status = 'active']",
    "timeout": 3000,
    "key": "children"
  }
}

​

String Concatenation

{
  "command": "jsonata",
  "params": {
    "expression": "firstName & ' ' & lastName",
    "timeout": 2000
  }
}

​

Output Key Options

​

Common Use Cases

• Aggregations: Sum, average, or count values across arrays
• Complex Transformations: Reshape data structures in a single expressive step
• Conditional Logic: Apply conditional transformations without multiple commands
• String Formatting: Concatenate or format string fields

​

Related Commands

• Transform By JDM - Transform data using JDM mapping rules
• Zen Parse Expression - Evaluate Zen expressions
• Json Path - Extract data using JSONPath