Transform¶
Aggregate¶
Combines all items into a single item with arrays. Binary data is not carried over.
Inputs: main · Outputs: main
| Parameter | Type | Description |
|---|---|---|
Aggregatemode |
one of: allItemData, individualFields |
Default: allItemData. |
Put into fielddestination |
text | All item data: name of the array field. |
Fieldsfields |
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 |
|---|---|---|
Modemode |
one of: allItems, eachItem |
Default: allItems. |
JavaScriptcode |
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 |
|---|---|---|
Operationoperation |
one of: hash, hmac, uuid, base64Encode, base64Decode |
Default: hash. |
Sourcesource |
one of: value, binary |
Hash, HMAC, Base64 encode: the Value text or an attachment. Default: value. |
Valuevalue |
text | Text to work on (UTF-8). Supports expressions. |
Binary propertybinaryProperty |
text | Source 'Binary': the attachment. |
Algorithmalgorithm |
one of: sha256, sha512, sha1, md5 |
Hash, HMAC. MD5 and SHA-1 only for checksums, not for security. Default: sha256. |
Secretsecret |
text | HMAC: the key, best from a secret variable. Supports expressions. |
Outputoutput |
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 |
|---|---|---|
Operationoperation |
one of: now, format, parse, add, subtract, difference, convertTimeZone, startOf |
Default: format. |
Datevalue |
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. |
Untiluntil |
text | Difference: the second date; empty means now. The result is positive when it is later than Date. Supports expressions. |
Patternpattern |
text | .NET date pattern. Format: the output (empty: ISO 8601). Parse: the input (empty: any common form). Supports expressions. |
Cultureculture |
text | For month and day names, e.g. de-DE or en-US. Supports expressions. |
Amountamount |
number | Add, Subtract: how many units. Default: 1. |
Unitunit |
one of: milliseconds, seconds, minutes, hours, days, weeks, months, years |
Add, Subtract, Difference, Start of. Default: days. |
Time zonetimeZone |
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 itemsmaxItems |
integer | Default: 1. |
Keepkeep |
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 |
|---|---|---|
Comparecompare |
one of: allFields, selectedFields |
Default: allFields. |
Fieldsfields |
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 |
|---|---|---|
Fieldsfields |
key/value pairs | Field path (e.g. address.city) → value or expression. |
Renamerename |
key/value pairs | Old field path → new field path (applied before setting fields). |
Keep only set fieldskeepOnlySet |
true/false | Default: false. |
Sort¶
Sorts the items by one or more fields.
Inputs: main · Outputs: main
| Parameter | Type | Description |
|---|---|---|
Sort byfields |
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 itemincludeOtherFields |
true/false | Default: false. |