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
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
A boolean value can be either true or false. It is not enclosed in quotes.
Example: true or false
Parameter : Float
Float: 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
An 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
Append
Description:
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
By 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:
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
Title case converts a given key value into title case Any given key name comma separated in double quotes.
Example
Data Extractor
Description:
Data Extractor operation is designed to extract specific data from various sources. The extracted data can be in various formats, including structured or unstructured data.
Number of Parameters : 2
Parameter : Data_Extractor
Data_Extractor is used to extract Keys and its value from a JSON response
Parameter :Data_Extractor_Keys
XXXXXXXXXXXXXXXXXXXXX
Trim
Description:
Trim operation is used to remove unnecessary part from the given key's value.
Number of Parameters : 1
Parameter : Trim
XXXXXXXXXXXXXXXXXXXXX
JSON to String
Description:
JSON to String operation is used to convert JavaScript object or value as its parameter and returns a JSON string that represents the object. The resulting JSON string can be used to store or transmit data in a structured format.
Number of Parameters : 1
Parameter : Json2string
XXXXXXXXXXXXXXXXXXXXX
String to JSON
Description:
String to JSON operation is used to converts a string object or value as its parameter and returns a JSON string that represents the object.
Number of Parameters : 1
Parameter : String2json
XXXXXXXXXXXXXXXXXXXXX
JSON to XML
Description:
JSON to XML operation is used to convert JSON to XML format.
Number of Parameters : 2
Parameter : Key_data
XXXXXXXXXXXXXXXXXXXXXKey_data converts the provided Key's value from JSON to XML.
Parameter : Response_key
XXXXXXXXXXXXXXXXXXXXXResponse_key take note of the converted value under the specified key name which is easy to access.
XML to JSON
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
XML to JSON operation is used to convert XML to JSON format.
Number of Parameters : 2
Parameter : Get_key
Get_key converts the provided Key's value from XML to JSON
XXXXXXXXXXXXXXXXXXXXX.
Parameter : Response_key
XXXXXXXXXXXXXXXXXXXXXResponse_key take note of the converted value under the specified key name which is easy to access.
Base64 Encoding
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Base64 operation is used when the user want to convert some specific key to base64, the user can use multiple
keys if they require.
Number of Parameters : 1
Parameter : Base64_encode
XXXXXXXXXXXXXXXXXXXXX
Base64 Decoding
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Base64 decoding operation is used to converting a Base64-encoded string back to its original data format.
Number of Parameters : 1
Parameter : Base64_decode
XXXXXXXXXXXXXXXXXXXXXConverts the provided key's base64 value into a string by decoding it.
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
Today Timestamp operation is used to any time stamp to the required date and time format.
Number of Parameters : 2
Parameter : Date_format
XXXXXXXXXXXXXXXXXXXXXDate_format used to Pass the required format.
Parameter : Datetime_key
Datetime_key XXXXXXXXXXXXXXXXXXXXXgives the name of key in which the user wants to save their date for easy access.
Round
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Round operation is used to reduce a number to a specific number of decimal places, where the needs to be roundoff.
Number of Parameters : 2
Parameter : Round_keys
XXXXXXXXXXXXXXXXXXXXXRound_keys is used to access the specific key that needs to be roundoff.
Parameter : Decimal_key_number
Decimal_key_number specifies XXXXXXXXXXXXXXXXXXXXXwhich decimal places the user needs.
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