Data Transformation
Upper Case
Description
This operations helps to convert a given key value into Upper Case from any JSON Dataset. This operations take place while data is in-flight
Number of Parameters : 1
Parameter : Uppercase
Provide comma separated list of keys in double quotes to convert the defined key values into Upper Case
Below is a example where we are converting the value of first_name and last_name into Upper Case
"first_name", "last_name"
Lower Case
Description
This operations helps to convert a given key value into Lower Case from any JSON Dataset. This operations take place while data is in-flight
Number of Parameters : 1
Parameter : Lowercase
Provide comma separated list of keys in double quotes to convert the defined key values into Lower Case
Below is a example where we are converting the value of first_name and last_name into Lower Case
"first_name", "last_name"
Data Type
Description : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Data type operation refers to the type of data that a variable, object, or expression can hold or produce. It determines the kind of data that can be stored, how the data is stored in memory, and what operations can be performed on the data.
Number of Parameters : 4
Parameter : Boolean
XXXXXXXXXXXXXXXXXXXXXA boolean value can be either true or false. It is not enclosed in quotes.
Example: true or false
Parameter : Float
XXXXXXXXXXXXXXXXXXXXXXFloat: Number: A number can be an integer or a floating-point number. It is not enclosed in quotes.
Example: 34 or 3.14
Parameter : Integer
XXXXXXXXXXXXXXXXXXXXXXAn integer is a data type used to represent whole numbers (positive, negative, or zero) without a fractional component.
Example: -1,0,1
Parameter : Date Time
Date and time are represented using a data type called datetime, which is used to represent a specific point in time. A datetime data type typically includes both a date and a time component, and may also include a time zone.
Examples-%d/%m/%Y or dd/mm/yyyy, %d/%m/%y or dd/mm/yy
XXXXXXXXXXXXXXXXXXXXXX
Append
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Append operation is used for adding or concatenating one or more elements to the end of an existing sequence or data structure.
Number of Parameters : 1
Parameter : Append
XXXXXXXXXXXXXXXXXXXXXBy adding new elements to the end of an existing data structure, the append operation can help to extend or modify the data structure in a flexible and efficient way.
Example
Title Case
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Title Case operation is used to differentiate between multiple entities so each part should be capitalized as its own separate entity.
Number of Parameters : 1
Parameter : Title Case
XXXXXXXXXXXXXXXXXXXXX
case converts a given key value into title case
Any given key name comma separated in Double Quotes
Example
Data Extractor
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 2
Parameter : Data_Extractor
XXXXXXXXXXXXXXXXXXXXX
Parameter :Data_Extractor_Keys
XXXXXXXXXXXXXXXXXXXXX
Trim
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 1
Parameter : Trim
XXXXXXXXXXXXXXXXXXXXX
JSON to String
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 1
Parameter : Json2string
XXXXXXXXXXXXXXXXXXXXX
String to JSON
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 1
Parameter : String2json
XXXXXXXXXXXXXXXXXXXXX
JSON to XML
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 2
Parameter : Key_data
XXXXXXXXXXXXXXXXXXXXX
Parameter : Response_key
XXXXXXXXXXXXXXXXXXXXX
XML to JSON
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 2
Parameter : Get_key
XXXXXXXXXXXXXXXXXXXXX
Parameter : Response_key
XXXXXXXXXXXXXXXXXXXXX
Base64 Encoding
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 1
Parameter : Base64_encode
XXXXXXXXXXXXXXXXXXXXX
Base64 Decoding
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 1
Parameter : Base64_decode
XXXXXXXXXXXXXXXXXXXXX
Generate Array Sequence Number
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 2
Parameter : Sequence_key
XXXXXXXXXXXXXXXXXXXXX
Parameter : Sequence_number_key
XXXXXXXXXXXXXXXXXXXXX
Send Keys top of Root
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 1
Parameter : Column_to_root
XXXXXXXXXXXXXXXXXXXXX
Today Timestamp
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 2
Parameter : Date_format
XXXXXXXXXXXXXXXXXXXXX
Parameter : Datetime_key
XXXXXXXXXXXXXXXXXXXXX
Round
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 2
Parameter : Round_keys
XXXXXXXXXXXXXXXXXXXXX
Parameter : Decimal_key_number
XXXXXXXXXXXXXXXXXXXXX
Calculator
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 2
Parameter : Calculation_keys
XXXXXXXXXXXXXXXXXXXXX
Parameter : New_calculation_keys
XXXXXXXXXXXXXXXXXXXXX
Date Analytics
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 4
Parameter : Data_field_key
XXXXXXXXXXXXXXXXXXXXX
Parameter : Fiscal_month_start
XXXXXXXXXXXXXXXXXXXXX
Parameter : Date_column
XXXXXXXXXXXXXXXXXXXXX
Parameter : Weekday
XXXXXXXXXXXXXXXXXXXXX
Repeat First Row Values
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Number of Parameters : 2
Parameter : Source_key
XXXXXXXXXXXXXXXXXXXXX
Parameter : Fields_to_repeat_value
XXXXXXXXXXXXXXXXXXXXX