parsing XML to CSV in node.js

Question

I am trying to convert an xml file to csv file using node.js diretly.

My xml file looks like:

<?xml version="1.0" encoding="UTF-8"?>
<testResults version="1.2">
<httpSample ts="1501597136964" lb="req_10">
  <responseData class="java.lang.String">1501597138973</responseData>
</httpSample>
<httpSample ts="1501597136964" lb="req_10">
  <responseData class="java.lang.String">1501597139525</responseData>
</httpSample>
<httpSample ts="1501597136964" lb="req_10">
  <responseData class="java.lang.String">1501597139716</responseData>
</httpSample>
</testResults>

I am able to get the value of <responseData class="java.lang.String">1501597138973</responseData>. But I also want to parse the value of ts="1501597136964" and lb="req_10" from <httpSample> tag

I am using xml2rec package

var xml2rec=require('xml2rec');
xml2rec('xmlFile.xml', 'httpSample', 'csvFile.csv');

Should I be checking any other packages that can help me do this or I have to go the long way to convert from xml to json first and then json to csv?? Also, in doing so, will I be able to get the value of ts and lb attributes of httpSample tag??

P.S. The output xml file is JMeter response file

adriaan · Accepted Answer · 2018-10-23 01:57:54Z

1

Not sure what's the best way to do this but since xml structure is not flat anyway, you will have to flatten it before converting to csv.

const transform = require('camaro')
const json2csv = require('json2csv').parse

const xml = `
<?xml version="1.0" encoding="UTF-8"?>
<testResults version="1.2">
<httpSample ts="1501597136964" lb="req_10">
  <responseData class="java.lang.String">1501597138973</responseData>
</httpSample>
<httpSample ts="1501597136964" lb="req_10">
  <responseData class="java.lang.String">1501597139525</responseData>
</httpSample>
<httpSample ts="1501597136964" lb="req_10">
  <responseData class="java.lang.String">1501597139716</responseData>
</httpSample>
</testResults>
`
const template = {
    data: ['//httpSample', {
        ts: '@ts',
        lb: '@lb',
        resp: 'responseData'
    }]
}

const result = transform(xml, template)
const csv = json2csv(result.data)
console.log(csv)

Output:

"lb","resp","ts"
"req_10","1501597138973","1501597136964"
"req_10","1501597139525","1501597136964"
"req_10","1501597139716","1501597136964"

edited Oct 23, 2018 at 1:57

adriaan

1,1381 gold badge13 silver badges30 bronze badges

answered Aug 1, 2017 at 15:25

Tuan Anh Tran

7,2797 gold badges39 silver badges57 bronze badges

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

1 Comment

Gaurang Deshpande Over a year ago

So we do usually go from xml to json and then json to csv... Let me try if this is helpful in my case.

Collectives™ on Stack Overflow

parsing XML to CSV in node.js

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related