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


Number of Parameters : 4

Parameter : Boolean

XXXXXXXXXXXXXXXXXXXXX

Parameter : Float

XXXXXXXXXXXXXXXXXXXXXX

 

Parameter : Integer

XXXXXXXXXXXXXXXXXXXXXX

Parameter : Date Time
 

XXXXXXXXXXXXXXXXXXXXXX

Append

Description


Number of Parameters : 1

Parameter : Append


XXXXXXXXXXXXXXXXXXXXX

 

Title Case

Description


Number of Parameters : 1

Parameter : Title Case


XXXXXXXXXXXXXXXXXXXXX

 

Data Extractor

Description


Number of Parameters : 2

Parameter : Data ExtractorData_Extractor

XXXXXXXXXXXXXXXXXXXXX

Parameter :Data_Extractor_Keys

XXXXXXXXXXXXXXXXXXXXX


Trim 

Description


Number of Parameters : 1

Parameter : Trim


XXXXXXXXXXXXXXXXXXXXX

 

JSON to String

Description


Number of Parameters : 1

Parameter : JSON to StringJson2string


XXXXXXXXXXXXXXXXXXXXX

String to JSON

Description


Number of Parameters : 1

Parameter : String to JSONString2json

XXXXXXXXXXXXXXXXXXXXX


JSON to XML

Description


Number of Parameters : 2

Parameter : JSON to XMLKey_data

XXXXXXXXXXXXXXXXXXXXX

Parameter : Response_key

XXXXXXXXXXXXXXXXXXXXX


XML to JSON

Description


Number of Parameters : 2

Parameter : XML to JSONGet_key


XXXXXXXXXXXXXXXXXXXXX

Parameter : Response_key

XXXXXXXXXXXXXXXXXXXXX

 

Base64 Encoding

Description


Number of Parameters : 1

Parameter : Base64 EncodingBase64_encode


XXXXXXXXXXXXXXXXXXXXX

 

Base64 Decoding

Description


Number of Parameters : 1

Parameter : Base64 DecodingBase64_decode

XXXXXXXXXXXXXXXXXXXXX

 


Generate Array Sequence Number

Description


Number of Parameters : 2

Parameter : Generate Array Sequence NumberSequence_key


XXXXXXXXXXXXXXXXXXXXX

Parameter : Sequence_number_key

XXXXXXXXXXXXXXXXXXXXX


Send Keys top of Root

Description


Number of Parameters : 1

Parameter : Column_to_rootSend

Keys top of Root

XXXXXXXXXXXXXXXXXXXXX



Today Timestamp

Description


Number of Parameters : 2

Parameter : Today TimestampDate_format


XXXXXXXXXXXXXXXXXXXXX

Parameter : Datetime_key

XXXXXXXXXXXXXXXXXXXXX


Round

Description


Number of Parameters : 2

Parameter : RoundRound_keys

Parameter : Decimal_key_number

XXXXXXXXXXXXXXXXXXXXX



Calculator

Description


Number of Parameters : 2

Parameter : CalculatorCalculation_keys


XXXXXXXXXXXXXXXXXXXXX

Parameter : New_calculation_keys

XXXXXXXXXXXXXXXXXXXXX


Date Analytics

Description


Number of Parameters : 4

Parameter : Date AnalyticsData_field_key

XXXXXXXXXXXXXXXXXXXXX

Parameter : Fiscal_month_start 

XXXXXXXXXXXXXXXXXXXXX

Parameter : Date_column

XXXXXXXXXXXXXXXXXXXXX

Parameter : Weekday

XXXXXXXXXXXXXXXXXXXXX



Repeat First Row Values

Description


Number of Parameters : 2

Parameter : Repeat First Row ValuesSource_key


XXXXXXXXXXXXXXXXXXXXX

Parameter : Fields_to_repeat_value

XXXXXXXXXXXXXXXXXXXXX