Zum Inhalt

Transform

Aggregate

Combines all items into a single item with arrays. Binary data is not carried over.

Inputs: main · Outputs: main

Parameter Type Description
Aggregate
mode
one of: allItemData, individualFields Default: allItemData.
Put into field
destination
text All item data: name of the array field.
Fields
fields
list of text Individual fields: paths to collect; items without the field are left out.

Code

Transforms items with JavaScript, once for all items or once per item.

Inputs: main · Outputs: main

Parameter Type Description
Mode
mode
one of: allItems, eachItem Default: allItems.
JavaScript
code
code Available: items (all items mode), $json, $itemIndex (each item mode), $input, $node, $workflow, $execution, $now. Source code; {{ }} is not evaluated.

Crypto

Hashes text or attachments (SHA-256, SHA-512, SHA-1, MD5), signs them with HMAC, creates UUIDs and encodes or decodes Base64. Writes the result into a field of each item.

Inputs: main · Outputs: main

Parameter Type Description
Operation
operation
one of: hash, hmac, uuid, base64Encode, base64Decode Default: hash.
Source
source
one of: value, binary Hash, HMAC, Base64 encode: the Value text or an attachment. Default: value.
Value
value
text Text to work on (UTF-8). Supports expressions.
Binary property
binaryProperty
text Source 'Binary': the attachment.
Algorithm
algorithm
one of: sha256, sha512, sha1, md5 Hash, HMAC. MD5 and SHA-1 only for checksums, not for security. Default: sha256.
Secret
secret
text HMAC: the key, best from a secret variable. Supports expressions.
Output
output
one of: hex, base64 Hash, HMAC: hex (lower case) or Base64. Default: hex.
Target field (required)
targetField
text

Date & Time

Gets the current time, formats, parses and calculates dates, and converts between time zones. Writes the result into a field of each item.

Inputs: main · Outputs: main

Parameter Type Description
Operation
operation
one of: now, format, parse, add, subtract, difference, convertTimeZone, startOf Default: format.
Date
value
text The date to work on: ISO 8601 like 2026-11-02T08:30:00+01:00, or text in the pattern (Parse), or Unix seconds or milliseconds. Not used by Now. Supports expressions.
Until
until
text Difference: the second date; empty means now. The result is positive when it is later than Date. Supports expressions.
Pattern
pattern
text .NET date pattern. Format: the output (empty: ISO 8601). Parse: the input (empty: any common form). Supports expressions.
Culture
culture
text For month and day names, e.g. de-DE or en-US. Supports expressions.
Amount
amount
number Add, Subtract: how many units. Default: 1.
Unit
unit
one of: milliseconds, seconds, minutes, hours, days, weeks, months, years Add, Subtract, Difference, Start of. Default: days.
Time zone
timeZone
text IANA or Windows id, e.g. Europe/Vienna. Convert time zone: the target. Now, Format, Start of: the zone to work in. Parse: the zone of text without offset. Supports expressions.
Target field (required)
targetField
text Field for the result, e.g. date or meta.due.

Limit

Keeps only the first or the last N items.

Inputs: main · Outputs: main

Parameter Type Description
Max items
maxItems
integer Default: 1.
Keep
keep
one of: firstItems, lastItems Default: firstItems.

Remove Duplicates

Keeps the first of several items with equal JSON (or equal selected fields).

Inputs: main · Outputs: main

Parameter Type Description
Compare
compare
one of: allFields, selectedFields Default: allFields.
Fields
fields
list of text Selected fields: paths that together identify an item.

Set

Sets, renames or keeps fields of each item.

Inputs: main · Outputs: main

Parameter Type Description
Fields
fields
key/value pairs Field path (e.g. address.city) → value or expression.
Rename
rename
key/value pairs Old field path → new field path (applied before setting fields).
Keep only set fields
keepOnlySet
true/false Default: false.

Sort

Sorts the items by one or more fields.

Inputs: main · Outputs: main

Parameter Type Description
Sort by
fields
list of text Field paths in order of priority; append ' desc' for descending.

Split Out

Turns an array field into one item per element.

Inputs: main · Outputs: main

Parameter Type Description
Field to split out (required)
field
text Path of an array field; every element becomes an item.
Keep the other fields of the item
includeOtherFields
true/false Default: false.