XML to Collection

[HarshSharma2]

Hi All,

I am facing a situation where in I'm getting data from web-services into a Text data-type but it's in XML format, which has multiple record with same XML headers and multiple such elements.

I need a method/code to convert that XML code to Collection, I believe we have an Utility-XML but it converts one element into collection. and because of huge data I can't loop this utility as that would be time consuming.

Can anyone suggest how to get all records per element from XML into Collection?

Thanks in  advance. 

------------------------------
Harsh Sharma

------------------------------

[TetsujiJunicho]

Hi,

You might want to use Utility - XML Object of the Developer Jumpstart site: https://portal.blueprism.com/products/developer-jumpstart

Hope this helps.

------------------------------
Tetsuji Junicho
Manager of RPA Practice Grp.
Accenture Japan
Asia/Tokyo
------------------------------

[AndreyKudinov]

You can try this:
https://github.com/aikudinov/BlueprismVBO/blob/master/BPA%20Object%20-%20Utility%20-%20XML2Collection.xml
You don't have an embedded schema in your xml most likely, so that would be "Read DataSet from XML String (no Schema)​" or "Read DataTable from XML String (no Schema)" if you need specific "table".

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------