Transformer Reference

ASCII

Removes non-printable characters and replaces non-ASCII characters with their closest ASCII equivalents.

Note: The ASCII transformer performs operations on the base level, not the extended set.

Parameter Format

Characters (STRING, required)

Usage Example

Input:

{firstname | ASCII, "Łukasz Gruba"}

Output:

Lukasz Gruba

COUNTRY_CODE_ISO3166

Transforms country code to ISO 3166 format.

ISO 3166 defines codes for the representation of country names, dependent territories, and their subdivisions

Parameter Format

Format (STRING, optional): [alpha2, alpha3, numeric], defaults to alpha2

Usage Example

Input:

{COUNTRY_CODE_ISO3166, "US", alpha3}

Output:

USA

DATE_FORMAT

Transforms dates to a different format using Go time layout syntax.

Parameter Format

Output Layout (STRING, required): Go time layout for output format. Input Layout (STRING, optional): Go time layout for input format

Usage Example

Input:

{start_date | DATE_FORMAT, "01/02/2006"}

Output:

This transformer formats date as MM/DD/YYYY

FIRST_N

Picks the first N characters of a string.

Parameter Format

Characters (STRING, required)

Length (NUMBER, required): Number of characters to return

Usage Example

Input:

{FIRST_N, "world", 4}

Output:

worl (This transformer takes the first four characters of the string.)

FROM_ENTITY_ATTRIBUTE

Transforms a string from an attribute of another entity in the graph.

Parameter Format

EntityType (STRING, required)

SourceAttribute (STRING, required),

TargetAttribute (STRING, required)

Usage Example

Input:

{FROM_ENTITY_ATTRIBUTE, "Employee", "ID", "ManagerID"}

Output:

Manager ID (for the employee)

LANGUAGE_RFC5646

Transforms language to RFC 5646 format.

RFC 5646 defines "Tags for Identifying Languages." It does not contain a fixed, exhaustive list of language codes within the RFC itself. Instead, it specifies the structure and rules for constructing language tags, which are then built using codes from various external standards and registries.

Parameter Format

Characters (STRING, required): String of a language name

Usage Example

Input:

{LANGUAGE_RFC5646, "Spanish"}

Output:

es

LAST_N

Picks the last N characters of a string, where N is the number of characters to return.

Parameter Format

Length (NUMBER, required)

Usage Example

Input:

{LAST_N, "helloworld", 5}

Output:

world

LEFT_PAD

Left pads a string with a character.

Parameter Format

Length (NUMBER, required), Pad (CHARACTER, optional): Default is space

Usage Example

Input:

{LEFT_PAD, "123", 5, "0"}

Output:

00123

LOOKUP

Transforms a value using a lookup table.

Parameter Format

Table Name (STRING, required),

Column Name (STRING, required), Return Column Name (STRING, required)

Usage Example

Input:

{LOOKUP, "IL001", "locationTable", "location_code", "city"}

Output:

Chicago

LOWER

Transforms all uppercase characters in a string to lower-case characters.

Parameter Format

Characters (STRING, required)

Usage Example

Input:

{LOWER, "HELLO"}

Output:

hello

LOWER_SNAKE_CASE

Transforms string to lowercase with underscores.

Parameter Format

Characters (STRING, required)

Usage Example

Input:

{LOWER_SNAKE_CASE, "Hello World"}

Output:

hello_world

NEXT_NUMBER

Generates a set of integers as strings.

Parameter Format

Integer (NUMBER, required), Length (NUMBER, required)

Usage Example

Input:

{NEXT_NUMBER, 2, 3}

Output:

"", "2", "3", "4"

Note: This transformer can also be used within a IF/ELSE conditional transformer for intelligent username generation with automatic fallback strategies.

PHONE_NUMBER_E164

Transforms a phone number into the E.164 format.

E. 164 numbers are formatted [+] [country code] [subscriber number including area code] and can have a maximum of fifteen digits. Parameter Format

Region (STRING, optional): ISO 3166-1 alpha-2 format

Usage Example

Input:

