topic Convert Collection to XML in Product Forum

Convert Collection to XML

BrianneGacad — Fri, 30 Aug 2019 07:18:00 GMT

Hi All,

Just wondering if anyone has come across a solution of converting a collection to XML.

XML is to be then used by a SOAP API.

Similarly and not sure if this is even the best way but has anyone encountered a solution where it converts a json directly to an xml file for API consumption?

Looking forward to your inputs!

Thanks!

Brian

------------------------------
Brianne Gacad
Senior IT Domain Specialist
Telstra
Australia/Melbourne
------------------------------

RE: Convert Collection to XML

John__Carter — Fri, 30 Aug 2019 08:18:00 GMT

Hi Brianne - if you push the collection into a code stage as an input parameter, you can treat it as a DataTable object, and there will be plenty of conversion examples to borrow from. That said, debugging code in BP can be painful because the code stage is not an IDE, really it's just an execution mechanism. So for anything non-trivial, use a true code editor to get the code right before pasting into BP.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Convert Collection to XML

GopalBhaire — Sat, 31 Aug 2019 10:50:00 GMT

I posted the same to other question, maybe it'll work for you.

You can loop over the collection and use a multicalc to generate the desired XML.

OR you can use code stage with collInput (collection) as input and xmlResult (text) as output.

Dim sw as Object
sw = new StringWriter() 
collInput.WriteXml(sw)
xmlResult = sw.ToString()

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Convert Collection to XML

BwalyaKasase — Fri, 12 Mar 2021 09:57:00 GMT

Hi Gopal,
Had the same question and tried your solution above but encountered this error:

Page: Action 1
Stage: Code1
Type: Error
Action: Validate
Description: Compiler error at line 2: Type 'StringWriter' is not defined.
Repairable: No

Any idea what the cause and fix is?

thanks

------------------------------
Bwalya Kasase
------------------------------

RE: Convert Collection to XML

John__Carter — Fri, 12 Mar 2021 14:13:00 GMT

Hi Bwalya try changing the line to this.

sw = new System.IO.StringWriter

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Convert Collection to XML

TobiasArnold — Fri, 12 Mar 2021 14:16:00 GMT

Hi Bwalya,

maybe you have forgotten to import the namespace "System.IO"? Or easier replace "StringWriter" with "System.IO.StringWriter"

------------------------------
Tobias Arnold
RPA Developer
ITERGO GmbH
Europe/Duesseldorf
------------------------------

RE: Convert Collection to XML

AndreyKudinov — Fri, 12 Mar 2021 23:49:00 GMT

dt.WriteXml would output xml, but you mention that you need to feed it to soap api later, you can't just convert it to any xml and expect it to work.
You need to send xml that service expects to get, which is described in wsdl. You can probably use SoapUI to get a "template", then fill it from your collection in a loop.

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