Nodes: Data

This node reduces a whole array down to a single result: a count, a sum, an average, a min or max, the first or last item, or all items joined into one string. It works on arrays of numbers, objects, or strings.

Configuration fields

• Source Array - The values to aggregate: use wildcard [*] to extract fields from objects, for example TRIGGER.payload.orders[*].amount

• Operation - Aggregation operation to perform

  • Sum - add all numeric values

  • Count - number of items

  • Average - mean of numeric values

  • Min - smallest value

  • Max - largest value

  • First - first item in array

  • Last - last item in array

  • Join - combines items into one string using a Join Separator (default , ) ; it doesn't add numbers

Build CSV text from an array of objects or arrays. Use this when workflow data needs to eb exported, attached, or sent to another system as comma-separated values. Spreadsheet formula sanitization is on by default, so cells beginning with =, +, -, or @ is prefixed with a single quote. The CSV string is produced on the node's output.

Configuration fields

• Rows - Rows to write as a CSV: use an array of objects or an array or arrays

• Delimiter - Single character, placed between CSV cells

This node builds an XML document from an object shaped by Rewst's XML convention, the same shape that Parse Data produces: attributes are keys prefixed with -, element text is #text. Use it to send data to an XML API or export an XML file. Values that cannot map to a single-root XML document route to an "Invalid Data" handle instead of failing the whole node, so you can branch on bad input.

Configuration fields

• Input - Single-root object following the SML JSON convention

  • Attributes as -prefixed keys

  • Text as #text

This node decodes encoded text back into plain text or JSON. It handles Base64, Base64URL, URL percent-encoding, hex, and Data URLs. It's built for untrusted input: malformed data routes to an "Invalid Data" handle rather than failing the node, so workflows can branch on bad data.

Configuration fields

• Input - Encoded runtime input to decode

• Input Format - Encoding format to decode: Base64, Base64 URL, URL Percent, Hex, or Data URL

• Strictness

  • Strict - Rejects malformed runtime data

  • Lenient - Accepts safe transport variants such as missing Base64 padding

• Output Kind

  • Text - Default

  • JSON Parse - To parse the decoded text

This node encodes trusted workflow data into Base64, Base64URL, URL percent-encoding, hex, or a Data URL. Text input is treated as UTF-8 bytes internally; choose JSON to stringify an object before encoding. Use Line Wrapping (RFC 2045, 76 charaxcters) for legacy MIME consumers, or Data URL when emitting line image/text payloads.

Configuration fields

• Input - Runtiume input to encode: text is treated as UTF-8 bytes internally, and no charset selector is exposed

• Input Kind - Treat input as text or JSON-stringify it before encoding

  • UTF-8 is the implicit text encoding

  • There is no separate UTF-8 mode

• Output Format - Encoding format to produce: Base64, Base64URL, URL percent-encoding, hex, or a Data URL

Group a list by a field and compute per-group metrics: sum, count, acerage, median, min, max, first, last, or collect. Optionally attach fields from a second list matched by the group key. Use this instead of a code expression for rollups, pivots, and grouped reports. For example, group charge rows by companyID, sum charge, then attach company name from a companies list.

Configuration fields

• Source Array - The list to group: bind an upstream array or enter a templated array expression

• Group By Field - Dot path on each source item that supplies the group key, for example companyID or ticket.subType.name

• Aggregations

  • Add one row per metric

  • Pick an operation, the item attribute it reads, and the output name for the grouped row

  • Operations: sum, count, avg, min, max, median, first, last, collect

• Enrichment Source - Optional second list used to attach fields to each grouped row

• Enrichment Match Field - Dot-path on each enrichment item matched to the group key, for example id

• Enrichment Fields - Optional fields copied from the first matching enrichment item

  • Each row names the attribute to read and the output name on the grouped row

• Output Shape

  • Rows preserve key types and order

  • Map is convenient for keyed lookup

When your data uses codes or abbreviations, this node translates them into human-readable values. Feed it a status code and get back "Success." Or, feed it "CA" and get back "California." Think of it as a small mapping table - status code to label, region code to region name. You define the translation table.

Configuration fields

• When I receive - The value to translate, such as the status code or priority number

