cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

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

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

Labels: (2)
Tags (1)
0 Kudos
Reply
4 Replies
Workflow Hero

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

0 Kudos
Accept as Solution Reply
Workflow Hero

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

Thank you... this helps a lot!

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

Accept as Solution Reply
Workflow Hero

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

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

0 Kudos
Accept as Solution Reply
Workflow Hero

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

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: 

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. 


Accept as Solution Reply