{PHONE_NUMBER_E164, "+1-800-555-1212"}

Output:

+18005551212

RANDOM_ALPHANUMERIC_GENERATOR

Generates a random alphanumeric string.

Parameter Format

Length (NUMBER, required)

Usage Example

Input:

{RANDOM_ALPHANUMERIC_GENERATOR, 8}

Output:

a1B2c3D4

Note: This transformer generated a alphanumeric string with eight characters.

RANDOM_NUMBER_GENERATOR

Generates a random number string.

Parameter Format

Length (NUMBER, required)

Usage Example

Input:

{RANDOM_NUMBER_GENERATOR, 4}

Output:

4829

Note: This transformer generated a random numeric string with four characters.

RANDOM_STRING_GENERATOR

Generates a random string.

Parameter Format

Length (NUMBER, required)

Usage Example

Input:

{RANDOM_STRING_GENERATOR, 6}

Output:

uFkLxw

Note: This transformer generated a random alpha string with six characters.

REMOVE_CHARS

Removes all instances of specified characters from a string.

Parameter Format

Characters (STRING, required): Characters to be removed

Usage Example

Input:

{REMOVE_CHARS, "[email protected]", "@", "."}

Output:

FirstLastexamplecom

REMOVE_DIACRITICS

Removes diacritics (accents, etc.) from input string.

Parameter Format

Characters (STRING, required)

Usage Example

Input:

{REMOVE_DIACRITICS, "José"}

Output:

Jose

REMOVE_DOMAIN

Removes the domain from an email address.

Parameter Format

Characters (STRING, required)

Usage Example

Input:

{REMOVE_DOMAIN, "[email protected]"}

Output:

pennylane

REMOVE_WHITESPACE

Removes all whitespace characters from a string.

Parameter Format

Characters (STRING, required)

Usage Example

Input:

{REMOVE_WHITESPACE, "First Last"}

Output:

FirstLast

REPLACE_ALL

Replaces all instances of one string with another.

Parameter Format

Original (STRING, required),

New (STRING, required)

Usage Example

Input:

{REPLACE_ALL, "hello world", " ", "_"}

Output:

hello_world

RIGHT_PAD

Right pads a string with a character.

Parameter Format

Length (NUMBER, required),

Pad (CHARACTER, optional): Default is space

Usage Example

Input:

{RIGHT_PAD, "123", 5, "0"}

Output:

12300

SPLIT

Splits a string and returns the string at the given index.

Parameter Format

Split String (STRING, required), Index (NUMBER, required)

Usage Example

Input:

{SPLIT, "[email protected]", "@", 0}

Output:

first.last

Note: This transformer generated the results where the index starts at zero (0).

SUB_STRING

Picks a substring from the original value.

Parameter Format

Offset (NUMBER, required), Length (NUMBER, required)

Usage Example

Input:

{SUB_STRING, "hello", 0, 3}

Output:

hel

TRIM

Removes any white spaces before and after a string.

Parameter Format

Characters (STRING, required)

Usage Example

Input:

{TRIM, " hello "}

Output:

hello

TRIM_CHARS

Removes all specified characters from the beginning and end of a string.

Parameter Format

Characters (STRING, required): Characters to be trimmed

Usage Example

Input:

{TRIM_CHARS, "....first.last----", ".-"}

Output:

first.last

TRIM_CHARS_LEFT

Removes all specified characters from the beginning of a string.

Parameter Format

Characters (STRING, required): Characters to be trimmed from the left

Usage Example

Input:

{TRIM_CHARS_LEFT, "....first.last----", ".-"}

Output:

first.last----

TRIM_CHARS_RIGHT

Removes all specified characters from the end of a string.

Parameter Format

Characters (STRING, required): Characters to be trimmed from the right

Usage Example

Input:

{TRIM_CHARS_RIGHT, "....first.last----", ".-"}

Output:

....first.last

UPPER

Transforms string to uppercase.

Parameter Format

Characters (STRING, required):

All lowercase characters to be converted to upper-case characters

Usage Example

Input:

{UPPER, "hello"}

Output:

HELLO

