Transform

Execute JSONata expression against JSON data to transform, query, and manipulate data

Use it in a workflow

Add a step and choose the JSONata connector.
Pick the Transform action.
Fill in the fields below, then reference the result from later steps as {{transform.response.data}}.

Fields

expressionstringrequired

The JSONata expression to execute against the input data

datastringrequired

The JSON data to transform (can be object, array, or primitive)

manipulationsarray<object>

Optional: Manipulate data before processing. Add fields, append to arrays, merge objects, etc.

operationstringrequired

Type of manipulation to perform

One ofaddappendprependinsertmergeupdateremoveDefault "add"

pathstringrequired

Dot notation path to target location (e.g., 'user.profile.email' or 'items[0].tags')

valuestring

Value to add/update/append. Can be literal, JSON object, or JSON array. Enter JSON directly (will be parsed automatically). Use @ to insert references.

indexnumber

Array index to insert at (for 'insert' operation only)

createPathboolean

Create intermediate paths if they don't exist (default: true)

Default true

Examples

Filter and reshape an array

Keep only orders over $100 and project them to a smaller shape

json

{
  "expression": "orders[price > 100].{item: product.name, total: price * quantity}",
  "data": "{\"orders\": [{\"product\": {\"name\": \"Widget\"}, \"price\": 150, \"quantity\": 2}, {\"product\": {\"name\": \"Gadget\"}, \"price\": 50, \"quantity\": 1}]}"
}

Need more? See the JSONata guide for connection setup and behaviour shared by every action.

Was this page helpful?