XML2JS remove square brackets surrounding values

Question

i'm using the xml2js node package to parse an xml feed. Is there any way to prevent the values being surrounded by square brackets?

E.g. "reference": ["ABC123"] should be "reference": "ABC123"

"items": [
    {
        "reference": ["ABC123"],
        "hours": ["35"]
    },
    {
        "reference": ["XYZ123"],
        "hours": ["20"]
    }
]

what is the input xml and what is the code you used to convert it — Uthistran Selvaraj, Feb 12 '20 at 17:44
Hi, the XML looks like this (I have no control over it). <![CDATA[ ABC123]]> <![CDATA[ 35 ]]> — Scott, Feb 12 '20 at 17:50
what is the code you used to convert? an executable sample from stackblitz is easy to help you — Uthistran Selvaraj, Feb 12 '20 at 17:52
The code to convert it xml2js.parseString(theXML, function (err, result) { //Do stuff here }); — Scott, Feb 12 '20 at 17:52
https://stackoverflow.com/questions/20238493/xml2js-how-is-the-output — Uthistran Selvaraj, Feb 12 '20 at 17:53
var parser = new xml2js.Parser({explicitArray : false}); it seems' — Uthistran Selvaraj, Feb 12 '20 at 17:54
@UthistranSelvaraj thanks for your help, that works perfect. I ended up adding that parameter directly on require(): var xml2js = require('xml2js').Parser({explicitArray : false}); — Scott, Feb 13 '20 at 10:25

score 3 · Answer 1 · answered Feb 13 '20 at 10:24

3

Solution:

var xml2js = require('xml2js').Parser({explicitArray : false});

results in

"items": [
    {
        "reference": "ABC123",
        "hours": "35"
    },
    {
        "reference": "XYZ123",
        "hours": "20"
    }
]

answered Feb 13 '20 at 10:24

Scott

1,280
4
20
35

XML2JS remove square brackets surrounding values

1 Answers1