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 helps to define 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 can be converted into every key's string value into a Boolean value. In JSON data, Booleans do not contain double quotes.
Example: true or false
Parameter : Float
Convert any string like float into JSON data type float.
Example: "Amount"
Parameter : Integer
Convert any string like integer into JSON data type integer and also converts any string like float into integer and convert a float data type into integer.
Example: "Quantity"
Parameter : Date Time
Can convert any string like date into JSON data type date and can change the format of date.
From date format : The date/datetime format in which the user is defining their date/datetime.
To date format : The date/datetime format in which the user wants to convert their date/datetime.
Examples-["key_name","From date format","To date format"]
Append
Description:
Append operation helps in 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 helps 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 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 in a specific format required by the user.
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 helps to convert 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 helps in storing the values.
Round
Description:
Round operation is used to reduce a number to a specific number of decimal places, where the numbers need to be rounded off.
.
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:
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
Calculation_keys are used when keys with calculating formula is available.
Parameter : New_calculation_keys
New_calculation_keys used to store the calculated values.
Date Analytics
Description:
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
Data_field_key is a name or code that is used to identify a particular data field.
Parameter : Fiscal_month_start
Fiscal_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
Date_column is used for new date column key name for saving data.
Parameter : Weekday
Weekday is used to specify the starting of the week.
Repeat First Row Values
Description:
Repeat First Row Values operations are 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
Source_key helps in reading the dataset from a single line.
Parameter : Fields_to_repeat_value
Fields_to_repeat_value is an array of column name's whose first row value we want to repeat.