Read Multiple XML Files

Hi there,

I was trying to read in multiple xml files in order to paste the extracted data into a excel file. This is my first phase of the project but I couldn’t read out each of the file inside the folder. Could anyone please help me to check which part or any missing part I need to add so that I can read through each xml files that I had stored inside a folder?
Read Multiple XML(Autosaved).xaml (7.0 KB)

Hi,

I suppose you need to put Read Text File Activity before Deserialize XML as the following image.

Regards,

Hi @Yoichi
I had put it the ead text activities. But still, my output panel couldn’t show any write line result.

Hi,

Can you share your xml file?

Regards,

@yushinchan Remove System.IO and use Directory.GetFiles(“C:\Users\UTAR04480\Desktop\Sample XML”, “*.xml”)

hi @MartianxSpace
I removed it but the output does the same. What’s wrong to my workflow?

Hi,

Thank you for sharing.
It seems there is no problem in your xml.

Can you check if your xml file has been read as you think, using the following xaml.
(I added some write line activities.)

Read Multiple XML(Autosaved).xaml (9.3 KB)

Regards,

Hi @Yoichi

The result ended up with this.
Capture1

Hi,

I’m sorry i had a mistake.
Can you modify first Write Line as the following?
"FilePath Count:"+s_path.Count.ToString

Regards,

hi @Yoichi
I had modified on it but my output still doesn’t appear yet.
Capture3

Hi,

Thank you for your attempt.
This result shows you failed to get any filenames of xml file.

Can you check there is xml file(s) (and its extension is .xml) in your path - “C:\Users\UTAR04480\Desktop\Sample XML”?

Regards,

Hi @Yoichi
There’s the extension problem. I got the results :’)
Thanks for your advice.

1 Like

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