topic RE: How to get values from XML in Product Forum

How to get values from XML

SafronovDI — Tue, 12 Sep 2023 06:08:00 GMT

Hi everyone! Could you help me to find a solution? I don't understand, how can I get the values from XML. I have the XML as below. My goal is to get the values of " Row_3" and " Row_4" inputs. So, I need to find in the output the values 3333 and 4444.

<parameters>
<inputs>
<input name=" Result" type=" text" value=" List"/>
<input name=" Data" type=" collection">
<row>
<field name=" Row_1" type=" text" value=" 1111"/>
<field name=" Row_2" type=" text" value=" 2222"/>
</row>
</input>
<input name=" Row_3" type=" number" value=" 3333"/>
<input name=" Row_4" type=" number" value=" 4444"/>
</inputs>
<outputs/>
</parameters>

Thanks!

------------------------------
Demyan Safronov
System administrator
Priorbank (part of Raiffeisen Bank International AG)
Europe/Minsk
------------------------------

RE: How to get values from XML

Babjee24 — Tue, 12 Sep 2023 09:08:00 GMT

Hi Demyan,

You can use the Utility XML VBO for this and using get element by path you can get the values respectively

------------------------------
Babjee Vangipurapu
Senior RPA Developer
Wonderbotz
India
------------------------------

RE: How to get values from XML

chrispotvin — Tue, 12 Sep 2023 12:41:00 GMT

Hi Demyan,

I'm assuming that there is an <output> tag after the <parameters> but before the <inputs> tag? I believe your missing that one in your example. Does the name=" Row_3" change or does it remain the same with every XML?

Thanks!

------------------------------
Christopher Potvin
Senior RPA Developer
SS&C Blue Prism
Canada
------------------------------