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 booleanBoolean 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
Key_data converts the provided Key's value from JSON to XML.
Parameter : Response_key
Response_key take note of the converted value under the specified key name which is easy to access.
XML to JSON
Description:
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
.
Parameter : Response_key
Response_key take note of the converted value under the specified key name which is easy to access.
Base64 Encoding
Description:
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:
Base64 decoding operation is used to converting a Base64-encoded string back to its original data format.
Number of Parameters : 1
Parameter : Base64_decode
Converts 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:
Today Timestamp operation is used to any time stamp to the required date and time format.
Number of Parameters : 2
Parameter : Date_format
Date_format used to Pass the required format.
Parameter : Datetime_key
Datetime_key ghelps in storing the values.ives the name of key in which the user wants to save their date for easy access.
Round
Description:
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
Round_keys is used to access the specific key that needs to be roundoff.
Parameter : Decimal_key_number
Decimal_key_number specifies which decimal places the user needs.
Calculator
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Calculator operations are used when a calculated field with sustaining formulas relating to any particular process is provided.
Number of Parameters : 2
Parameter : Calculation_keys
XXXXXXXXXXXXXXXXXXXXXCalculation_keys are used when keys with calculating formula is available.
Parameter : New_calculation_keys
XXXXXXXXXXXXXXXXXXXXXNew_calculation_keys used to store the calculated values.
Date Analytics
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Date analytics operations are used to specify and define various date formats based on the specification.
Number of Parameters : 4
Parameter : Data_field_key
Data_field_key
XXXXXXXXXXXXXXXXXXXXXData_field_key is a name or code that is used to identify a particular data field.
Parameter : Fiscal_month_start
XXXXXXXXXXXXXXXXXXXXXFiscal_month_start is used to specify the start date of a fiscal month, which is a period of time used by organizations to track their financial performance.
Parameter : Date_column
XXXXXXXXXXXXXXXXXXXXXDate_column is used for new date column key name for saving data.
Parameter : Weekday
XXXXXXXXXXXXXXXXXXXXXWeekday is used to specify the starting of the week.
Repeat First Row Values
Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Repeat First Row Values operations is used when working with time series data or other data sets where values are expected to remain constant for a certain period of time.
Number of Parameters : 2
Parameter : Source_key
XXXXXXXXXXXXXXXXXXXXXSource_key helps in reading the dataset from a single line.
Parameter : Fields_to_repeat_value
XXXXXXXXXXXXXXXXXXXXXFields_to_repeat_value is an array of column name's whose first row value which the user wants to repeat.