Data Transformation Nodes

These nodes modify and transform data as it flows through your workflow.

Set

Adds or updates fields on data items.

Properties:

Example - Adding fields:

Field: fullName
Value: {{ $json.firstName + " " + $json.lastName }}

Example - Restructuring:

{
  "user": {
    "name": "{{ $json.name }}",
    "email": "{{ $json.email }}"
  }
}

JSON

Composes JSON objects from expressions.

Properties:

Example:

{
  "timestamp": "{{ $now }}",
  "data": {
    "id": "{{ $json.id }}",
    "processed": true
  }
}

Code

Executes custom JavaScript or Python code.

Properties:

JavaScript Example:

// Access input items
const items = $input.all();

// Transform and return
return items.map(item => ({
  json: {
    ...item.json,
    processed: true,
    timestamp: new Date().toISOString()
  }
}));

Available in Code:

• $input - Input items
• $json - Current item's data
• $node - Access other nodes
• Standard JS/Python libraries

Formatter

Formats text, dates, and numbers.

Properties:

Text Operations:

• Uppercase, Lowercase, Capitalize
• Trim, Replace, Split
• Extract (regex)

Date Operations:

• Format, Parse
• Add/Subtract time
• Get parts (year, month, day)

Number Operations:

• Round, Floor, Ceil
• Format currency
• Convert units