Formatter

Format data based on specified conditions

Actions

Steps this node can perform. Add one from Add a step, then pick the action.

DateTime Add

Add to a date/time value

Settings

Field	Type	Required	Description
Input Date	Text	Yes	Input date string
From Format	Choice		Input date format Options: `RFC3339 (2006-01-02T15:04:05Z07:00)`, `ISO 8601 Date (2006-01-02)`, `ISO 8601 DateTime (2006-01-02T15:04:05)`, `Japanese Date (2006/01/02)`, `Japanese DateTime (2006/01/02 15:04:05)`, `Japanese Full (2006年01月02日)`, `Database DateTime (2006-01-02 15:04:05)`, `Unix Timestamp`, `Custom`
Custom From Format	Text		Enter your custom input date format using Go time format layout (e.g., 2006-01-02)
Expression	Text	Yes	Date math expression that adds or subtracts time units. Supports operations like '+1d', '-2h', '+3m', etc. Valid units: year/y, month/m, day/d, hour/h, minute/min/M, second/s. Examples: '+1 day -2 hours', '+5 days', '-3 months', '+1y -6m'. Multiple operations can be chained together.
To Format	Choice	Yes	Output date format Options: `RFC3339 (2006-01-02T15:04:05Z07:00)`, `ISO 8601 Date (2006-01-02)`, `ISO 8601 DateTime (2006-01-02T15:04:05)`, `Japanese Date (2006/01/02)`, `Japanese DateTime (2006/01/02 15:04:05)`, `Japanese Full (2006年01月02日)`, `Database DateTime (2006-01-02 15:04:05)`, `Unix Timestamp`, `Custom`
Custom To Format	Text		Enter your custom output date format using Go time format layout (e.g., 2006-01-02)

Output

Later steps use this data by picking this step in the $ picker. For example, output_date is $.<step ID>.output.output_date.

json