• Translate it using this table - Add rows for each translation

  • Use Start with Example to launch an example table you can edit

  • Use + Add Manually to launch blank table Input and Output fields

• If no match, return - Returned when input doesn't match any row; leave empty for null

• Match exact uppercase/lowercase - When toggled to enabled, Error and error are treated as different, case-sensitive values

Build your output object by picking fields from previous nodes and optionally transforming them. Use this when you need to reshape data, combine fields from multiple sources, or prepare a payload for an API call.

Configuration fields

• Output fields - Define what this node outputs

  • + Add Field Manually - Full control, adding one field at a time

  • Use the Wizard - Guided setup with suggestions, recommended

  • Import from JSON - Launches a dialog to upload JSON file

This node parses JSON, YAML, CSV, or XML text into workflow data. Malformed runtime input routes to an "Invalid Data" handle instead of failing the node, so workflows can branch on bad data. Choose the format explicitly, then use advanced CSV or XML options when needed.

Configuration fields

• Input - Text to parse as the selected format

• Format - Format of the input text: JSON, YAML, CSV, or XML

This node finds and replaces text using a regular expression. It uses Go's RE2 engine, which has no backtracking or lookaround. Replacement references use $1 and ${name}; use $$ for a literal dollar. Zero matches pass the input through unchanged on out. Invalid patterns fail the node with position detail.

Configuration fields

• Input - Runtime string to transform

• Pattern - Go regexp pattern, lookaround and backtracking-only constructs are not supported

• Replacement - Replacement text

  • Leave field empty to delete matches

  • Capture references use $1 or $name

  • Literal dollar is $$

• Replace All - Replace all matches; toggle off to replace only the first match

• Ignore Case - Match without case sensitividy via RE2 inline flat (?i)

• Multiline - Make ^ and $ match line boundaries via RE2 inline flag (?m)

This node loads a template from Rewst's Automation Asset library and renders it with the current workflow context. Use it for reusable email templates, markdown summaries, or JSON payloads that are managed centrally rather than pasted into each workflow. You can pick a fixed template, or enter a dynamic slug from upstream data.

Configuration fields

• Template Asset - Pick a template from the Asset Library

  • Leave blank if using a dynamic slug below instead

• Template Parameters - Parametrer bidings passed to the templagte as PARAMS via key-value pairs

  • Ex: {{ PARAMS.ticketId }}

• Output Type - The data type the rendered template produces

  • Automatically detects it from the rendered value

  • String always stringifies

  • Number, Boolean, Object and Array coerce to that type and error if the value does not match

  • This type is what downstream nodes see when they browse this output

Select a script from Rewst's Automation Asset library and resolve its body and metadata. The resolved script body is output for downstream execution nodes. You can pick a fized script or enter a dynamic slug from upstream data.

Configuration fields

• Script Asset - Pick a script from the Asset library, or leave empty of using a dynamic slug below instead

• Script Parameters - Parameter bindings passed to the script at execution time, via key-value pairs

This node performs per-item array work without a Loop node: map, filter, sort, unique, groupBy, batch, append, concat, or flatten. It's the first choice for reshaping a list.

Configuration fields

• Operation

  • Remove Duplicates - Remove duplicate items from the array

  • Sort - Reorder items by a field or value

  • Randomize - Randomize the item order

  • Filter - Keep only items that match a condition

  • Map - Transform each item into something new

  • Append - Nest an array as one element

  • Concat - Flat-combine two arrays

  • Remove First - Remove the first item in the array

  • Remove Last - Remove the last item in the array

  • Flatten - Merge nested arrays into one level

  • Group By - Group items by a field and return an object with arrays

  • Batch - Split into smaller arrays of a fixed size

• Source Array - The array to transform

Create a new random value each time your workflow runs. You pick the type of value you want and get a new value each time the workflow runs. If you need the same value in several places, generate it once and reuse it. Don't add a second Generate step, as that would create a different value.

Use it to generate temporary passwords during onboarding, to give each workflow run a unique ID to find it later in logs or tickets, or to choose a random number to decide which tech will be assigned a task.

Configuration fields

