XML Extraction

Help Activities
1

Morning All

I have the below XML file and im trying to extract into a datatable

ApplicationCorrespondance - surrounds the entire file
Each Section is
ApplicationCorrespondaceData

I need to extract everything in the picture

I have For Each loop set to XML.LINQ.XELEMENT
but now I am stuck

image
image1063×613 45.1 KB

2

@robin.morgan
Welcome to the forum

Deserialize the XML with the deserialze XML acttivity - xDoc as output Variabtt
hen try:

For each Activity: item in cDoc.Root.Descendants(“DocumentData”)

  • (Again A nested loop):
  • For Each xe in item.Elements()
    • Log Message: xe.Name & " - " & item.Value
3

Hi @robin.morgan

Welcome to UiPath community

Have a look on the docs

Hope it will help

Regards
Gokul

4

Thankyou both for your replies, I have now managed to extract the data but now have another issue.

Im writing the data to a datatable, putting all of the items as an array. The only issue I have is if one of the items is not in the DocumentData it throughs an error.

So say some of the DocmuentData’s may or may not Contain thus thrwoing the error. I tried “Allow Nulls” in the build datatable but to no effect

5

maybe you can elaborate more on the scenario and share also with us of
what you have done so far
sample xml
and expected output example / sample

6

ill add another reply up tomorrow, unfortunately I cannot add the full XML as it contains sensitive information

7

So I have gotten so far but im stuck again

I have a for each loop running through the “pair:ApplicationCorrespondenceData”
but some of them have 2 sets of DocumentData.
Im writing to a datatable, so I would need the header data the same for each row, but the doc data on seperate rows.
I’d have to loop again, but how do I do this

image
image912×757 62.2 KB

8

as far we understand your question looping as mentioned above should be doable as well.

we can also navigate from one to another XElement e.g. to the parent

in such scenarios we can collect data step by step and add it afterwards to the datatable. E.g drNew = DataTable.NewRow and succesive population of drNew during the different nested loops

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.