How to read attributes and values from XML payload?

[Chinmayee1]

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>

<attr1> 123 </attr1>

</set1>

<set2>

<attr2>xyz</attr2>

</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

[Onkar Pandav]

Hi,

Check below link that may help you.

https://docs.servicenow.com/bundle/orlando-application-development/page/script/business-rules/concep...

[Chinmayee1]

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

[Ankur Bawiskar]

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

[Chinmayee1]

Hi Ankur ,

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

Thanks & Regards,

Chinmayee