question Re: How to read attributes and values from XML payload? in Developer forum

How to read attributes and values from XML payload?

Chinmayee1 — Mon, 07 Dec 2020 06:03:36 GMT

Hi ,

I have a requirement to read from xml payload and write it in a staging table along with few other columns read from another table. e.g 3 columns from xml payload and 2 columns from another table which are in string format.

How do I read the attributes and values dynamically ?

the payload looks like : <?xml version="1.0" encoding="UTF-8" standalone = "yes"?>

<set>

<set1>

</set1>

<set2>

</set2>

<attr3> value1 </attr3>

<attr4>value2</attr4>

</set>

It looks like in tree structure. How to I get the attribute names(attr1,attr2,attr3) and values (123,xyz,value1,value2) ?

The script is one but the payloads are different for different use cases.

Thanks & Regards,

Chinmayee Mishra

Re: How to read attributes and values from XML payload?

Onkar Pandav — Mon, 07 Dec 2020 06:16:38 GMT

Hi,

Check below link that may help you.

https://docs.servicenow.com/bundle/orlando-application-development/page/script/business-rules/concept/business-rule-examples.html#conceptjqqtjxz4

Re: How to read attributes and values from XML payload?

Chinmayee1 — Mon, 07 Dec 2020 06:22:19 GMT

This doesn't help. I need to fetch the attribute names dynamically.

Re: How to read attributes and values from XML payload?

Ankur Bawiskar — Mon, 07 Dec 2020 06:24:04 GMT

Hi,

you will have to parse the XML

Your above XML structure is not valid as it doesn't have repeated tags

Ensure the xml structure is valid with valid tags etc and it would be easier to parse

Refer below link where I have shared sample script for parsing repeated tags

Using XPATH to get multiple values from the same node name

Regards
Ankur

Re: How to read attributes and values from XML payload?

Chinmayee1 — Mon, 07 Dec 2020 06:32:11 GMT

Hi Ankur ,

The payload I m trying to read is not like the link you've shared.

Thanks & Regards,

Chinmayee

Re: How to read attributes and values from XML payload?

Ankur Bawiskar — Mon, 07 Dec 2020 06:40:06 GMT

Hi,

payload might not be the same.

but the approach of parsing the XML for repeated tags will be same

Regards
Ankur

Re: How to read attributes and values from XML payload?

Chinmayee1 — Mon, 07 Dec 2020 06:42:36 GMT

Hi,

If I paste the above xml and convert it to JSON online , It looks like below

{
   "set1": {
      "attr1": "123"
   },
   "set2": {
      "attr2": "xyz"
   },
   "attr3": "value1",
   "attr4": "value2"
}

This is what I need.

Re: How to read attributes and values from XML payload?

Ankur Bawiskar — Mon, 07 Dec 2020 06:48:06 GMT

Hi,

you can convert that XML to JSON and then parse the JSON

For converting xml to json refer this link

Converting XML to JSON

Script I tried

var jsonString = '{"set1":{"attr1":"123"},"set2":{"attr2":"xyz"},"attr3":"value1","attr4":"value2"}';

var parser = JSON.parse(jsonString);

var attr1Value = parser.set1.attr1;

var attr2Value = parser.set2.attr2;

var attr3Value = parser.attr3;

var attr4Value = parser.attr4;

gs.info(attr1Value);
gs.info(attr2Value);
gs.info(attr3Value);
gs.info(attr4Value);

Output:

Regards
Ankur

Re: How to read attributes and values from XML payload?

Ankur Bawiskar — Mon, 07 Dec 2020 07:28:45 GMT

@Chinmayee

Thanks for marking my response as helpful.

Let me know if I have answered your question.

If so, please mark appropriate response as correct & helpful so that this thread can be closed and others can be benefited by this.

Regards
Ankur

Re: How to read attributes and values from XML payload?

Chinmayee1 — Mon, 07 Dec 2020 07:49:01 GMT

Hi Ankur ,

I am able to get the values but not attributes.

I did the below

var payLoad = "my xml payLoad";

var helper = XMLHelper(payLoad);

obj = helper.toObject();

for(x in obj){

gs.log("xml objects :"+obj[x]);

}

It gives me only values of every node but not the attribute names.

Can you please advise ?

Thanks & Regards,

Chinmayee Mishra

Re: How to read attributes and values from XML payload?

Chinmayee1 — Mon, 07 Dec 2020 08:16:45 GMT

Now I am getting the attributes and values for one object but not all.

I tried to convert to JSON. Its not working.

Re: How to read attributes and values from XML payload?

Ankur Bawiskar — Mon, 07 Dec 2020 08:36:55 GMT

Hi,

are you not able to convert xml to json?

please share the actual xml you are having

Regards
Ankur

Re: How to read attributes and values from XML payload?

Chinmayee1 — Mon, 07 Dec 2020 08:41:22 GMT

xmlToJSON(xml string) doesn't work

Re: How to read attributes and values from XML payload?

Chinmayee1 — Mon, 07 Dec 2020 08:43:25 GMT

It gives null.

Re: How to read attributes and values from XML payload?

Ankur Bawiskar — Mon, 07 Dec 2020 09:00:51 GMT

Hi,

it means your xml is not valid

the link I shared I just tried same script

var xTest = "<a>Hello World</a>";

gs.info(xTest);

var obj = gs.xmlToJSON(xTest);

gs.info(JSON.stringify(obj));

Output:

Regards
Ankur

Re: How to read attributes and values from XML payload?

Chinmayee1 — Mon, 07 Dec 2020 09:28:23 GMT

I did substring and removed the first line. Now it shows the json value but with error.

Re: How to read attributes and values from XML payload?

Ankur Bawiskar — Mon, 07 Dec 2020 09:40:03 GMT

Hi,

if your XML is valid then you will get proper json

Then you can parse the json

Regards
Ankur