Guest User

Untitled

a guest
Dec 15th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. const transform = require('camaro')
  2. const json2csv = require('json2csv').parse
  3.  
  4. const xml = `
  5. <?xml version="1.0" encoding="UTF-8"?>
  6. <testResults version="1.2">
  7. <httpSample ts="1501597136964" lb="req_10">
  8. <responseData class="java.lang.String">1501597138973</responseData>
  9. </httpSample>
  10. <httpSample ts="1501597136964" lb="req_10">
  11. <responseData class="java.lang.String">1501597139525</responseData>
  12. </httpSample>
  13. <httpSample ts="1501597136964" lb="req_10">
  14. <responseData class="java.lang.String">1501597139716</responseData>
  15. </httpSample>
  16. </testResults>
  17. `
  18. const template = {
  19. data: ['//httpSample', {
  20. ts: '@ts',
  21. lb: '@lb',
  22. resp: 'responseData'
  23. }]
  24. }
  25.  
  26. const result = transform(xml, template)
  27. const csv = json2csv(result.data)
  28.  
  29. console.log(result);
  30.  
  31. { data:
  32. [ { lb: 'req_10', resp: '1501597138973', ts: '1501597136964' },
  33. { lb: 'req_10', resp: '1501597139525', ts: '1501597136964' },
  34. { lb: 'req_10', resp: '1501597139716', ts: '1501597136964' } ] }
  35.  
  36. console.log(csv)
  37. "lb","resp","ts"
  38. "req_10","1501597138973","1501597136964"
  39. "req_10","1501597139525","1501597136964"
  40. "req_10","1501597139716","1501597136964"
  41.  
  42. Desirerd order:
  43. "ts","lb","resp"
Add Comment
Please, Sign In to add comment