Skip to main content
Solved

Asynchronous Excel Result Download

  • December 8, 2021
  • 1 reply
  • 98 views
E
Sidekick
Forum|alt.badge.img+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)? 

Best answer by Erwin Ekkel

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. 



 

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

1 reply

E
Moderator
Forum|alt.badge.img+17
  • Erwin Ekkel
  • Moderator
  • 768 replies
  • Answer
  • December 10, 2021

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. 



 

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings