CPI – XML to JSON conversion issue String to Double data type issue

Hi Experts,

After XML to JSON conversion, need to convert few field values from String to Double datatype.

Input Payload:

<?xml version=’1.0′ encoding=’UTF-8′?>

<root>

<row>

<NO>14077</NO>

<EAN>3245067744512</EAN>

<WEIGHT>138.5</WEIGHT>

<WEIGHT_UNIT>GRM</WEIGHT_UNIT>

<FIELD5>0000</FIELD5>

<LENGTH>65.0</LENGTH>

<WIDTH>60.0</WIDTH>

<HEIGHT>100.0</HEIGHT>

<UNIT_OF_DIMENSION>MMT</UNIT_OF_DIMENSION>

<VOLUME_CCM>390.0</VOLUME_CCM>

<FIELD11>0000</FIELD11>

<FIELD12>0000</FIELD12>

<FIELD13>N</FIELD13>

<UNIT_OF_MEASUREMENT_TEXT>CMQ</UNIT_OF_MEASUREMENT_TEXT>

<FIELD15/>

</row>

</root>

Required Output JSON data:

few field values without double quotes

image.png

[

{

“fieldTypeId”: “ItemBaseGrossWeight”,

“value”: 138.5

},

{

“fieldTypeId”: “ItemBaseWeightUoM”,

“value”: “GRM”

},

{

“fieldTypeId”: “ItemBaseLength”,

“value”: 65.0

},

{

“fieldTypeId”: “ItemBaseWidth”,

“value”: 60.0

},

{

“fieldTypeId”: “ItemBaseHeight”,

“value”: 100.0

},

{

“fieldTypeId”: “ItemBaseDimensionsUoM”,

“value”: “MMT”

},

{

“fieldTypeId”: “ItemBaseVolume”,

“value”: 390.0

},

{

“fieldTypeId”: “ItemBaseVolumeUoM”,

“value”: “CMQ”

}

]

Please help me with groovy script to handle.Thanks,Ram.

Read more here: Source link