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

Popular posts from this blog

Type conversion in IBM BPM

Parse the JSON in IBM BPM