Skip to main content

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 Doubledouble Quotesquotes.
Example

Data Extractor

Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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

XXXXXXXXXXXXXXXXXXXXXData_Extractor is used to extract Keys and its value from a JSON response

Parameter :Data_Extractor_Keys

XXXXXXXXXXXXXXXXXXXXX


Trim 

Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


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: 

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxJSON 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: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


Number of Parameters : 2

Parameter : Key_data

XXXXXXXXXXXXXXXXXXXXX

Parameter : Response_key

XXXXXXXXXXXXXXXXXXXXX


XML to JSON

Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


Number of Parameters : 2

Parameter : Get_key

XXXXXXXXXXXXXXXXXXXXX

Parameter : Response_key

XXXXXXXXXXXXXXXXXXXXX


Base64 Encoding

Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


Number of Parameters : 1

Parameter : Base64_encode

XXXXXXXXXXXXXXXXXXXXX


Base64 Decoding

Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


Number of Parameters : 1

Parameter : Base64_decode

XXXXXXXXXXXXXXXXXXXXX



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


Number of Parameters : 2

Parameter : Date_format

XXXXXXXXXXXXXXXXXXXXX

Parameter : Datetime_key

XXXXXXXXXXXXXXXXXXXXX


Round

Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


Number of Parameters : 2

Parameter : Round_keys

XXXXXXXXXXXXXXXXXXXXX

Parameter : Decimal_key_number

XXXXXXXXXXXXXXXXXXXXX



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