• Generator type - the value you want to generate

  • Unique ID - a long code that will never repeat

  • Number - a random whole integer

  • Characters - a random. mix of letters and numbers, great for temp passwords

  • Hex - a random code made of numbers and the letters A-F

  • Base64 - another style of random text code

  • Passphrase - a few random words strung together, easier to read than random characters

  • Color - a random color code, for example #4A90E2

• UUID format - choose the output shape when generating UUIDs: defaults to v4 when unset

• Format (legacy) - legacy shared format key superseded by UUID format and ignored when set; retained so existing configurations keep working

Hashing lets you quickly check whetehr two sets of data are identical before you spend time comparing them line by line. Make a fingerprint of a piece of information. Give the node some data, such as a name, email address or list of records, and it will give back a short code that stands for that data. Use it to spot changes in a customer's user list over time, compare private information safety, or confirm that a message from an outside system is genuine.

• The same data always gives the same fingerprint. The code will be identical always.

• Any change gives a completely different fingerprint.

• It only works one way— you can't turn the fingerprint back to the original data.

Configuration Fields

• Mode -

  • hash creates an unkeyed digest, a plain fingerprint of the data

  • HMAC creates a keyed digest, mixing in a secret password

• Algorithm - choose a digest algorithm as the method used to make the fingerprint; MD5 is legacu and non-secure, not for passwords or tamper resistance

• Input kind - text hashes the value as UTF-8 text; JSON stringifies the bound value before hashing

• Hex case - letter case for hex output, either upper or lower case

This node lets your workflow change information stored in a database. It sends the database instruction that changes something. For example:

• Add something new, like a customer to the customer's table

• Update something, like change the customer's phone number

• Delete something, like remove an old record

• Change the. layout, like add a new column or tables

It works with three common database types: Postgres, MYSQL, and Microsoft SQL Server. You need a database connection set up first so that Rewst can know where the database is and how to log in. Without that, this node won't run. Workflow information goes in separately from the instruction. This node works in conjunction with the other two nodes in this category: Run Query and Run Stored Procedure.

Configuration Fields

• Database connection - the saved database server connection to run this statement against; the connection must not be read-only, as read-only connections refuse write statements

• SQL statement- the write statement to run; use the schema-qualified table name

  • INSERT

  • DELETE

  • DDL

Let your workflow look up information in a database without changing anything. This is the read-only counterpart to the Execute SQL node. Ask the database a question and have it hand back the matching record as a list of results. Later steps in your workflow can use those results. It works with three database types: Postgres, MYSQL, and Microsoft SQL Server.

You need a database connection set up first so that Rewst can know where the database is and how to log in. Without that, this node won't run. Workflow information goes in separately from the instruction. This node works in conjunction with the other two nodes in this category: Execute SQL and Run Stored Procedure.

Configuration Fields

• Database connection - the saved database server connection to run this query against; Run Query is read-only, and on PostgreSQL and MySQL it runs in a read-only transaction, with a read-only credential required for SQL Server

• SQL query - the SQL to run: use the schema-qualified table name

• Query parameters - enter a JSON array, an ordered list of values that fill the. placeholders in your query, in order

Tell a database to run a saved set of instructions that already live inside it. Use it when someone has already built logic, to ensure consistency, and to make complex jobs simpler with one click instead of several steps. You provide the procedure name and any needed inputs. It sends results back, and can make changes. It works with three database types: Postgres, MYSQL, and Microsoft SQL Server.

Configuration Fields

• Database connection

• Procedure name - the name of the stored procedure to run, optionally schema-qualified; use a plain identifier as quoted/bracketed names and names with spaces aren't supported

• Parameters - optionally add an ordered list of positional INOUT values passed to the procedure in declaration order; values are bound as parameters, never string-interpolated, keeping the call safe from injection; OUTPUT parameters not supported

Save a piece of information in Rewst's built-in storage, but only if nobody else has changed it since you last checked. It stops two workflow runs from overwriting each other's work. The workflow path will proceed to either success or failure, if someone changed it first. On failure it will re-read the storage and try again, or stop. Use it to prevent double work, count and run totals, and reconcile checkpoints in records.

Configuration Fields

• Scope - who shares the storage

  • Tenant - set isolated to this organization

  • MSP subtree (shared) - share across the MSP org tree, with descendants being able to read and write

• Namespace - named storage area in Rewst

• Key - key for the storage area in Rewst

• Expected version

• Value - what to put in the storage

Empty one storage area in Rewst's built in storage. It uses the same storage as the Compare and Swap Key-Value node. You indicate what storage area to clear out, and the node does the work. It doesn't need to know what's inside. It just removes it. The success path in the workflow means the storage was cleared. Failure means the delete didn't work. Use this node to clean up when a job is finished, clear an old checkpoint and start fresh, or remove stale information before it causes confusion instead of waiting for it to expire.

Configuration Fields

• Scope

• Namespace

• Key

Open one area in Rewst's built-in storage and hand its contents to the rest of your workflow. You indicate which area and the node reads what is inside. Nothing gets changed. A workflow usually forgets everything once it finishes. This node lets it remember things from earlier runs. Use it to pick up where you left off, avoid double work, or quickly reference info.

Configuration Fields

• Scope - who shares the storage

  • Tenant - set isolated to this organization

  • MSP subtree (shared) - share across the MSP org tree, with descendants being able to read and write

• Namespace

• Key

• Timeout (seconds) - maximum execution time for datastore operation

Add to a number saved in one of Rewst's storage areas. It works like a tally counter: each time the workflow reaches this step, the number goes up. You tell it where and how much to add. The increment does the reading, adding, and saving in one unbreakable move.

Configuration Fields

• Scope - who shares the storage

  • Tenant - set isolated to this organization

  • MSP subtree (shared) - share across the MSP org tree, with descendants being able to read and write

• Namespace - named storage area in Rewst

• Key - key for the storage area in Rewst

• Increment by - must be a whole integer

Put something in one of Rewst's storage spaces so your workflow can find it again later, even on a future run. It's the "save" step in this category of actions. If the space already has something in it, the old contents are replaced with a new value. If more than one copy of the workflow could update the same locker at the same moment, one update can be lost. For numbers, use Increment Key-Value. For other kinds of changes, use Compare and Swap Key-Value.

Configuration Fields

• Scope - who shares the storage

  • Tenant - set isolated to this organization

  • MSP subtree (shared) - share across the MSP org tree, with descendants being able to read and write

• Namespace - named storage area in Rewst

• Key - key for the storage area in Rewst

• Value

Summarize a collection of records saved in Rewst's built-in storage. Instead of handing back every record, it hands back totals, counts, and averages, sorted into groups. If you've used a pivot table or a summary report in a spreadsheet, it's the same idea. Use it to answer questions like:

• "How many mismatches did we find for each customer?"

• "What's the total billing difference per month?"

• "What's the average number of fixes per technician?"

Configuration Fields

• Scope - Which storage area to look in: either just this organization, or the one your MSP organization shares with the customer organizations under it

• Collection - Which "spreadsheet" to summarize

• Record key prefix - another way to narrow things down, by only including records whose ID starts with certain text

• Group by - what to sort the rows into groups by, like customer, month, or status

• Metrics - what to calculate for each group: count (how many), sum (total), average, min (smallest), max (largest), or count true (how many are marked "yes")

• Filters - only include certain rows, like "only this month" or "only mismatches"

  • You can only group by and calculate on fields that are indexed, meaning fields the storage has been set up to search and sort quickly— if a field you want doesn't work here, it probably isn't one of the indexed fields

• Order by - sort the results, like "biggest totals first"

• Limit - Only return the top few groups, like "top 10 customers"

• Timeout (seconds) - maximum execution time for the datastore operation

Savea a whole batch of records into Rewst's built-in storage in one go. It's the step that fills up the collections that Aggregate Records summarizes. For each record, the step either adds it if it's new or updates it if a record with the same ID already exists.

Choose record keys carefully. Use something that truly identifies each item, like an account number. If two different items share a key, the second overwrites the first. If the same item gets a different key each run, you'll end up with duplicate rows instead of updates.

Configuration Fields

• Scope - Which storage area to save to: either just this organization, or the one your MSP organization shares with the customer organizations under it

• Collection - Which area to save into

• Items - The list of records to save; each one has a record key and its data

• Indexed fields - which details to make searchable and summarizable, like customer, status or amount

  • Indexed Fields matter later; if you'll want a report "by customer," list the customer field here.

