Generate XML

Vijayalakshmi P — Mon, 28 Mar 2022 07:34:38 GMT

Hi All,

Please share suggestions on how to generate XML(say from incident) via scripts in Servicenow. (XML is defined by external system and the requirement is for system to system handshake).

Thanks,

Vijayalakshmi

Re: Generate XML

Hitoshi Ozawa — Mon, 28 Mar 2022 07:46:20 GMT

Hi Vijayalakshmi,

Write a script include to generate xml in required format.

Need further information such as below:

1. Query condition on incident record to create xml. For example, is it for 1 incident record, several incident records, all incident records.

2. XML format required by the external system.

Re: Generate XML

Ankur Bawiskar — Mon, 28 Mar 2022 07:54:59 GMT

Hi,

are you referring to this from integration point of view?

Can you explain your business requirement?

regards
Ankur

Re: Generate XML

Hitoshi Ozawa — Mon, 28 Mar 2022 09:05:57 GMT

Vijayalakshmi,

Following script include will generate xml of all records in a specified table.

Script Include. (uncheck "Client callable")

var TableUtil = Class.create();
TableUtil.prototype = {
    initialize: function() {},
    getXMLData: function(tableName) {
        function OBJtoXML(obj) {
            var xml = '';
            for (var prop in obj) {
                xml += obj[prop] instanceof Array ? '' : "<" + prop + ">";
                if (obj[prop] instanceof Array) {
                    for (var array in obj[prop]) {
                        xml += "<" + prop + ">";
                        xml += OBJtoXML(new Object(obj[prop][array]));
                        xml += "</" + prop + ">";
                    }
                } else if (typeof obj[prop] == "object") {
                    xml += OBJtoXML(new Object(obj[prop]));
                } else {
                    xml += obj[prop];
                }
                xml += obj[prop] instanceof Array ? '' : "</" + prop + ">";
            }
            xml = xml.replace(/<\/?[0-9]{1,}>/g, '');
            return xml;
        }

        var gr = new GlideRecord(tableName);
        gr.addActiveQuery();
        // gr.addQuery();  //add additional query as needed
        gr.query();
        var recList = [];
        while (gr.next()) {
            var fields = gr.getFields();
            var rec = {};
            for (var i = 0; i < fields.size(); i++) {
                var v = fields.get(i);
                if (v.toString() != '') {
                    rec[v.getName()] = v.toString();
                }
            }
            recList.push(rec);
        }
        var jsObj = {};
        jsObj[tableName] = {
            "records": recList
        };
        var xmlDoc = eval("OBJtoXML(" + JSON.stringify(jsObj) + ");");
        return xmlDoc;
    },
    type: 'TableUtil'
};

Sample execution:

Background script:

var xmlDoc = new TableUtil().getXMLData('incident');
gs.info(xmlDoc);

Result:

