XML Assistance

[Daniela_Valdez_Luis]

Hey there!
I’m working with the UiPath Workday Activities and I’m retrieving the output results of a report and they’re being shown as an XML file, said XML file has the following format:

<wd:Report_Data xmlns:wd="Workday Namspace">
  <wd:Report_Entry>
    <wd:First_Name>John</wd:First_Name>
    <wd:Last_Name>Doe</wd:Last_Name>
    <wd:Employee_ID>000000</wd:Employee_ID>
  </wd:Report_Entry>
  <wd:Report_Entry>
    <<wd:First_Name>Jane</wd:First_Name>
    <wd:Last_Name>Doe</wd:Last_Name>
    <wd:Employee_ID>111111</wd:Employee_ID>
  </wd:Report_Entry>
</wd:Report_Data>

I want to retrieve the First_Name out of the existing nodes. For that I’m performing the following steps:

1. Retrieve XML String
2. Utilize Deserialize XML and convert into an XDocument type of variable.
3. Utilize For Each activity and change the TypeArgument in the For Each loop to System.Xml.Linq.XElement
4. Add into the In box the following statement: XMLDocument.Element(“Report_Data”).Elements(“Report_Entry”).Descendants(“First_Name”) But I’m getting the following error: For Each: Object reference not set to an instance of an object.

Please assist me to retrieve the First Name out of the existing elements in the XML file.

Thanks!

[ppr (Peter Preuss)]

you need to handle XML namespaces as described here:

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

[Daniela_Valdez_Luis]

Great! Thank you
I’ll give it a read!