Extraction of Data From a XML File

[minolp (Minol)]

I just need to know what’s the best way you recommend to extract data from an XML file that needs to go into a Orchestrator Queue.

[PeCour]

Hi @minolp,
this video did help me: How to parse specific XML data in UiPath - Full Tutorial - YouTube.
You can process the XML file and pass on the extracted data into the queue.

[ushu (Usha kiranmai)]

Hi @minolp

→ Desearilize XML
→ Extract the required data from XML and store those into variables
→ Load those variables data to the Orchestrator queue

[ppr (Peter Preuss)]

XML files can occur in different forms
When your XML is defining namespaces have look here on how to handle:

XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types)

Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] In some cases, we can also do: Assign Activity - xnsDefault = xDoc.Root.Name.Namespace Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</…