XML Parsing in Blue Prism

Question

I'm new to Blue Prism and exploring things on my own.

I'd like to parse the data from XML to Tags in one column and Data available in the tags in another column of an Excel sheet. I've imported the BPA-XML Utility. How to proceed further. Any help is much appreciated.

Thanks much in advance.

Answer 1

Using MS Excel VBO is pretty easy, there are many helpfull options in this object.

If you work with xml file, in Blue Prism in Object Studio you mainly use Action in you diagram. First use Open Workbook, then if you want to see it on the screen use Show...etc

Its rly self explanatory.

Answer 2

To get your XML node:

1. Utility - XML::Read File
2. Then on this text you can use Utility - XML::Get Elements whit the name of your tag.

Example: