Solved

Asynchronous Excel Result Download

  • 8 December 2021
  • 1 reply
  • 91 views
E
Rank
Badge +9

I have a requirement that end users must be able to download a result set from the Web GUI. Normally i implement this with the export functionality that is included in the Software Factory.

The issue with this result set is that it can easily contain 100.000s records. There is no need to see this result set, or a parts of this result set in the Web GUI. I only need to download an excel file with the full result set.

I can imaging that i have an asynchronous task that creates the excel file on the server and can be downloaded by the end user.

What is my best option to implement this in the Software Factory (2021.2) with the Web GUI (latest version)? 

icon

Best answer by Erwin Ekkel 10 December 2021, 10:45

View original

1 reply

E
Rank
Userlevel 6
Badge +16

Indicium has the option to export as XLSX by adding &$export=xlsx to a select request. Adding this request as an API call in a system flow you can schedule this without using web gui resources. 
If this does not suffice you could also utilize the reporting service to create a report in the background. 



 

Reply


Terms & ConditionsCookie settings