Extract Data from XML file and store in an array

Help Activities
, ,
1

I have a XML, where i need to fetch all the values in “File File”

There are multiple places where the “File File”, has appeared. I need the value extracted in an array Variable.

As of now, I have been able to fetch only one value. Please help me fetch as many values in “File File”

WIP.xaml (6.5 KB)
XML_.xml (30.0 KB)

2

the XML is defining Namespaces which are to handle. Have a look here:
XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types) - Help / Community - UiPath Community Forum

give a try at working with the Descendants(… method

3

A flow like this:

This image shows a workflow in a process automation tool where an XML string is deserialized and its root name is assigned to a variable. (Captioned by AI)
This image shows a workflow in a process automation tool where an XML string is deserialized and its root name is assigned to a variable. (Captioned by AI)584×236 15.4 KB

xnsDefault | Datatype: XNamespace =

xDoc.root.name.Namespace

Let us do the following

The image displays a snippet of XML code that lists file paths and related links for various Oracle SDMConsole applications and tools. (Captioned by AI)
The image displays a snippet of XML code that lists file paths and related links for various Oracle SDMConsole applications and tools. (Captioned by AI)721×294 103 KB

4

I used Assign Activity as follows.

Out (System.String) = xDoc.Root.Descendants(xnsDefault + “File”).Select(Function (x) x.Value).ToArray

Out Output is arriving as follows:
System.String

Where do i please need to rectify please

5

use the immediate panel
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

We dont know the details, but when using a Variable of DataType: String() - a String Array you will not get the content, but the DataType when it is involved e.g. log Message, Write Line, using ToString()…

Also have a look at String.Join(" | ", yourOutPutVar)

1 Like
6

The image shows a screenshot of a UiPath automation project with the Expression Editor open and various variables set in a "Log Message" activity. (Captioned by AI)
The image shows a screenshot of a UiPath automation project with the Expression Editor open and various variables set in a "Log Message" activity. (Captioned by AI)1227×758 182 KB

Yes i made use of Log. Enclosed screenshot. Please help where to make the change to get the output.

7

we already told:
use immediate panel for inspections

we mentioned:

and we gave the modified statement:

The datatype of Out has to be a String Array. We also suggest to use more meanfully variable Names within the best practice suggestions

8

@Manish_Bedi
we assume that all doubts are clarified now and also demonstrated the working suggestion within the immediate panel. So let’s close the topic by

9

Sorry Peter, I still did not get it.

In the Assign Activity, correct me that this is right ?

Out: DataType String = xDoc.Root.Decendants(xnsDefault + “File”).Select(Function (x) x.Value).ToArray

Any modifications needed to it …Apologies again for inconvenience

10

No, as mentioned it is returning a String Array

11

Thanks Peter,

Out: DataType Array of String = xDoc.Root.Decendants(xnsDefault + “File”).Select(Function (x) x.Value).ToArray

Now i Passed ‘Out’ variable to Log (info) activity, the output is
System.String

Any miss here

12

we already mentioned:

and when a flat string is needed:

14

in Addition to above, we hope that it can now finalized:

grafik
grafik533×159 14.7 KB

This image is a flowchart consisting of steps to deserialize an XML string and assign values to variables in a process. (Captioned by AI)
This image is a flowchart consisting of steps to deserialize an XML string and assign values to variables in a process. (Captioned by AI)555×341 24 KB

as mentioned:

And omit Out as Variable name as it is a Keyword and can cause compiler confusions

The image shows a portion of a code editor with highlighted instances of the use of the "ToString()" and "String.Join" C# methods, along with directory paths for various Oracle-related shortcuts. (Captioned by AI)
The image shows a portion of a code editor with highlighted instances of the use of the "ToString()" and "String.Join" C# methods, along with directory paths for various Oracle-related shortcuts. (Captioned by AI)710×311 96.6 KB

15

image
image1920×934 76.6 KB

follow the same…
15 value is getting

16

yes That works, Thanks a lot, everyone!

17

@Manish_Bedi

Perfect