topic XML to Collection in Product Forum

XML to Collection

HarshSharma2 — Tue, 15 Oct 2019 09:41:00 GMT

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

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

RE: XML to Collection

tjunicho — Tue, 15 Oct 2019 09:57:00 GMT

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
------------------------------

RE: XML to Collection

AndreyKudinov — Wed, 16 Oct 2019 05:32:00 GMT

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
------------------------------