• TTL (seconds) - how long to keep the records before they're cleared automatically; leave it blank or at 0 to keep them indefinitely

• Timeout (seconds) - maximum execution time for the datastore operation

This node tells you how many records in a Rewst storage collection match what you're looking for. It gives back just the number, not the records themselves. Use it for:

• Decision-making: "If there are more than 10 mismatches, alert a manager. Otherwise, carry on quietly." Put an If/Else step after the count to do this.

• Quick reporting: drop a count into an email or ticket, like "12 accounts need review."

• Checking before doing work: "Are there any unprocessed records? If the count is 0, stop here."

Configuration Fields

• Scope - which storage area to look in: either just this organization, or the one your MSP organization shares with the customer organizations under it

• Collection - which area to count in

• Record key prefix - only count records whose ID starts with certain text, like every ID beginning with acme-

• Filters - only count rows that match certain conditions: require all of your conditions ("mismatch and Acme Corp") or any of them ("Acme Corp or Bright Dental"); Leave this empty to count everything

• Timeout (seconds) - maximum execution time for the datastore operation

Permanently remove one saved item from Rewst's built-in storage. You can type the location in yourself, or have it come from an earlier step in the workflow, like "the ticket number we just got."

Configuration Fields

• Scope - which storage area to look in: either just this organization, or the one your MSP organization shares with the customer organizations under it

• Collection - which area to look in to find the record

• Record key - the label on the folder you want to delete, such as cw_company_123; you can type it in, or pull it from an earlier step, like a ticket number

• Timeout (seconds) - maximum execution time for the datastore operation

Look up one saved record and bring its contents into your workflow so later steps can use it. It's the opposite of Delete Record: it reads the folder instead of throwing it away. It only reads and never deletes or makes changes. Use it to:

• Remember something from an earlier run, like "what did we last record for this customer?"

• Check before acting, like "have we already handled this ticket?"

• Look up a match, like finding which company in one system lines up with a company in another.

To search, filter, or fetch a list of records, use the Query Records node instead.

Configuration Fields

• Scope - which storage area to look in: either just this organization, or the one your MSP organization shares with the customer organizations under it

• Collection - the location to look in, such as customer_map

• Record key - the label of the folder you want, such as cw_company_123

• Timeout (seconds) - maximum execution time for the datastore operation

Configuration Fields

• Scope - which storage area to look in: either just this organization, or the one your MSP organization shares with the customer organizations under it

• Collection - which area to count in

• Record key prefix - only count records whose ID starts with certain text, like every ID beginning with acme-

• Filters - only count rows that match certain conditions: require all of your conditions ("mismatch and Acme Corp") or any of them ("Acme Corp or Bright Dental"); Leave this empty to count everything

• Timeout (seconds) - maximum execution time for the datastore operation

Upsert combines update and insert. When this node runs, it looks for a row with the ID you give it:

• If the row already exists, it updates that row with your new information.

• If it doesn't exist yet, it creates a new row.

This means you don't have to check first and then decide whether to create or update. The node takes care of both cases. Queries are cursor-paginated. Use this for reference data like mapping tables or small ledgers.

Configuration Fields

• Scope - which storage area to look in: either just this organization, or the one your MSP organization shares with the customer organizations under it

• Collection - which area to save into; if it doesn't exist yet, it's automatically created

• Record key - the unique ID for the row, like a name tag

• Data - the information you want stored in the row, such as status, owner or region

• Indexed fields - the fields you'll want to search or sort by later (for example status); listing them here makes it possible to filter on them with a "Query Records" node

• TTL (seconds) - how long to keep the records before they're cleared automatically; leave it blank or at 0 to keep them indefinitely

• Timeout (seconds) - maximum execution time for the datastore operation

Build a JSON Web Token (JWT) to use as a digital pass your workflow can show to another system to prove who it is or what it's allowed to do. Use it for:

• Connecting to certain cloud services or vendor APIs that require this kind of sign-in

• Giving another system a short-lived pass to access something

• Proving to a partner system that a request really came from you

Keep the signing key secret. Anyone who has it can make passes that look like yours. Store it somewhere protected, not typed out in plain view.

Configuration Fields

