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
Number of Parameters : 4
Parameter : Boolean
XXXXXXXXXXXXXXXXXXXXX
Parameter : Float
XXXXXXXXXXXXXXXXXXXXXX
Parameter : Integer
XXXXXXXXXXXXXXXXXXXXXX
Parameter : Date Time
XXXXXXXXXXXXXXXXXXXXXX
Append
Description
Number of Parameters : 1
Parameter : Append
XXXXXXXXXXXXXXXXXXXXX
Title Case
Description
Number of Parameters : 1
Parameter : Title Case
XXXXXXXXXXXXXXXXXXXXX
Data Extractor
Description
Number of Parameters : 2
Parameter : Data_Extractor
XXXXXXXXXXXXXXXXXXXXX
Parameter :Data_Extractor_Keys
XXXXXXXXXXXXXXXXXXXXX
Trim
Description
Number of Parameters : 1
Parameter : Trim
XXXXXXXXXXXXXXXXXXXXX
JSON to String
Description
Number of Parameters : 1
Parameter : Json2string
XXXXXXXXXXXXXXXXXXXXX
String to JSON
Description
Number of Parameters : 1
Parameter : String2json
XXXXXXXXXXXXXXXXXXXXX
JSON to XML
Description
Number of Parameters : 2
Parameter : Key_data
XXXXXXXXXXXXXXXXXXXXX
Parameter : Response_key
XXXXXXXXXXXXXXXXXXXXX
XML to JSON
Description
Number of Parameters : 2
Parameter : Get_key
XXXXXXXXXXXXXXXXXXXXX
Parameter : Response_key
XXXXXXXXXXXXXXXXXXXXX
Base64 Encoding
Description
Number of Parameters : 1
Parameter : Base64_encode
XXXXXXXXXXXXXXXXXXXXX
Base64 Decoding
Description
Number of Parameters : 1
Parameter : Base64_decode
XXXXXXXXXXXXXXXXXXXXX
Generate Array Sequence Number
Description
Number of Parameters : 2
Parameter : Sequence_key
XXXXXXXXXXXXXXXXXXXXX
Parameter : Sequence_number_key
XXXXXXXXXXXXXXXXXXXXX
Send Keys top of Root
Description
Number of Parameters : 1
Parameter : Column_to_root
XXXXXXXXXXXXXXXXXXXXX
Today Timestamp
Description
Number of Parameters : 2
Parameter : Date_format
XXXXXXXXXXXXXXXXXXXXX
Parameter : Datetime_key
XXXXXXXXXXXXXXXXXXXXX
Round
Description
Number of Parameters : 2
Parameter : Round_keys
Parameter : Decimal_key_number
XXXXXXXXXXXXXXXXXXXXX
Calculator
Description
Number of Parameters : 2
Parameter : Calculation_keys
XXXXXXXXXXXXXXXXXXXXX
Parameter : New_calculation_keys
XXXXXXXXXXXXXXXXXXXXX
Date Analytics
Description
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
Number of Parameters : 2
Parameter : Source_key
XXXXXXXXXXXXXXXXXXXXX
Parameter : Fields_to_repeat_value
XXXXXXXXXXXXXXXXXXXXX