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

[
{
“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
