WSO2 Data Mapper Operators

This post describes about the available operators of the data mapper and the functionality of each operator

Basically there are 7 categories of operators as shown below

• Links 
• Common
• Arithmetic
• Conditional
• Boolean
• Type Conversion 
• String 

Please refer the above links for more details

WSO2 Data Mapper Operators - String category

This post describes about the operators in the String category

• Concat

This can be used to concat two or more string values

1.Drag and drop the operator to the editor

 

2. To configure the operator by specifying the number of inputs and the concat delimiter, right click and select “Configure concat operator” menu action

Eg: name and the origin will concat using the delimiter “,” and maps the result to the description

• Split

This can be used to split a string value using a specified delimiter 

Eg: if the oring value is “French:FR” the the split the origin from “:” and map the ‘French’ and ‘FR’ to origin and value fields

• Uppercase

This can be used to convert a string value to uppercase

Eg: make the name to uppercase

• Lowercase

This can be used to convert a string value to lowercase

Eg: converts the origin to lowercase

• String Length

This can be used to get the length of a string

Eg: get the length of the value field and map

• StartsWith

This can be used to check whether a String starts with a specific value ( This is not supported in Java 7)

Eg: if the origin value if ORI-French, then we can check if it’s starts with ‘ORI’


1.Drag and drop the operator to the editor

2. You can give the String value you need to check into the first input box and the string pattern to the other input box. String pattern can be given in two ways as below

-Can give via the dialog box by right click and select “Configure StartsWith operator” menu action and then specify the pattern at {$Pattern}

-Can give as an input to the operator either using another operator as shown below or using the input value from the data mapper input tree

• Endswith

This can be used to check whether a String ends with a specific value. ( This is not supported in Java 7)

(Works similar to the startsWith operator)

• SubString

This can be used to extracts a part of the String value

Eg: if the description is “VEG-Vegetarian”, then we can extract the VEG part and maps the value


1.Drag and drop the operator to the editor

2. You can give the String value into the first input box and the start index and the length to the other two input boxes. Those can be given in two ways as below


-Can give via the dialog box by right click and select “Configure SubString operator” menu action and then specify the start {$Index} and {$Length}

-Can give as an input to the operator either using two other operators as shown below or using the input values from the data mapper input tree

• Trim

This can be used to remove white spaces from the beginning and end of a String

• Replace

This can be used to replace the first occurrence of a target String with another


Eg: if the description is “Ctg:Vegetarian”, then we can replace Vegetarian with VEG and maps the value


1.Drag and drop the operator to the editor

2. You can give the String value into the first input box and the target string and the replace with string to the other two input boxes. Those can be given in two ways as below
 -Can give via the dialog box by right click and select “Configure Replace operator” menu action and then specify the {$Target} and {$Replace}

-Can give as an input to the operator either using two other operators as shown below or using the input values from the data mapper input tree

• Match

This can be used to check whether the input match with a (JS) Regular Expression

1.Drag and drop the operator to the editor

2. You can give the String value into the first input box and the pattern the other input box. The pattern can be given in two ways as below
 
-Can give via the dialog box by right click and select “Configure Match operator” menu action and then specify the {$Pattern}

-Can give as an input to the operator either using another operator as shown below or using the input values from the data mapper input tree

WSO2 Data Mapper Operators - Type Conversion category

This post describes about the operators in the Type conversion category

• StringToNumber

This converts a String value to a number

Eg: convert the price value from String to a number

• StringToBoolean

This converts a String value to a boolean

Eg: This converts the veg value from String “true” to boolean true

• ToString

This converts a boolean or a number to a String value

Eg: The calories value is converting from number to string and the veg value is converting from boolean to a string

WSO2 Data Mapper Operators - Boolean category

This post describes about the operators in the Arithmetic category

 

• AND

This performs the boolean AND operation on inputs

Eg: according to the below example if it’s Veg and the calories are less than 10, then the approval value should be true

• OR

This perform the boolean OR operation on inputs

Eg: according to the below example if it’s Veg or the calories are less than 10, then the approval value should be true 

• NOT

This performs the boolean NOT operation

Eg: If the calories are greater than 10, then the approval value should be false

 

WSO2 Data Mapper Operators - Conditional category

This post describes about the operators in the Conditional category

• IfElse

Here it uses a condition and based on that condition this selects one input from given two.

eg:According to the below example if the veg value is “true” then the output value should be “VEG” else the value should be “NON-VEG”

 

WSO2 Data Mapper Operators - Arithmetic category

This post describes about the operators in the Arithmetic category

• Add

This operator can be used to add two or more numbers

1.Drag and drop the operator to the editor

2. To configure the number of inputs, right click and select “Configure Add Operator” menu action and then you can add the number of inputs you require to add 

Eg:Adds the calories and count and maps the result to value

• Subtract

This operator can be used to subtract two numbers

Eg: Subtract 5 from calories and map the result 

• Multiply

This can be used to multiply two or more numbers

1. Drag and drop the operator to the editor

2. To configure the number of inputs, right click and select “Configure Multiply Operator” menu action and then you can add the number of inputs you require

Eg: Multiplies the calories by 1% and map the result

• Divide

This can be used to divide two numbers

Eg: Divide the calories by 2 and map the result

• Ceiling

This can be used to derive the ceiling value of a number (the least integer that is greater than the input value)

Eg:Maps the ceiling value of the price

• Floor

This can be used to derive the floor value of a number (the greatest integer that is less than the input value)

Eg:Maps the floor value of the price

• Round

This can be used to derive the next integer value by either increasing or decreasing the number 

Eg: Get the round value of price

• Set Precision

This can be used to specify a number into a specified length.

Eg: Nmber as 5.5433

Number of decimals as 2

The result would be 5.54
 

1.Drag and drop the operator to the editor

2. You can give the number which you need to convert into the first input box and the number of decimals to the other input box. No of decimals can be given in two ways as below-Can give via the dialog box by right click and select “Configure Set Precision Operator” menu action and specify the value for {$NoOfDigits} 

-Can give as an input to the operator either using another operator as shown below or using the input value from the data mapper input tree

 

• Absolute value

This can be used to derive the absolute value of a rational number

• Min

This can be used to derive the minimum number of the given set of numbers

1.Drag and drop the operator to the editor

2. Configure the operator to add the number of inputs by right click and select “Configure min operator” menu action

• Max

This can be used to derive the maximum number of the given set of numbers

1.Drag and drop the operator to the editor

2. . Configure the operator to add the number of inputs by right click and select “Configure max operator” menu action