{
  "output_date": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`output_date`	Text	Resulting date string

DateTime Compare

Compare two date/time values

Settings

Field	Type	Required	Description
Start Date	Text	Yes	The date to compare.
End Date	Text	Yes	The date to compare.
Start Date Format	Text		The format of the start date.
End Date Format	Text		The format of the end date.

Output

Later steps use this data by picking this step in the $ picker. For example, dates_swapped is $.<step ID>.output.dates_swapped.

json

{
  "dates_swapped": false,
  "days_difference": 0,
  "hours_difference": 0,
  "minutes_difference": 0,
  "seconds_difference": 0,
  "same_date": false
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`dates_swapped`	Yes / No	True if start_date is after end_date and the dates were swapped.
`days_difference`	Number	Difference in days.
`hours_difference`	Number	Difference in hours.
`minutes_difference`	Number	Difference in minutes.
`seconds_difference`	Number	Difference in seconds.
`same_date`	Yes / No	True if start_date and end_date are the same.

DateTime Extract

Extract a part of a date/time value (year, month, day, hour, minute, second).

Settings

Field	Type	Required	Description
Input Date	Text	Yes	The date to extract from.
Part	Choice	Yes	The part of the date to extract (e.g., 'year', 'month', 'day', 'hour', 'minute', 'second'). Options: `Year`, `Month`, `Day`, `Hour`, `Minute`, `Second`
From Format	Choice		The format of the date to extract from (optional, default RFC3339). Options: `RFC3339 (2006-01-02T15:04:05Z07:00)`, `ISO 8601 Date (2006-01-02)`, `ISO 8601 DateTime (2006-01-02T15:04:05)`, `Japanese Date (2006/01/02)`, `Japanese DateTime (2006/01/02 15:04:05)`, `Japanese Full (2006年01月02日)`, `Database DateTime (2006-01-02 15:04:05)`, `Unix Timestamp`, `Custom`
Custom Format	Text		Enter your custom date format using Go time format layout (e.g., 2006-01-02)

Output

Later steps use this data by picking this step in the $ picker. For example, value is $.<step ID>.output.value.

json

{
  "value": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`value`	Number	The extracted value.

DateTime Format

Format a date/time value to a specified format and timezone

Settings

Field	Type	Required	Description
Input Date	Text	Yes	The date to format.
From Format	Choice		The format of the date to format. Options: `RFC3339 (2006-01-02T15:04:05Z07:00)`, `ISO 8601 Date (2006-01-02)`, `ISO 8601 DateTime (2006-01-02T15:04:05)`, `Japanese Date (2006/01/02)`, `Japanese DateTime (2006/01/02 15:04:05)`, `Japanese Full (2006年01月02日)`, `Database DateTime (2006-01-02 15:04:05)`, `Unix Timestamp`, `Custom`
Custom From Format	Text		Enter your custom input date format using Go time format layout (e.g., 2006-01-02)
To Format	Choice	Yes	The format to format the date to. Options: `RFC3339 (2006-01-02T15:04:05Z07:00)`, `ISO 8601 Date (2006-01-02)`, `ISO 8601 DateTime (2006-01-02T15:04:05)`, `Japanese Date (2006/01/02)`, `Japanese DateTime (2006/01/02 15:04:05)`, `Japanese Full (2006年01月02日)`, `Database DateTime (2006-01-02 15:04:05)`, `Unix Timestamp`, `Custom`
Custom To Format	Text		Enter your custom output date format using Go time format layout (e.g., 2006-01-02)
To Timezone	Choice		The timezone to format the date to.
From Timezone	Choice		The timezone of the date to format.

Output

Later steps use this data by picking this step in the $ picker. For example, formatted_date is $.<step ID>.output.formatted_date.

json

{
  "formatted_date": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`formatted_date`	Text	The formatted date.

DateTime Timezone Convert

Convert a date/time value from one timezone to another.

Settings

Field	Type	Required	Description
Input Date	Text	Yes	The date/time string to convert.
From Timezone	Choice	Yes	The timezone of the input date (IANA name). Default: `UTC`
To Timezone	Choice	Yes	The target timezone (IANA name). Default: `UTC`
Format	Text		The output format (optional, default RFC3339).
Input Format	Text		The input format for parsing input_date (optional, default RFC3339).

Output

Later steps use this data by picking this step in the $ picker. For example, output_date is $.<step ID>.output.output_date.

json

{
  "output_date": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`output_date`	Text	The converted date/time string.

Number Currency Format

Format a number as a currency string.

Settings

Field	Type	Required	Description
Input Number	Number	Yes	The number to format as currency. Default: `0`
Currency	Choice	Yes	Currency code. Options: `US Dollar`, `Euro`, `Japanese Yen`, `British Pound`, `Chinese Yuan`, `Indian Rupee` Default: `JPY`
Locale	Choice		Locale for formatting. Options: `English (US)`, `German (Germany)`, `French (France)`, `Japanese (Japan)` Default: `ja-JP`
Minimum Fraction Digits	Number		Minimum decimal places (optional). Default: `0`
Maximum Fraction Digits	Number		Maximum decimal places (optional). Default: `0`

Output

Later steps use this data by picking this step in the $ picker. For example, output is $.<step ID>.output.output.

json

{
  "output": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`output`	Text	The formatted currency string.

Number Math

Perform a math operation on one or more numbers

Settings

Field	Type	Required	Description
Input Numbers	List	Yes	The numbers to perform the math operation on.
Operation Type	Text	Yes	The math operation to perform (add, subtract, multiply, divide, negative, positive). Default: `add`

Output

Later steps use this data by picking this step in the $ picker. For example, result is $.<step ID>.output.result.

json

{
  "result": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`result`	Number	Resulting number

Number Parse

Parse a value (string, int, float, bool) to a number.

Settings

Field	Type	Required	Description
Value	Text	Yes	The value to parse to a float number (string, int, float, bool).

Output

Later steps use this data by picking this step in the $ picker. For example, output_number is $.<step ID>.output.output_number.

json

{
  "output_number": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`output_number`	Number	The parsed number.

Number Round

Round a number to the nearest integer or to a specified number of decimal places.

Settings

Field	Type	Required	Description
Input Value	Number	Yes	The number to round. Default: `0`
Rounding Method	Choice	Yes	The method to use for rounding. Options: `Round (to nearest)`, `Floor (round down)`, `Ceil (round up)` Default: `round`
Decimal Points	Number		Number of decimal places (0 for integer rounding). Default: `0`

Output

Later steps use this data by picking this step in the $ picker. For example, output_number is $.<step ID>.output.output_number.

json

{
  "output_number": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`output_number`	Number	The rounded number.

Text Capitalize

Capitalize the input text

Settings

Field	Type	Required	Description
Input Text	Text	Yes	Input text

Output

Later steps use this data by picking this step in the $ picker. For example, output_text is $.<step ID>.output.output_text.

json

{
  "output_text": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`output_text`	Text	Capitalized text

Text Extract Emails

Extract all email addresses from the input text.

Settings

Field	Type	Required	Description
Input Text	Text	Yes	Input text to extract emails from.

Output

Later steps use this data by picking this step in the $ picker. For example, matches[0] is $.<step ID>.output.matches[0].

json

{
  "matches": [
    "string"
  ]
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`matches[]`	List	Extracted emails.

Text Extract Phones

Extract all phone numbers from the input text.

Settings

Field	Type	Required	Description
Input Text	Text	Yes	Input text to extract phone numbers from.

Output

Later steps use this data by picking this step in the $ picker. For example, matches[0] is $.<step ID>.output.matches[0].

json

{
  "matches": [
    "string"
  ]
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`matches[]`	List	Extracted phone numbers.

Text Extract URLs

Extract all URLs from the input text.

Settings

Field	Type	Required	Description
Input Text	Text	Yes	Input text to extract URLs from.

Output

Later steps use this data by picking this step in the $ picker. For example, matches[0] is $.<step ID>.output.matches[0].

json

{
  "matches": [
    "string"
  ]
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`matches[]`	List	Extracted URLs.

HTML to Markdown

Convert HTML to Markdown

Settings

Field	Type	Required	Description
Value	Text	Yes	The HTML to convert to Markdown.

Output

Later steps use this data by picking this step in the $ picker. For example, result is $.<step ID>.output.result.

json

{
  "result": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`result`	Text	The resulting Markdown.

Text Join

Join an array of strings with a delimiter

Settings

Field	Type	Required	Description
Parts	List	Yes	Array of strings to join.
Delimiter	Text	Yes	Delimiter to use for joining.

Output

Later steps use this data by picking this step in the $ picker. For example, result is $.<step ID>.output.result.

json

{
  "result": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`result`	Text	The joined string.

Markdown to HTML

Convert Markdown to HTML

Settings

Field	Type	Required	Description
Value	Text	Yes	The Markdown to convert to HTML.

Output

Later steps use this data by picking this step in the $ picker. For example, result is $.<step ID>.output.result.

json

{
  "result": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`result`	Text	The resulting HTML.

Text Parse JSON

Parse a JSON string to an object

Settings

Field	Type	Required	Description
Input Text	Text	Yes	The JSON string to parse.

Output

Later steps use this data by picking this step in the $ picker. For example, result is $.<step ID>.output.result.

json

{
  "result": {}
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`result`	Object	The parsed JSON object.

Text Remove HTML

Remove all HTML tags from the input text.

Settings

Field	Type	Required	Description
Input Text	Text	Yes	Input text to remove HTML from.

Output

Later steps use this data by picking this step in the $ picker. For example, output_text is $.<step ID>.output.output_text.

json

{
  "output_text": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`output_text`	Text	Text with HTML removed.

Text Replace

Replace occurrences of a substring with another substring in the input string.

Settings

Field	Type	Required	Description
Input	Text	Yes	The input string.
Find	Text	Yes	The substring to search for.
Replace With	Text		The replacement string (can be empty for removal).
Replace Mode	Choice	Yes	Choose whether to replace the first match only or all matches. Options: `Replace first match only`, `Replace all matches` Default: `all`

Output

Later steps use this data by picking this step in the $ picker. For example, result is $.<step ID>.output.result.

json

{
  "result": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`result`	Text	The resulting string after replacement.

Text Split

Split text by a delimiter

Settings

Field	Type	Required	Description
Value	Text	Yes	The text to split.
Delimiter Type	Choice	Yes	Select a common delimiter or choose 'Custom' to enter your own. Options: `Comma (,)`, `Space`, `Newline (\n)`, `Tab (\t)`, `Pipe (\|)`, `Semicolon (😉`, `Custom` Default: `,`
Custom Delimiter	Text		Enter your custom delimiter.
Split Behavior	Choice	Yes	Choose how to handle the split results. Options: `Keep All Parts`, `Remove Empty Parts`, `Trim and Remove Empty` Default: `keep_all`

Output

Later steps use this data by picking this step in the $ picker. For example, parts[0] is $.<step ID>.output.parts[0].

json

{
  "parts": [
    "string"
  ]
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`parts[]`	List	The resulting parts after splitting.

Text Substring

Extract a substring from the input text.

Settings

Field	Type	Required	Description
Input Text	Text	Yes	Input text to extract substring from.
Start	Number	Yes	Starting index (0-based). Default: `0`
Extract Mode	Choice	Yes	Choose how to define the end of the substring. Options: `Length`, `End Index` Default: `length`
Length	Number		Number of characters to extract. Default: `0`
End Index	Number		Ending index (exclusive, 0-based). Default: `-1`

Output

Later steps use this data by picking this step in the $ picker. For example, output_text is $.<step ID>.output.output_text.

json

{
  "output_text": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`output_text`	Text	Extracted substring.

Text To Lower Case

Convert text to lower case.

Settings

Field	Type	Required	Description
Input Text	Text	Yes	Input text to convert to lower case.

Output

Later steps use this data by picking this step in the $ picker. For example, output_text is $.<step ID>.output.output_text.

json

{
  "output_text": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`output_text`	Text	Lower case text.

Text To Upper Case

Convert text to upper case.

Settings

Field	Type	Required	Description
Input Text	Text	Yes	Input text to convert to upper case.

Output

Later steps use this data by picking this step in the $ picker. For example, output_text is $.<step ID>.output.output_text.

json

{
  "output_text": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`output_text`	Text	Upper case text.

Text Trim

Trim whitespace or specified characters from the input text.

Settings

Field	Type	Required	Description
Input Text	Text	Yes	Input text to trim.
Trim Mode	Choice	Yes	Mode of trimming to apply. Options: `Trim both sides`, `Trim start only`, `Trim end only`, `Custom characters` Default: `both`
Chars	Text		Characters to trim (optional, default is whitespace).

Output

Later steps use this data by picking this step in the $ picker. For example, output_text is $.<step ID>.output.output_text.

json

{
  "output_text": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`output_text`	Text	Trimmed text.

Generate Random

Generate a random integer or float in a given range.

Settings

Field	Type	Required	Description
Type	Text	Yes	Type of random value to generate: int, float, or string.
Min	Number		Minimum value (inclusive for int, inclusive for float). Optional. Default: 0. Ignored for string. Default: `0`
Max	Number		Maximum value (exclusive for int, exclusive for float). Optional. Default: 100 for int, 1 for float. Ignored for string. Default: `0`
Length	Number		Length of the generated string (required for type=string). Default: `0`
Charset	Text		Characters to use for string generation. Optional. Default: alphanumeric.

Output

Later steps use this data by picking this step in the $ picker. For example, value is $.<step ID>.output.value.

json

{
  "value": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`value`	Text	The generated random value.

Lookup Table

Given a key and table, find the matching value.

Settings

Field	Type	Required	Description
Key	Text	Yes	The key to look up in the table.
Table	Object	Yes	The lookup table as an object (map).
Default	Text		Default value to return if key is not found.

Output

Later steps use this data by picking this step in the $ picker. For example, value is $.<step ID>.output.value.

json

{
  "value": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`value`	Text	The value found for the key, or the default if not found.

Pick From List

Pick an item from a list using an operation (first, last, random).

Settings

Field	Type	Required	Description
Input	List	Yes	List of items to pick from.
Operation Type	Choice	Yes	The operation to perform (first, last, random, by_indices). Options: `First`, `Last`, `Random`, `By Indices` Default: `first`
Index Start	Number		Starting index (inclusive) for range selection. Required when operation_type is 'by_indices'. Use with index_end to create a range [start:end]. Default: `0`
Index End	Number		Ending index (exclusive) for range selection. Required when operation_type is 'by_indices'. Use with index_start to create a range [start:end]. If not specified or negative, goes to the end of the list. Default: `-1`
Default	Text		Default value to return if input is empty.

Output

Later steps use this data by picking this step in the $ picker. For example, picked is $.<step ID>.output.picked.

json

{
  "picked": ""
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
`picked`	Text	The picked item from the list.

Formatter ​

Actions ​

DateTime Add ​

DateTime Compare ​

DateTime Extract ​

DateTime Format ​

DateTime Timezone Convert ​

Number Currency Format ​

Number Math ​

Number Parse ​

Number Round ​

Text Capitalize ​

Text Extract Emails ​

Text Extract Phones ​

Text Extract URLs ​

HTML to Markdown ​

Text Join ​

Markdown to HTML ​

Text Parse JSON ​

Text Remove HTML ​

Text Replace ​

Text Split ​

Text Substring ​

Text To Lower Case ​

Text To Upper Case ​

Text Trim ​

Generate Random ​

Lookup Table ​

Pick From List ​

Formatter

Actions

DateTime Add

DateTime Compare

DateTime Extract

DateTime Format

DateTime Timezone Convert

Number Currency Format

Number Math

Number Parse

Number Round

Text Capitalize

Text Extract Emails

Text Extract Phones

Text Extract URLs

HTML to Markdown

Text Join

Markdown to HTML

Text Parse JSON

Text Remove HTML

Text Replace

Text Split

Text Substring

Text To Lower Case

Text To Upper Case

Text Trim

Generate Random

Lookup Table

Pick From List