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?
Discussion posts and replies are publicly visible
The most simple approach would to export to CSV. That's easy to do and can be opened in Excel.
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.
Can you use a record type? You don't have to use synced records - you can use the old style expression-backed record type and it will allow you to export to Excel.