AnsweredAssumed Answered

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

Question asked by dhayanandkalimidi on Apr 30, 2018
Latest reply on May 4, 2018 by nmarples

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

Outcomes