@toUpper

@toUpper(json path)

Converts data to upper case.

@toDataType

@toDataType(value json path, data type json path, boolean true value, boolean false value)

Converts data to data type if the source data doesn't conform to the given data type or uses custom data type

@toFlatten

@toFlatten(source json path, relative depth json path)

Flattens an object or array to the given depth.

@indexOf

@indexOf(array json path)

Returns index of an array element.

@replaceValue

@replaceValue(jsonPath/ function/default constants, header key)

Uses header value passed in the request.

The name of the parameters should be in this form - User- Project-Name.

The first letter and the subsequent letters after hyphen(-) must be capitalized.

Examples: @replaceValue($,User- Project-Id) # correct @replaceValue($,User-Project- Name) # correct @replaceValue($,user-project-name)

# Incorrect

@invokeRest

@invokeRest(function name, argument list...)

Tenant implements end point and configures it in the Industry Framework.

@valueMap

@valueMap(condition json path/function, default, json path/function, source, target)

Maps the value found at the third argument using a variable number of source/target values.

Keep in mind that when the target field uses an Open API type of "oneOf": [...], this function will not be able to cast mapped values to types unless the target type is declared with an explicit Open API "type" instead of "oneOf".

@conditionValueMap

@conditionValueMap (json path/function, default, trueValue, falseValue)

Returns trueVal if the first argument resolves to anything non- null that is not an empty list.

Returns falseValue if the first argument resolves to an empty list.

Returns the default value if the first argument resolves to null.

@defaultValue

@defaultValue (json path/function, default value)

Returns the value found after evaluating the first argument.

Returns the default value if the first argument is null.

@distinctValues

@distinctValues(json path array, arg1, arg2, ...)

Returns the distinct values based on the parameter passed. The first argument should return an array. The other arguments contain fields that are used to find distinct elements.

@alterValue

@alterValue(condition json path, json path or value, mathematical operator, json path or value, precision(optional), rounding mode(optional))

It performs a mathematical operation on its operands and produces a number according to the specified precision and rounding mode.

@toArrayLength

@toArrayLength(condition json path, json path or function)

It calculates the length of an array and produces a number according to that.

@concatValues

@concatValues(condition, arg1, arg2, ...)

Returns the concatenated string based on the parameters passed.

The 1st argument (function or JSON path) is a condition. If the first argument evaluates to not null, then the function will return the concatenated value else it will return null.

@compareValue

@compareValue(condition json path, json path or value or header param or query param, relational operator, json path or value, dataType optional)

It compares the left and right operands using the relational operators like (<,>,<=,>=,==,!=), based upon the dataType mentioned and returns a Boolean value as result.

@conditionalConvertValue

@conditionalConvertValue(conditionJson Path, jsonPath, regex, index, case identifier)

This function is used to split and convert the case of an input text passed in its 2nd arg to the user requested case passed in 3rd arg, 4th arg, and 5th arg.

@convertCase

@convertCase(condition json path/function, json path/function/constants, case identifier)

This function is used to split and convert the case of an input text passed in its2nd arg to the user requested case passed in 3rd arg.

@dateConverter

@dateConverter(condition 'json path',date 'json path', default date(optional), source date format(optional), target date format(optional))

Based on the condition, it converts date from source format to target format if provided or uses default date format. If the date resolves to null and then returns default date converted in target format, if default date is also null then returns null.

@evaluateDataType

@evaluateDataType( jsonPath, dataType, format Optional)

It checks if the value of that jsonPath returns the specified data type or not. In case of date format has to be passed.

@filterArray

@filterArray(conditionalJsonPath, filteredArrayJsonPath, minLengthForComparing, operator, additionalCondition)

Filter the array based on the condition provided.

@getArrayElementByIndex

@getArrayElementByIndex(condition json path or function, json path or function, integer constant or json path or function returning integer index)

It returns an array element present at specified index passed in 3rd argument.

@getFilteredArrayElement

@getFilteredArrayElement(condition,jsonpath, filterCriteria, index, fieldsJsonpath)

Based on the condition, it substitutes the search string with replace string in the data and returns the transformed data.

@infixToPrefix

@infixToPrefix($, $.['stringExpression'], operator_map('REQU IRES','req','NOT','!'), type_map('REQUIRE S','binary','!','unary'), operand_map(), exp_json_path($.id, productId), apply_Siebel_Format (true))

This function is used to convert infix expression to its prefix form.

@objectToStringExp

@objectToStringExp (jsonPath, keyValueSep, fieldSep, mode, [replaceString], [enclosedBy])

Function to convert a json object to a string, with the ability to ignore empty fields and separate fields, values, and field-value pairs, as well as wrap each field value pair with a string.

@prefixToInfix

@prefixToInfix(condition json path, json path, source_system_siebel (true/false), operator_map('source-system- operator','eqv- target-system- operator', ….…. ),type _map('source- system- operator','operator- type', ….... ),operand _map('custom- source-system- operand','regex-exp-to-be-used or way to resolve custom operand in target system', ….... ),exp_json_path(entity(entity _Type_Identifier_In_ Target_System, JsonPath to identify ID in stitched payload), ... ))

This function is used to convert prefix expression to infix expression.

@splitString

@splitString(conditionJsonPath, jsonPath, regex, defaultValue, index)

It splits any string based on a regex and returns list of values if no index given in the argument else returns that specific value based on the index mentioned in the argument.

@substituteValues

@substituteValues(condition 'json path or function', data 'json path or value or function' , search string 'json path or value or function' , replace string 'json path or value or function', ….…....)

Based on the condition, it substitutes the search string with replace string in the data and returns the transformed data.

@jobId

"name": { "type":
"string",
"x-oracle-map-data": {
"json_path": "@concatValues($,-
,SM,@jobId)", "mapType": 
"TO_FIELD"
 }
}

The current job ID.

@applicationName

"source":{ 
"type": "string",
"x-oracle-map-data": { 
"default": 
"@applicationName" 
 }
},

Returns the name of the source system.

@epochTime

Returns the epoch time based on system time.

@recordNum

Returns the number of records when the JSON path returns multiple objects in API map.

@replace(key)

"source_request_spec": {
"source_api_path": "/siebel/v1.0/data/Price 
List/Price List", "source_request_type": "GET",
 "distinct_key_json_path": "$.Id",
 "select_json_path": "$.items",
"query_param": [
  {
   "key": "PageSize",
   "value": "@replace(batchSize)"
  }
 ]
}

Replaces a value from given header key.

@pathParam(key)

{
"source_api_path": "/siebel/v1.0/data/Volume 
Discount/Volume Discount/{id}/Volume
Discount Item",
"source_request_type": "GET", 
"query_parameter": 
"@pathParam(id)", 
"query_value_json_path": "$.Id",
...
}

Used in query map to pass value for a path parameter key.