• Algorithm - the signing algorithm: HS256/384/512 (shared secret) or

  RS/ES 256/384/512; A mismatch between algorithm and key hard-fails

• Claims - the JSON object of claims to sign

• Signing key - the HS secret or an RS/ES private key in PEM form

• Key encoding - how to decode the key: text, base64, base64url, hex, or pem

• Claim options - optional helpers for the iat, exp, nbf, and jti time claims

Read what's written in a JSON Web Token (JWT) acting as a digital pass. Note that this node doesn't check whether the pass is genuine. Give the node a JWT and it turns that back into readable information. Use it for:

• Troubleshooting: see what's on a pass another system gave you, so you can work out why something isn't working.

• Checking the expiration time: see when a pass runs out, so the workflow can get a new one before it stops working.

• Pulling out a detail: grab something like a user ID or account name from a pass you already trust.

"Decoded" doesn't mean "genuine." Anyone can make a pass that decodes perfectly, so a successful decode proves nothing about who sent it. If the workflow is going to trust the pass, for example to decide whether to let a request through, use Verify JWT. Verify checks the signature and expiration and only sends valid passes down the "valid" path.

Configuration Fields

• Token (required) - the JWT to decode.

• Strictness - how strictly to reject malformed structure (strict or lenient).

• Return part - which piece to return: payload (default), header, or both.

Check whether a JSON Web Token (JWT) digital pass is genuine before your workflow trusts it. It reads the token, checks that it isn't a fake, checks that it hasn't expired, and then decides if access is deserved

Configuration Fields

• Token - the JWT to verify

• Allowed algorithms - the algorithms you accept; never trust the token's own

  header alone; list the algorithms you expect here

• Verification key - the HS shared secret or the RS/ES public key PEM

• Key encoding - text, base64, base64url, hex, or pem

• Strictness - how strictly to reject malformed structure

• Claim validation toggles

  • Require expiration - reject passes that don't have an expiration time

  • Require not before - reject passes that don't have a start time

  • Expected issuer - only accept passes from this sender, like "must come from Acme's system"

  • Expected audience - only accept passes meant for you; stop a pass made for another system from being reused on yours

  • Required claims - specific pieces of information that must be written on the pass

  • Clock-skew tolerance in seconds - allow a few seconds of leeway, in case the two systems' clocks don't match exactly

Delete an org variable. When deleting a shared MSP value, you can also cascade the deletion to child orgs.

Configuration Fields

• Name

• Scope

  • Tenant - set isolated to this organization

  • MSP subtree (shared) - share across the MSP org tree; requires MSP-root permissions for shared write setting

  • Timeout (seconds) - maximum execution time for the datastore operation

Read an org variable by name for the current organization. By default, it checks the org value first, then falls back the shared MSP parent org value if no local override exists.

Configuration Fields

• Name

• Fallback toggle - when enabled, check the org value first and then the parent MSP org value

• Default

• Timeout (seconds) - maximum execution time for the datastore operation

List org variables for the current organization. The default all scope returns the merged effective view where organizatoin overrides win over shared MSP values.

Configuration Fields

• Scope

  • All - list the merged effective view across org and shared scopes

  • Tenant - set isolated to this organization

  • MSP subtree (shared) - share across the MSP org tree; requires MSP-root permissions for shared write setting

• Category

  • General

  • Secret

• Name prefix

Create or update an org variable through the dedicated org variable service. Use cascade to write the shared MSP default instead of a child org-local value.

Configuration Fields

• Name

• Value

• Category

  • General

  • Secret

• Write Shared MSP value toggle - when enabled, write hte shared MSP default instead of a child org-local value

• Description - optional human-readable description for operators

Take a timestamp, add or subtract an amount of time, or give a new timestamp. It has the same input and same output every time. Whereas Calculate Time node produces a new date, the Compare Times node tells you the relationship between two existing dates. If you're asking 'is this overdue,' use Compare Times. If you're asking 'when is this due,' use Calculate Time.

• A bad input timestamp won't fail the node.

• If a unit is mispelled or resolves to something unexpected, the node returns the input timestamp unchanged with no error at all.

• Timezone handling depends entirely on what your Time Format pattern captures.

• One operation is allowed per node. 'Plus 2 days and 4 hours' would need two nodes chained, or an expression node.

