Solved

Export XML file

  • 3 August 2022
  • 2 replies
  • 114 views

Userlevel 2
Badge +4

Hi,

Is it possible to gather data then generate, export and download an .xml file by executing a task in Web GUI?

Thanks!

icon

Best answer by Marvin Alibahadoer 12 August 2022, 11:37

View original

This topic has been closed for comments

2 replies

Userlevel 1

Hi,

 

You can create a task and do select statement of the records you would like and use XML path to create the XML. If you want to create a .xml file of the result you could convert the result to a varbinary(max). We use a similair task and save the varbinary to a new record in a table that holds exported files so the user can download the file from the application. Alternatively, you could probably save the file on a storage location.

Hope this helps!

Marvin

Userlevel 2
Badge +4

Hi Marvin, 

I have tested this with some dummy code and does work! Thank you!
Although the automatic download is not achievable (as far as I tried), but I can at least generate a .xml file.