XML to Array in nodejs

Question

How do I parse whatever is inside 'value' tag from below XML to an array in nodejs ? I tried npm xpath/xmldom, XMLExtract then xml2json but without success yet.

<response status="success"><result>
  <resource-monitor>
    <data-processors>
      <dp0>
        <second>
          <cpu-load-average>
            <entry>
              <coreid>0</coreid>
              <value>0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0</value>
            </entry>
            <entry>
              <coreid>1</coreid>
              <value>2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2
,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2</value>
            </entry>

crackmigg · Accepted Answer · 2016-04-14 19:44:36Z

1

One option is to use cheerio like this:

var cheerio = require('cheerio');
var _ = require('lodash');

var $ = cheerio.load('<cpu-load-average>\
        <entry>\
          <coreid>0</coreid>\
          <value>0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0</value>\
        </entry>\
        <entry>\
          <coreid>1</coreid>\
          <value>2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2</value>\
        </entry>\
    </cpu-load-average>', 
    { xmlMode: true }
);

var values = _.map($('cpu-load-average').find('value'), function(item) {
    return $(item).text().split(',');
});

console.log(values);

Try it on requirebin. If it is a big XML file cheerio should be faster than xml2js.

answered Apr 14, 2016 at 19:44

crackmigg

5,9412 gold badges35 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

yeiniel · Accepted Answer · 2016-04-14 19:13:29Z

1

You can convert the xml to json using xml2js and then spliting the value of the value tag using string split operation will produce an array of values.

answered Apr 14, 2016 at 19:13

yeiniel

2,46617 silver badges32 bronze badges

Collectives™ on Stack Overflow

XML to Array in nodejs

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related