Skip to main content
Answer

Export XML file

  • August 3, 2022
  • 2 replies
  • 140 views
K
Vanguard
Forum|alt.badge.img+4

Hi,

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

Thanks!

Best answer by Marvin Alibahadoer

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

This topic has been closed for replies.

2 replies

M
Rookie

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

Jasper
Kevin Horst
Mark Jongeling
K
Vanguard
Forum|alt.badge.img+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. 

M
Terms & ConditionsCookie settingsAccessibility statement