Mappers

The following mappers are available:

Name	Description
Cast: Boolean	The Cast: Boolean mapper converts a value into a boolean (true/false)
Cast: Float	The Cast: Float mapper converts a value into a float (1.00, 2.05, 10.50, etc)
Cast: Integer	The Cast: Integer mapper converts a value into an integer (1, 2, 3, 10, 25, etc)
Cast: String	The Cast: String mapper converts a value into a string (“abc”, “example”).
Chain of mappers	The chain mapper is used to execute a list of mappers.
Deserialize	The Deserialize mapper converts a string, for example in a XML, JSON, or CSV format into a JSON object.
Deserialize: Form URL encoded	The Deserialize: Form URL encoded mapper converts a Form URL encoded string into a JSON object.
Deserialize: JSON	Takes an input json string from the context and converts it to actual json.
Deserialize: URL encoded	Decodes an URL encoded string to plain text.
Deserialize: XML	If the context data contains an xml string it can be casted to usable data with this mapper.
Deserialize: YAML	The Deserialize: YAML mapper converts a string in YAML format into a JSON object.
Deserialize: cXML	If the context data contains a cXML string it can be casted to usable data with this mapper
Dictionary map	The Dictionary Map mapper converts input from one value into another. For example, the value “1” into “One”, “Yes” into “Si”, etc.
Ensure a valid filesystem destination	Ensures a valid destination is present in the filesystem
Filter: Allow only digits	Takes the input and makes sure all non numeric characters are removed.
Filter: Allow only letters	Takes the input and makes sure all characters other than letters are removed. It means it will also remove spaces.
Filter: Allow only letters and digits	Allow only letters and digits takes all the given input data and removes al characters except alphabetical characters and numbers.
Format: Date	Format: Date mapper takes input and converts the date to another format based on the given criteria.
Format: Number	Format: Number, takes the input and applies number formatting to it. Several input arguments can be used to get the desired result.
List: Concat to a string	The List: concat to a string mapper joins array elements with a string
List: Diff keys	The List: Diff keys mapper compares keys from a list against the keys from another list and returns the difference.
List: Diff values	The List: Diff values mapper compares a list against another list and returns the values in the list that are not present in the other list.
List: Extend with supplied data	The List: extend with supplied data mapper extends an list/array with the provided list. If any keys are already present in the original list it will overwrite the list with those values.
List: Fill list with value	The List: fill list with value mapper fills an array with the provided length and value.
List: Flip keys and values	The List: flip keys and values mapper switches the keys and values of a list.
List: Get column	The List: Get column mapper gets the values from a single property of the provided list.
List: Get count	The List: Get count mapper returns the number of items in a list.
List: Get keys	Gets the names of the keys from a list. The found keys can be used in further steps to convert or select data.
List: Get values	The List: Get values mapper returns the values from a list.
List: Implode to string	The List: implode to string mapper converts a list into a string.
List: Inherit from supplied data	Creates a list from the items in the supplied data.
List: Intersect keys	Returns a list of data items where all the keys exists in both the data and the supplied array.
List: Intersect values	Returns a list of data items where all the values exists in both the data and the supplied array.
List: Reverse values	Takes a list an reversed the order.
List: split into chunks	Takes a list and splits it based on the length value. Keys can be discarded or preserved.
Locale: Display region	Gets the region for the locale string in the supplied language.
Map when a condition applies	Apply mappers when the conditions apply.
Math: absolute value	Get the absolute value for a integer or float.
Math: ceil	Round to the next highest integer.
Math: floor	Round to the next lowest integer.
Math: round	Round number to the provided precision.
Object: Sort keys	Sort the keys of an object based on the provided sort method and direction.
Operator	Map a value based on the supplied operator.
Prepared operator	Apply the operator on every item of the left and right array values.
Serialize	The serialize mapper converts JSON data into the desired output format.
Serialize: Form URL encoded	The Serialize: Form URL encoded mapper converts a data structure like objects and arrays into a Form URL encoded string.
Serialize: JSON	The Serialize: JSON mapper converts a data structure like objects and arrays into a JSON formatted string.
Serialize: URL encoded	The Serialize: URL Encode mapper converts a data structure like objects and arrays into a URL encoded string.
Serialize: XML	The Serialize: XML mapper converts a data structure like objects and arrays into an XML formatted string.
Serialize: Xlsx	The Serialize: XLSX mapper converts a data structure like objects and arrays into a binary XLSX format.
Serialize: YAML	The Serialize: YAML mapper converts a data structure like objects and arrays into a YAML formatted string.
Serialize: cXML
Standard	Map a value to the ‘to’ value based on the comparator.
String: Add dispersion to a file name	Transform a string to make it suitable as a filename. Removing illegal characters (replacing . with _)
String: Append	Append a string to to the data.
String: Base64 decode	This is the opposite of the string-base64-encode. It takes the input string which should be an base64 encoded value and converts it back to a normal human readable value.
String: Base64 encode	Takes the input string and converts it to a base64 encoded value. It can be used for example to create an identifier based on certain values in the data.
String: Capitalize first word	Takes the given input string and converts the first letter to a capital. This only works when en phrase starts with a lowercase letter.
String: Convert character set of string	Convert a string from one encoding to another.
String: Convert encoding	Convert a string to the specified encoding. The from encoding must be known.
String: Convert to lowercase	Takes the given input and casts all letters to a lower case. The given input must be a valid string.
String: Convert to uppercase	Takes the given input and casts all letters to an upper case. The exact opposite of String: Convert to lowercase mapper.
String: Cut	Cut a string at the provided length value starting the count at the start value.
String: Decode HTML entities	HTML decode a string to human readable text.
String: Encode HTML entities	Encode all HTML entities in a string.
String: Explode to an array	Takes the given input string and converts it to an array/list based on a specified split character.
String: Explode to an array using a PCRE expression	Explode a string based on a supplied regex.
String: File basename	Map the file to a ‘basename’
String: File dirname	Map a string to a directory name.
String: File path info	Map a string to the file path info.
String: Hash	Hash a string with the provided algorithm, the output can be a string or binary.
String: PCRE replace	Replace part of a string based on the supplied regex.
String: Prepend	Prepend a value onto a string.
String: Replace	Replace within a string based on a string comparison.
String: Slugify	String: Slugify, takes the input and removes al non numeric and non alphabetic characters and replaces them with traits(-).
String: Strip HTML tags	Removes the HTML tags from a string. A set of tags can be supplied to be excluded.
String: Transliterate	Transliterate a string based on the supplied transliterator. Can be used to change UTF-16 code units into single characters.
String: Trim characters	Trim characters from the left or right side of a string.

Getting started

Connections

Data Transformation