UPPER_CAMEL_CASE

Transforms string to upper camel case.

Parameter Format

Characters (STRING, required):

First characters of a string to be converted to upper-case characters for camel case

Usage Example

Input:

{UPPER_CAMEL_CASE, "hello world"}

Output:

Hello World

UPPER_SNAKE_CASE

Transforms string to uppercase with underscores.

Parameter Format

Characters (STRING, required):

All lower-case characters to be converted to uppercase characters with an underscore between strings

Usage Example

Input:

{UPPER_SNAKE_CASE, "hello world"}

Output:

HELLO_WORLD

UUID_GENERATOR

Generates a UUID.

A UUID (Universally Unique Identifier) is a 128-bit identifier used to uniquely identify information in computer systems.

Parameter Format

NONE

Usage Example

Input:

{UUID_GENERATOR}

Output:

123e4567-e89b-12d3-a456-426614174000

DATE_ADJUST_DAY

Adjusts date value based on hour, day, month, year inputs provided (example: 2021-01-01 00:00:00 with a DATE_ADJUST of "+1,2,3,-1" becomes "2020-04-03 01:00:00").

Parameter Format

Integer - date

Integer - hour

Integer - day

Integer - month

Integer-year

String (Optional) - Format

Usage Example

Input:

{activation_date | DATE_ADJUST,+1,2,3,-1}

{activation_date | DATE_ADJUST,+1,2,3,-1, "RFC3339"}

{activation_date | DATE_ADJUST,+1,2,3,-1, "2006-01-02T15:04:05Z07:00"}

DATE_ADJUST

Adjusts date value based on date and day.

Parameter Format

Integer - date

Integer - day

Usage Example

Input:

{activation_date | DATE_ADJUST_DAY,+1}

{activation_date | DATE_ADJUST_DAY,+1,"RFC3339"}

{activation_date | DATE_ADJUST_DAY,+1,"2006-01-02T15:04:05Z07:00"}

NOW

Returns the current time in UTC. An optional argument indicates the outgoing time format; by default, the RFC3339 format.

Parameter Format

String (Optional) - Format

Usage Example

Input:

{NOW}

{NOW, | "RFC3339"}

{NOW, "RFC3339"}

{NOW, "2006-01-02T15:04:05Z07:00"}

ASSUME_TIME_ZONE

Interprets the incoming time string as if it were in the specified time zone, then converts it to a UTC time. (example: if the input is "1/2/2025 11pm" and the defined time zone is "America/Los_Angeles" the function will treat "1/2/2025 11pm" as local time in Los Angeles and output the corresponding UTC time "1/3/2025 7am")

Parameter Format

String - Time Zone String (Optional) - Format

Usage Example

Input:

{activation_date | ASSUME_TIME_ZONE, "America/Los_Angeles"}

{activation_date | ASSUME_TIME_ZONE, "America/Los_Angeles", "RFC3339"}

{activation_date | ASSUME_TIME_ZONE, "-07:00"}

{activation_date | ASSUME_TIME_ZONE, "-07:00", "RFC3339"}

UTC_TO_TIME_ZONE

Interprets the incoming time string as if it were in UTC and then converts it to the specified time zone. (example: if the input is "1/2/2025 11pm" and the specified time zone is "America/Los_Angeles" the function will treat "1/2/2025 11pm" as the UTC time zone and output the corresponding "America/Los_Angeles" time "1/2/2025 3pm") Note: When using the time zone parameter, a named time zone ("America/Los_Angeles") accounts for daylight saving time, whereas a time zone offset ("-07:00") is always calculated from UTC, ignoring daylight saving time.

Parameter Format

String - Time Zone String (Optional) - Format

Usage Example

Input:

{activation_date | UTC_TO_TIME_ZONE, "America/Los_Angeles"}

{activation_date | UTC_TO_TIME_ZONE, "America/Los_Angeles", "RFC3339"}

{activation_date | UTC_TO_TIME_ZONE, "-07:00"}

{activation_date | UTC_TO_TIME_ZONE, "-07:00", "RFC3339"}