Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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(result);
- { data:
- [ { lb: 'req_10', resp: '1501597138973', ts: '1501597136964' },
- { lb: 'req_10', resp: '1501597139525', ts: '1501597136964' },
- { lb: 'req_10', resp: '1501597139716', ts: '1501597136964' } ] }
- console.log(csv)
- "lb","resp","ts"
- "req_10","1501597138973","1501597136964"
- "req_10","1501597139525","1501597136964"
- "req_10","1501597139716","1501597136964"
- Desirerd order:
- "ts","lb","resp"
Add Comment
Please, Sign In to add comment