Looping through XML String?

[rileythiessen (RJ)]

Hello,

I just have a quick question that I’m sure someone knows the answer to but I cannot find.

I have essentially an XML file stored into a string that follows the following format:

My goal is to be able to loop through this and do things which each of the s.
How would I go about doing this?

Thank you !

[Palaniyappan (Palaniyappan P)]

Hi
Did we try with DESERIALISE XML activity

Activities - Deserialize XML

For that go to design tab in studio-> manage packages → official tab → search and install UiPath.Web.Activities

In that we will be having the activity in activity panel

Once after getting the output from this activity as a xml document use a FOR EACH activity to loop through each tags
For example

Deserialize XML

How can we use Deserialize activity in UiPath. This is required to extract multiple fields like, Personal Number, First Name, last name etc and assign to variable so that it can be used further in processing a request. Below is content of XML file <eservice name="PermissionForLeave"> <field id="GF.7.1.1"> <question>Personnummer</question> <answer>194112249166</answer> </field> <field id="GF.7.1.2"> <question>Förnamn</question> <answer>Erik</answer> </field> <field id=…

Cheers @rileythiessen

[rileythiessen (RJ)]

Awesome that worked perfectly.
One more quick question, when I loop through the XMLDocument.Element(“collection”).Elements(“event”) and then i extract the item.Element(“test”) in this case it returns

< test >blahblah< /test >

is there anyway to have it return just what is inside without having to use regex?
If not, there is a way to extract that using one assign activity + regex right?

Thanks!

[ClaytonM]

@rileythiessen

One more quick question, when I loop through the XMLDocument.Element(“collection”).Elements(“event”) and then i extract the item.Element(“test”) in this case it returns

I went and typed this out quick to see, and there’s a list of properties you can use with the xml object. So just type a period next to your code, and you will see that there is “Value”. That should give you what’s inside. If not, try other items in that list.

Regards.

[rileythiessen (RJ)]

Beautiful that worked! Thank you so much