Generic Import functions
This article describes the supported functions fields in the Generic Import Source.
Function Type | Function description | Return value | Value type |
---|---|---|---|
Absolute | Calculates the absolute value of the input number. | Absolute (A)= |A| | string |
Add | Adds two numbers. | Add (A,B) = A+B | string |
And | Returns TRUE if all of the arguments evaluate to TRUE. | AND(True,True)= True | boolean |
Concat | Concatenates the argument values into one text and returns with it. | concat(A,B,C) = ABC | string |
Divide | Returns with the divided value of two numbers (A / B). | Divide (A,B) = A/B | string |
Equal | Checks equality between two values (A = B)). Returns with a boolean result. | 1 if true, 0 if false | boolean |
Exists | Checks if a field exists in the input metadata. Returns TRUE if the field can be found/resolved and the value is not empty. FALSE otherwise. | 1 if true, 0 if false | boolean |
Greater | Checks if the first parameter is greater than the second one (A > B). Returns with a boolean result. | 1 if true, 0 if false | boolean |
Greater or equal | Checks if the first parameter is greater or equal to the second one (A >= B). Returns with a boolean result. | 1 if true, 0 if false | boolean |
If | Based on the first logical parameter returns with the second or third parameter. If the logical value is TRUE then returns with the first parameter, otherwise with the second parameter. | if(condition, A, B) = A if true, B if false | string |
Less | Checks if the first parameter is less than the second one (A < B). Returns with a boolean result. | 1 if true, 0 if false | boolean |
Less or equal | Checks if the first parameter is less or equal to the second one (A <= B). Returns with a boolean result. | 1 if true, 0 if false | boolean |
Mapping | Based on the first parameter value it finds a "Dictionary" key parameter in the given list and returns with its value. | Map(1, 1 ->odd, 2->even) = odd | string |
Multiply | Returns with the multiplied value of two numbers (A * B). | Multiply (A,B) = A*B | string |
Or | Returns TRUE if any argument evaluates to TRUE. | Or(True, False) = True | boolean |
Regex | In the first parameter value run a regex search pattern from the second parameter. The first group match will be the output | regex(1234, \d{2}) = 12 | string |
Replace | In the first parameter, it searches a string from the second parameter and replaces it with the third parameter. | replace(input,in,out) = output | string |
Substring | Returns the portion of the string from the first parameter specified by the start and length parameters from the second and the third parameter. | substring(input data, 2,3)= put | string |
Subtract | Subtracts the second number from the first number. | Subtract(A,B)=A-B | string |