How to read data from the xml file in nintex workflow?

  • 30 April 2018
  • 4 replies
  • 21 views
D
Badge +4

Hi Team,

I have a xml file in the following format.

Could you please tell how we can read it?

<?xml version="1.0" encoding="utf-8"?>

<RepeaterData>

<Version />

<Items>

<Item>

<eee839ca-577c-43c2-af32-1d74ee1de64f type="System.Int32">2017</eee839ca-577c-43c2-af32-1d74ee1de64f>

<f21208c6-0f13-407b-9910-4413d7fe27f0 type="System.Int32">100</f21208c6-0f13-407b-9910-4413d7fe27f0>

<_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27 type="System.Int32">200</_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27>

<_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7 type="System.Int32">100</_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7>

</Item>

<Item>

<eee839ca-577c-43c2-af32-1d74ee1de64f type="System.Int32">2018</eee839ca-577c-43c2-af32-1d74ee1de64f>

<f21208c6-0f13-407b-9910-4413d7fe27f0 type="System.Int32">200</f21208c6-0f13-407b-9910-4413d7fe27f0>

<_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27 type="System.Int32">300</_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27>

<_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7 type="System.Int32">50</_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7>

</Item>

<Item>

<eee839ca-577c-43c2-af32-1d74ee1de64f type="System.Int32">2019</eee839ca-577c-43c2-af32-1d74ee1de64f>

<f21208c6-0f13-407b-9910-4413d7fe27f0 type="System.Int32">300</f21208c6-0f13-407b-9910-4413d7fe27f0>

<_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27 type="System.Int32">100</_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27>

<_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7 type="System.Int32">100</_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7>

</Item>

<Item>

<eee839ca-577c-43c2-af32-1d74ee1de64f type="System.Int32">2020</eee839ca-577c-43c2-af32-1d74ee1de64f>

<f21208c6-0f13-407b-9910-4413d7fe27f0 type="System.Int32">100</f21208c6-0f13-407b-9910-4413d7fe27f0>

<_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27 type="System.Int32">50</_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27>

<_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7 type="System.Int32">100</_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7>

</Item>

<Item>

<eee839ca-577c-43c2-af32-1d74ee1de64f type="System.Int32">2021</eee839ca-577c-43c2-af32-1d74ee1de64f>

<f21208c6-0f13-407b-9910-4413d7fe27f0 type="System.Int32">100</f21208c6-0f13-407b-9910-4413d7fe27f0>

<_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27 type="System.Int32">200</_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27>

<_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7 type="System.Int32">300</_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7>

</Item>

<Item>

<eee839ca-577c-43c2-af32-1d74ee1de64f type="System.Int32">2022</eee839ca-577c-43c2-af32-1d74ee1de64f>

<f21208c6-0f13-407b-9910-4413d7fe27f0 type="System.Int32">100</f21208c6-0f13-407b-9910-4413d7fe27f0>

<_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27 type="System.Int32">100</_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27>

<_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7 type="System.Int32">20</_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7>

</Item>

<Item>

<eee839ca-577c-43c2-af32-1d74ee1de64f type="System.Int32">2023</eee839ca-577c-43c2-af32-1d74ee1de64f>

<f21208c6-0f13-407b-9910-4413d7fe27f0 type="System.Int32">20</f21208c6-0f13-407b-9910-4413d7fe27f0>

<_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27 type="System.Int32">20</_x0037_cea2d0d-ec8c-4c2f-bc71-23b7fe9aae27>

<_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7 type="System.Int32">20</_x0031_37a2f24-bf65-42e8-a135-eb5794ba40c7>

</Item>

</Items>

</RepeaterData>

I would like to get the output format like below

2017 100 200 100

2018 200 300 50

2019 300 100 100

2020 100 50  100

2021 100 200 300

2022 100 100 20

2023 20  20  20

Thanks & Regards,

Dhaya

4 replies

bamaeric
Userlevel 5
Badge +13

Here's a good post on Nintex Forms/Workflow - Parsing Repeating Section Data

N
Badge

Thank you... this helps a lot!

Get Outlook for Android<https://aka.ms/ghei36>

D
Badge +4

Its not help full & not clear.

I have a data in xml. But could not able to retieve. Is there any other link.

Please help us

MegaJerk
Userlevel 5
Badge +14

That guide, and subsequently your XML would make a lot more sense if you were to name the controls inside of your Repeating Section instead of leaving them as anonymous controls: 

215153_pastedImage_1.png

When you leave the control name blank, the XML generated will use the long guid (the Control's formcontrolid attribute) as the node name, which is fairly impossible to work with. 

Please name all of your controls, and then take a look at that XML. Afterwards, download the UDA from that blog and maybe take it apart. 


Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings