How to use Substring Function in the condition field of Maximo JSON Mapping Application.

Suppose if the ABC field is having more than 7 characters it needs to be truncated in 4 characters during the json data processing.

JSON Mapping is javascript supported and can use text formatting functions.

$.jsonField.stringFunction()

Example:

$.assetNumber.substring(0,5)

For your requirement, Add Mapping condition like below

Condition: $.abcField.length>7

Value: $.abcField.substring(0,4)

Thanks!

------------------------------
Sankar Ganesh
------------------------------