Skip to main content
B
blerinad9411
October 30, 2024
Question

Custom export to excel from API

  • October 30, 2024
  • 3 replies
  • 0 views

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?

    3 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    October 30, 2024

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

    somasundaram.d
    somasundaram.d
    October 30, 2024

    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.

    peter.lewis
    peter.lewis
    Employee
    October 31, 2024

    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.

    Terms & ConditionsAccessibility statement