XML Parsing in IBM BPM
Suppose I have following XML and I want to parse this xml and store these variable to in list:
<record>
<column name="ID">1</column>
<column name="MANIFACTURERNAME">Dell</column>
<column name="MODELNAME">Latitute</column>
<column name="RAMSIZE">8 GB</column>
<column name="HDDSIZE">1 TB</column>
<column name="SCREENSIZE">15 Inch</column>
<column name="PROCESSORNAME">Intel i7</column>
<column name="PRICE">850</column>
</record>
<record>
<column name="ID">3</column>
<column name="MANIFACTURERNAME">Latitude</column>
<column name="MODELNAME">ideaBook</column>
<column name="RAMSIZE">8 GB</column>
<column name="HDDSIZE">300
GB</column>
<column name="SCREENSIZE">14 Inch</column>
<column name="PROCESSORNAME">Intel i5</column>
<column name="PRICE">1150</column>
</record>
In BPM Server script:
var resultLength=tw.local.xmlElementResult.childNodes.length;
log.info(tw.local.xmlElementResult.childNodes.length);
tw.local.maniList= new tw.object.listOf.String();
tw.local.modelList = new tw.object.listOf.String();
if(resultLength>0) {
for (var i = 0; i < resultLength; i++) { var startElement=tw.local.xmlElementResult.childNodes.item(i); tw.local.maniList.insertIntoList(i, startElement.xpath("record/column[@name='MANIFACTURERNAME']")[0].getText()); tw.local.modelList.insertIntoList(i, startElement.xpath("record/column[@name='MODELNAME']")[0].getText()); } }
Comments
Post a Comment