Converting XML to JSON failing with gs.xmlToJSON when XML contains #&13;

[codycotulla]

Hi,

I'm trying to convert XML strings to JSON objects using gs.xmlToJSON()

I've found that if the XML contains a character entity such as 
 then the conversion fails.

For example

var xTest = "<a>Hello &#13; World</a>";

var obj = gs.xmlToJSON(xTest);

// obj is null;



var xmlDoc = new XMLDocument2();

xmlDoc.parseXML(xTest);

var tOrF = xmlDoc.isValid();

// tOrF is true 

I know that the XML is valid because the XMLDocument2.isValid() method is OK.

I also know that if I take out the & in 
 then the conversion works.

var xTest = "<a>Hello &#13; World</a>";
xTest = "<a>Hello #13;  World</a>";

var obj = gs.xmlToJSON(xTest);

// obj is an Object.

Has anyone seen this problem? Is there a work around?

Any help is appreciated.

Thanks,

Cody

[Community Alums]

When you are on scoped app, your solution is, by far, the best.

Thanks for sharing it.

[shallom]

try

var XmlToJson = Class.create();
XmlToJson.prototype = {
    initialize: function() {},
    convert: function(xml) {
        var xmlDoc = new XMLDocument2();
        xmlDoc.parseXML(xml);
        var root = xmlDoc.getDocumentElement();
        if (!root) {
            gs.error("Root element is null. Unable to parse XML.");
            return null;
        }
        var jsonResult = {};
        jsonResult[root.getNodeName()] = this.parseXmlToJson(root);
        return jsonResult;
    },
    isEmptyObject: function(obj) {
        return Object.keys(obj).length === 0;
    },
    parseXmlToJson: function(node) {
        if (!node) return null; // Check if node is null

        var jsonObject = {};

        // Get attributes (if any) with a null check
        var attrs = node.getAttributes();
        if (!this.isEmptyObject(attrs)) {
            jsonObject = attrs;
        }

        // Iterate through child nodes
        var childNodes = node.getChildNodeIterator();
        if (childNodes.hasNext()) {
            while (childNodes.hasNext()) {
                var childNode = childNodes.next();
                var childName = childNode.getNodeName();
                var childValue = childNode.getNodeValue();

                // Skip text nodes
                if (childName === "#text") {
                    if (!this.isEmptyObject(attrs)) {
                        jsonObject['value'] = childValue || null;
                    } else {
                        jsonObject = childValue || null;
                    }
                    continue;
                };

                if (childNode.isCDATANode()) {
                    jsonObject[childName] = childValue;
                } else if (!jsonObject[childName]) {
                    jsonObject[childName] = this.parseXmlToJson(childNode);
                } else {
                    // Handle cases where there are multiple nodes with the same name
                    if (!Array.isArray(jsonObject[childName])) {
                        jsonObject[childName] = [jsonObject[childName]];
                    }
                    jsonObject[childName].push(this.parseXmlToJson(childNode));
                }
            }
        } else if (this.isEmptyObject(attrs)) {
            // If there are no child nodes, get the node's value
            jsonObject = node.getNodeValue() || null;
        }

        return jsonObject;
    },
    type: 'XmlToJson'
};
var xml = "XML paylod";
gs.info(JSON.stringify(new XmlToJson().convert(xml), null, 2))