Parsing xml files to SQL tables

Help Activities
, , , ,
1

Hi,
can you please help me with parsing xml files into tables? I have thousands of XML files in a folder like this:
image

And I would like to parse them into separate tables in MS SQL database.
XML samples:
3I6LAKPVSLXSK316_FLX101_202164_152620_result.xml (10.1 KB)
316COGLT07XSK316_FRX101_2020921_94834_result.xml (1.6 KB)

And I need to somehow parse all of these XML files to tables for example by the “test name” because I would like to create a report from these data via Power BI.

What I imagine is that the tables would look something like this. Each table contains the order id, DateTime from the eolpresenting, and the values from the tests.
Example of one output table:
image

Thank you

2

Hi!

This user guide might help you
https://docs.uipath.com/activities/other/latest/user-guide/read-and-deserialize-a-xml-file

1 Like
4

Hi, thank you for your answer but I still struggling with how to do it. I´m a beginner with UiPath and this looks like another level. I would like to go through all these xml files and get all the values from the tests and put them into a specific table in the SQL database. My idea is to have a table for each (for example test name=“Manual test” + each of these tables would contain OrderId and DateTime from eolpresetting. Should I first create these tables manually in SQL and then somehow insert values into these tables using RPA? Thank you for your advice

5

Hi!

Create the tables you think you would need in your database.
Then insert the parsed xml’s into your tables.
That’s not the difficult part, you have activities for doing SQL in this package https://docs.uipath.com/activities/other/latest/user-guide/about-the-database-activities-pack

The difficult part is parsing your xml’s into datatables (All about Datatable - UiPath) before you insert them into your database.

6

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