Custom export to excel from API

Question

Hi, I have a read-only grid that displays real-time data, populated through a local variable from an API. Users have requested an "Export to Excel" button. Is it possible to enable this functionality without storing the data in a database table?

Stefan Helzle · Answer

The most simple approach would to export to CSV. That's easy to do and can be opened in Excel.

Soma · Answer

I see two ways to do it here 
 1. Create a process that gets the data and store it in a temporary table. Then use export DSE to excel, and empty the temporary table. 
 2. Create a synced record for the service, then you can use the record data as the source to grid and export data.