Reading XML file using Deserialize XML activity

Help
1

Hi

I am having issues reading this specific XML file when using the Deserialize XML activity.

“chauffeurAek041425MAY194823May19120039.xml”

https://kmau.sharefile.com/d-sd42f690c925443d8

I am fine with reading the other XML file which I have found in the UiPath guides.

“dossier3435.xml”

https://kmau.sharefile.com/d-s1998fa8ac18481b9

Can anyone please assist and help me understand why ?

What is the difference between the two XML files and how can i fix this issue ?

Thanks.

2

Hi @KMkarthikshankar,

How you are trying to do that? It is working fine for me and I’m able to get the nodes inside.
Here are the screenshots :

image

Steps are :

  1. Deserialize XML and save in a variable let’s say XMLDoc
  2. Get XML Nodes and pass the XMLDoc variable and save in a variable as XMLNodes
  3. Iterate XMLNodes and you will get all the nodes inside
3

In For each activity items type should be array of string ?

4

No… change it xelement type @Kamesh

5

Hi Hareesh

I want to use the below xml and extract orderID and localBillerId use deserialize xml activity

image

Thanks
Kamesh

6

Please post the XML, I will try and get back to you @Kamesh

7

<soapenv:Envelope xmlns:soapenv=“http://schemas.xmlsoap.org/soap/envelope/” xmlns:ord=“http://com/comum/commercial/services/orderservice”>
soapenv:Header
<a:Security xmlns:a=“http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd”>
<a:UsernameToken Type=“Index of /wss/” xmlns:wsp=“http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd”>
<a:Username>asdf</a:Username>
<a:Password Type=“http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText”>asdaf</a:Password>
</a:UsernameToken>
</a:Security>
</soapenv:Header>
soapenv:Body
ord:getOrderDetailsForIVR

8391371
7964864552451241246
9879870084

</ord:getOrderDetailsForIVR>
</soapenv:Body>
</soapenv:Envelope>

8

The XML format is wrong above @Kamesh,

Please place it in a txt file and send it

9

It is not allowing the text file to upload @HareeshMR

10

Just drag and drop will work @Kamesh

The formating is missing when you paste the text

11

image
image807×201 5.36 KB

12

Can you try again pasting the XML here @Kamesh?

Or upload the file using another browser :slight_smile:

13

Hey @Kamesh

you can Zip that file and then can share here :slight_smile:

Regards…!!
Aksh
UiPath MVP-2018
Connect

14

sample.zip (525 Bytes)

15

Sorry for the delay @Kamesh

here is the workflow :slight_smile:

NewXML.xaml (9.8 KB)

16

image
image696×302 4.24 KB

17

That is just a for each loop @Kamesh

Try repairing all the packages so that you will get all them once

18

image
image750×376 13.9 KB

19

Are you using it in the same workflow @Kamesh? Or it is different? If it is in the same, we don’t need to use that type.

That is because you haven’t selected the type of ienumerable. select required type in the drop down displayed at the top of the page

1 Like
20

worked thanks Hareesh !!!