Configuration Fields

• Input time - the starting timestamp, usually a reference to upstream data

• Time format - how the input timestamp will be written

• Operation - Add or Subtract

• Amount - how many units, with a minimum of 0 in the field; don't use negative numbers

• Unit - Milliseconds, Seconds, Minutes, Hours, Days, Weeks, Months or Years

  • Months and Years are truncated to whole numbers

  • Month arithmetic can overshoot - for example, adding one month to January 31 doesn't give you February 28 and instead rolls into March

Take two timestamps and have the node tell you which is earlier. It routes the workflow down one of three parts, and reports how far apart they are. You could compare dates in an if/else, but that would rewire hand-writing date parsing in a template. The Compare Times node gives you the three routing paths natively, with a gap between the two times as a number you can use downstream, and a per-field format pattern.

• Rounding decides the routing. The gap is computed, then rounded to your difference decimals, with the rounded value determining the branch.

• Don't expect a negative number to tell you the date is in the past. It's an absolute value.

• A bad timestamp will fail the node.

• An unrecognized difference unit will become seconds.

• There is no timezone handling beyond the patterns.

Configuration Fields

Time A - first timestamp, typically the thing being tested, for example a due date

Time B - second timestamp, typically the reference, for example now

Time A format - pattern for parsing time A

Time B format - pattern for parsing time B

Difference unit - unit for the reported gap: Milliseconds, Seconds, Minutes, Hours, Days, Weeks

Difference decimals - decimal precision for the gap: minimum of 0

Rewrite a timestamp from one text format into another. The moment in time doesn't change, only how it's written changes. Chain it after the Calculate Time node if you need a computed date in a different format.

• A bad timestamp does not fail the node. If the input doesn't match your input format, the node will continue the workflow down the success path, without notifying of failure.

• Converting a timestamp with milliseconds into a pattern without them discards precision from the time_out. Use timestamp if you need the full value.

• There's no timezone conversion. It can't shift a timestamp between timezones.

• Use strftime patterns only— %Y-%m-%d— not go layouts and not YYY-MM-DD tokens.

Configuration Fields

• Input time - the timestamp to convert

• Input format - the pattern describing how the input is currently written

• Output format - the pattern for how you want it written

Note that the two defaults differ: input assumes ISO 8601 with a Z, output defaults to a SQL-style space-separated timestamp. Left untouched, this node converts ISO to SQL format.

Return the current timestamp in whatever format you pick. There are no inputs.

The output includes: value, format, category, timezone, timestamp, and unixMilliseconds.

• Everything is UTC. The node takes the workflow's clock and forces it to UTC before formatting.

• There is no timezone field.

• The clock is the workflow's, not the wall clock.

• A bad format fails the node.

• Custom pattern will be ignored unless format is set to custom.

Configuration Fields

• Format - which of the 16 output formats to use

  • │ ISO 8601 (UTC) │ 2025-12-31T23:59:59.000Z │ string │

  • │ ISO 8601 (UTC, no milliseconds) │ 2025-12-31T23:59:59Z │ string │

  • │ ISO 8601 (local offset) │ 2025-12-31T23:59:59.000-05:00 │ string │

  • │ RFC 3339 │ 2025-12-31T23:59:59.000Z │ string │

  • │ RFC 2822 (Email/HTTP) │ Wed, 31 Dec 2025 23:59:59 GMT │ string │

  • │ SQL Timestamp (UTC) │ 2025-12-31 23:59:59 │ string │

  • │ ISO Date │ 2025-12-31 │ string │

  • │ ISO Time │ 23:59:59 │ string │

  • │ Unix Timestamp (seconds) │ 1767225599 │ number │

  • │ Unix Timestamp (milliseconds) │ 1767225599000 │ number │

  • │ Unix Timestamp (microseconds) │ 1767225599000000 │ number │

  • │ Day of Week │ Monday │ string │

  • │ Day of Month │ 15 │ string │

  • │ Day of Year │ 365 │ string │

  • │ Week of Year │ 52 │ string │

  • │ Month │ December │ string │

  • │ Custom Format │ whatever your pattern produces │ string │

• Custom pattern - a pattern only used when format is set to custom