XML creation from data table and template

[ammohan]

Hi,
I have a DT with 2 columns “PhoneNumber” & “Message” which is used to send bulk SMS.

I want to populate a XML template with the dynamic values from the input DT, with “to” and “body” mapping to the “PhoneNumber” & “Message” columns of the DT
Can UiPath create this XML template with all the values from the DT?

Please let me know your insights.

Cheers,
Amrutha

[ammohan]

I’ve also attached the screenshot of the XML template.

[Anil_G (Anil Gorthi)]

Hi @ammohan

Take a look at this

Data Table to XML in Uipath

Else if you have all the nodes already then read xml parse it and loop

How to parse specific XML data in UiPath - Full Tutorial

Cheers

[Yoichi]

Hi,

Which result do you need?

The following sample outputs the above 2 xml files from datatable.

xeMessage1 = New XElement("messages", New XElement("accountreference", "EX034xxxxxxx"), New XElement("message",  dt.AsEnumerable.Select(Function(r) {New XElement("to",r("PhoneNumber").ToString),New XElement("body",r("Message").ToString)})))

xeMessage2 = New XElement("messages", New XElement("accountreference", "EX034xxxxxxx"),    dt.AsEnumerable.Select(Function(r) New XElement("message", {New XElement("to",r("PhoneNumber").ToString),New XElement("body",r("Message").ToString)})))

Sample20221210-4aL.zip (3.0 KB)

Hope this helps you.

Regards,

[ammohan]

Thanks @Yoichi. The second solution worked.

Appreciate your help.

[ammohan]

Hi @Yoichi,

I am getting this error when I created an exact replica of the workflow in another process. Can you please help me with this issue?

Thanks,
Amrutha

[Yoichi]

Hi,

Can you try to set parameters as the following?

Regards,

[ammohan]

Awesome! That worked.

Thank you so much!