*** Script: <incident><records><sys_updated_on>2015-11-24 15:47:36</sys_updated_on><number>INC0000017</number><state>3</state><sys_created_by>don.goodliffe</sys_created_by><knowledge>false</knowledge><impact>1</impact><active>true</active><priority>1</priority><sys_domain_path>/</sys_domain_path><short_description>How do I create a sub-folder</short_description><notify>1</notify><sys_class_name>incident</sys_class_name><reassignment_count>2</reassignment_count><assigned_to>5137153cc611227c000bbd1bd8cd2005</assigned_to><variables>variable_pool</variables><sla_due>2015-09-02 00:00:00</sla_due><escalation>3</escalation><made_sla>false</made_sla><hold_reason>1</hold_reason><task_effective_number>INC0000017</task_effective_number><sys_updated_by>admin</sys_updated_by><opened_by>9ee1b13dc6112271007f9d0efdb69cd0</opened_by><sys_created_on>2015-08-25 23:41:54</sys_created_on><sys_domain>global</sys_domain><opened_at>2015-08-12 23:41:00</opened_at><caller_id>681ccaf9c0a8016400b98a06818d57c7</caller_id><assignment_group>d625dccec0a8016700a222a0f7900d06</assignment_group><description>I need to organize my inbox in my email program. However I can't create a sub-folder. I didn't seen an option to create a new folder when right clicking.</description><contact_type>phone</contact_type><incident_state>3</incident_state><urgency>1</urgency><company>31bea3d53790200044e0bfc8bcbe5dec</company><activity_due>2015-11-24 17:47:36</activity_due><severity>3</severity><approval>not requested</approval><sys_mod_count>36</sys_mod_count><category>inquiry</category></records><records><upon_reject>cancel</upon_reject><sys_updated_on>2022-03-28 08:11:59</sys_updated_on><number>INC0000052</number><state>2</state><sys_created_by>itil</sys_created_by><knowledge>false</knowledge><impact>1</impact><active>true</active><priority>1</priority><sys_domain_path>/</sys_domain_path><short_description>Dummy form to attach file</short_description><notify>1</notify><sys_class_name>incident</sys_class_name><reassignment_count>0</reassignment_count><assigned_to>5137153cc611227c000bbd1bd8cd2005</assigned_to><variables>variable_pool</variables><sla_due>2020-07-06 12:40:39</sla_due><escalation>0</escalation><upon_approval>proceed</upon_approval><made_sla>true</made_sla><task_effective_number>INC0000052</task_effective_number><sys_updated_by>system</sys_updated_by><opened_by>681b365ec0a80164000fb0b05854a0cd</opened_by><sys_created_on>2020-07-06 20:48:40</sys_created_on><sys_domain>global</sys_domain><opened_at>2020-07-06 20:48:40</opened_at><caller_id>46c6f9efa9fe198101ddf5eed9adf6e7</caller_id><assignment_group>8a4dde73c6112278017a6a4baf547aa7</assignment_group><description>PROD 10 987</description><contact_type>phone</contact_type><incident_state>2</incident_state><urgency>1</urgency><problem_id>d7296d02c0a801670085e737da016e70</problem_id><company>31bea3d53790200044e0bfc8bcbe5dec</company><activity_due>2022-03-28 10:11:58</activity_due><severity>3</severity><approval>not requested</approval><sys_mod_count>1172</sys_mod_count><location>db96a8480a0a0a65019da337d4a89edc</location><category>software</category></records></incident>

Re: Generate XML

Vijayalakshmi P — Wed, 30 Mar 2022 11:30:33 GMT

Thank you, this is wonderful.. Will help in future.

And sorry I was not clear on stating the requirement. This is from integration point of view. XML is defined by external system. We should populate right values from Incident to this XML.

Thanks,

Vijayalakshmi.

Re: Generate XML

Ankur Bawiskar — Wed, 30 Mar 2022 13:53:51 GMT

Hi,

you can create SOAP Message and then use variable substitutions to replace incident field values

Variable substitution in outbound SOAP

Regards
Ankur

Re: Generate XML

Vijayalakshmi P — Tue, 05 Apr 2022 14:19:32 GMT

Hi, Can i create SOAP message without endpoint?

Thanks

Re: Generate XML

Ankur Bawiskar — Tue, 05 Apr 2022 14:45:36 GMT

Hi,

so you don't have an endpoint for the integration?

Regards
Ankur

Re: Generate XML

Vijayalakshmi P — Tue, 05 Apr 2022 17:28:23 GMT

Yes, I will generate the XML and expose a webservice for them to consume the XML.

But XML structure is defined by them.

Thanks.

Re: Generate XML

Ankur Bawiskar — Wed, 06 Apr 2022 03:18:17 GMT

Hi,

you can use Scripted SOAP service for this for custom xml structure

Regards
Ankur

Re: Generate XML

Hitoshi Ozawa — Wed, 06 Apr 2022 03:40:37 GMT

There's an article on creating an inbound SOAP message. Set the response to be what's required.

https://community.servicenow.com/community?id=community_article&sys_id=c9607393db7490101cd8a345ca961914

question Generate XML in Developer forum

Generate XML

Re: Generate XML

Re: Generate XML

Re: Generate XML

Re: Generate XML

Re: Generate XML

Re: Generate XML

Re: Generate XML

Re: Generate XML

Re: Generate XML

Re: Generate XML