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-named 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 can convert any string of boolean, float, integer and datetime into JSON datatype of boolean, float, integer and datetime.
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 dynamically or statically adds a new key with a value on the fly, which will add key and its value for each record.
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.
For dynamic value the user can use {{column_name}} where column_name is the incoming column in the data pipeline
Example
Title Case
Description:
It aids in the conversion of a given key value into title case.
Number of Parameters : 1
Parameter : Title Case
Title case converts a given key value into title case for any given key name comma separated in double quotes.
Example: "Titlecase":["amount","value"]
Data Extractor
Description:
Data Extractor operation is designed to extract specific data from JSON response. The data can be in various formats.
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
This helps to provide user defined keys. If left blank it will auto generate keys.
Example:
Trim
Description:
Trim helps in removing unnecessary parts from the given key's value as defined by the user.
Number of Parameters : 1
Parameter : It trims the given key's value, Provide comma separated list of keys in double quotes
Example:
JSON to String
Description:
JSON to String 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
Provide comma separated in double quotes, for the values that need to be converted.
Example: "json2string":["key1","key2"]
String to JSON
Description:
String to JSON 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
Provide comma separated in double quotes, for the values that need to be converted.
Example: "string2json":["key1","key2"]
JSON to XML
Description:
JSON to XML is used to convert JSON object or value as its parameter and returns a XML that represents the object. The resulting XML can be used to store or transmit data in a structured 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.
Example:
XML to JSON
Description:
XML to JSON is used to convert XML object or value as its parameter and returns a JSON that represents the object. The resulting JSON can be used to store or transmit data in a structured 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.
Example:
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
Used to encode the values of given key into base64
Example:
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.
Example:
Generate Array Sequence Number
Description:
Generate Array Sequence Number is a single line of data that presents the sequence the user wants to specify.
Number of Parameters : 2
Parameter : Sequence_key
It is the key name in which the single line data is present whose sequence the user needs to give.
Parameter : Sequence_number_key
It is the name of the new key for sequence
Example:
Send Keys top of Root
Description:
Column_to_root is the key's value specify by the user. User should provide the key name comma separated in double quotes in square brackets
Number of Parameters : 1
Parameter : Column_to_root
column_to_root : column_to_root is the given key's value
Example-["Amount"]
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 is the name of key in which the user wants to save their date
Round
Description:
Round 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, define by the user.
Parameter : Decimal_key_number
Decimal_key_number specifies which decimal places the user needs.
User should provide the key name comma separated in double quotes.
Example:
Calculator
Description:
Calculator operations are used when a calculated field with sustaining formulas related to any particular process is provided, by the user.
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.
User should provide the key name comma separated in double quotes.
Example:
Date Analytics
Description:
Date analytics is 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 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
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.
Example: