Reference
Value Composer
Frontstack’s Value Composer is a powerful tool for transforming data. It allows you to chain together operations to create complex transformations. Below is an overview of the available operations:
Returns the number of elements in an array
Returns
Returns an array of all elements that satisfy a condition. Access each element of the array with the $item variable.
Returns
Finds and returns the first element of an array that satisfies a condition. Access each element of the array with the $item variable.
Returns
Returns the first element of an array
Returns
Joins an array of strings into a single string
Returns
Applies a function to each element of an array and returns the resulting array. Access each element of the array with the $item variable.
Returns
Extracts a portion of an array
Returns
Splits a string into an array of strings given a separator
Returns
Compares two values
Returns
Compares two values and returns true if the first is greater than the second
Returns
Returns whether a value is NULL
Returns
Returns true if all values are true
Returns
Splits the execution flow based on a condition
Returns
Divides two numbers (i.e.
Returns
Calculates the exponentiation of a number by another number (base^exponent)
Returns
Multiplies two numbers
Returns
Accesses a value of an object field with the given key
Returns
Handles an object composition by resolving its properties
Returns
Concatenates two strings
Returns
Returns the number of characters in a string
Returns
Pads a string to the left
Returns
Pads a string to the right
Returns
Replaces a value in a string
Returns
Converts a string to a slug with no spaces or special characters
Returns
Extracts a substring from a string
Returns
Converts a string to lowercase
Returns
Converts a string to uppercase
Returns
Trims whitespace from the beginning and end of a string
Returns
Converts a value to a boolean
Returns
Converts a value to a number. NULL is converted to 0
Returns
Converts a value to a string. NULL is converted to an empty string
Returns
Value Composer in the Data Feed merge step
Array Operations
count
Returns the number of elements in an array
The array to count elements in
number
filter
Returns an array of all elements that satisfy a condition. Access each element of the array with the $item variable.
The array to filter
The function to determine if the element should be included in the result
array<T>
findFirst
Finds and returns the first element of an array that satisfies a condition. Access each element of the array with the $item variable.
The array to find the first element of
The function to determine if the element should be returned
T
first
Returns the first element of an array
The array to get the first element from
T
join
Joins an array of strings into a single string
The array of strings to join
An optional separator to insert between the strings
string
map
Applies a function to each element of an array and returns the resulting array. Access each element of the array with the $item variable.
The array to map over
The function to apply to each element
array
slice
Extracts a portion of an array
The array to slice
The starting position (zero-based index)
The number of elements to extract
array
split
Splits a string into an array of strings given a separator
The string to split
The separator to use for splitting
array
Comparison Operations
equals
Compares two values
The first value to compare
The second value to compare
boolean
greaterThan
Compares two values and returns true if the first is greater than the second
The first value to compare
The second value to compare against
boolean
isNull
Returns whether a value is NULL
The value to check for NULL
boolean
Logic Operations
and
Returns true if all values are true
The first value to compare
The second value to compare
boolean
if
Splits the execution flow based on a condition
The condition to evaluate
The value to return if the condition is true
The value to return if the condition is false
T
Math Operations
divide
Divides two numbers (i.e. $numerator / $denominator)
The numerator for the division
The denominator for the division
number
exponent
Calculates the exponentiation of a number by another number (base^exponent)
The base number
The exponent number
number
multiply
Multiplies two numbers
The first number to multiply
The second number to multiply
number
Object Operations
get
Accesses a value of an object field with the given key
The key of the field to access
The object containing the field
T
object
Handles an object composition by resolving its properties
The properties of the object to resolve
object
Text Operations
concat
Concatenates two strings
The first string to concatenate
The second string to concatenate
An optional separator to insert between the concatenated strings
string
length
Returns the number of characters in a string
The string to measure length of
number
padLeft
Pads a string to the left
The original string
The length to pad to. If the length is negative, no padding takes place.
The character to pad with
string
padRight
Pads a string to the right
The original string
The length to pad to. If the length is negative, no padding takes place.
The character to pad with
string
replace
Replaces a value in a string
The original string
The substring to search for
The substring to replace with
Should the search be case sensitive?
string
slugify
Converts a string to a slug with no spaces or special characters
The string to convert to a slug
The separator to use in the slug. It will be used to replace spaces and special characters.
string
substring
Extracts a substring from a string
The string to extract from
The starting position
Length of the substring
string
toLower
Converts a string to lowercase
The string to convert to lowercase
string
toUpper
Converts a string to uppercase
The string to convert to uppercase
string
trim
Trims whitespace from the beginning and end of a string
The string to trim
string
Transform Operations
toBoolean
Converts a value to a boolean
The value to convert to a boolean, e.g. “false”, “0”, and [] will all be converted to false
boolean
toNumber
Converts a value to a number. NULL is converted to 0
The value to convert to a number
number
toString
Converts a value to a string. NULL is converted to an empty string
The value to convert to a string
string