Skip to main content
A
ankitab535847
August 30, 2023
Question

Download excel/csv document from a grid on a single click

  • August 30, 2023
  • 11 replies
  • 0 views

My requirement is as below:

I have a set of Ids, and using an integration I am getting all details of the records of those Ids. After certain manipulation of the dataset, i am displaying the dataset on a grid.

Now I want to download the same grid to an excel/csv document.

Please note, I am not saving the data in any table so I can't use export to csv from DSE option.

What I have tried is using an document WebApi where I pass my Ids and get the details and download the document. 

The problem with this approach is: 1) I have to call the integration again and do those manipulations again

2) The Ids I am passing as query parameters. When there are more than 1000 ids, the url is becoming too long and the API is failing.

Can anyone please suggest an alternative approach to resolve this issue

TIA

    11 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    August 30, 2023

    Doing all this data manipulation in memory seems not to be a great idea. But regardless of this, I do not see a way to achieve this in a single user interaction.

    A
    ankitab535847Author
    August 30, 2023

    Can you suggest any other option

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    August 30, 2023

    For what? The data manipulation? Currently the best option in terms of speed and resource consumption is a table in the database. Then the API CSV download approach would work as well.

    abhayd3663
    abhayd3663
    August 31, 2023

    >>2) The Ids I am passing as query parameters. When there are more than 1000 ids, the url is becoming too long and the API is failing.

    In that case, pass the Ids in the request body.

    A
    ankitab535847Author
    August 31, 2023

    So I am using the web api url in the link field of an interface. At the end of the url i am passing the case Ids which is becoming the query parameters. If I have to pass them in the request body, can you suggest how do i pass the case Ids using the url. It would be very helpful if you can send a sample code

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    August 31, 2023

    Normal HTML Links do not support a HTTP body.

    prejip
    prejip
    January 19, 2024

    Hello all,

    I have somewhat similar requirement and would need your help and expertise to find a solution.

     

    So we have an external database (Mongo DB) from where we are fetching our data ( from multiple tables/collections) using integration and display this data on Appian UI after doing some alteration on few fields.

    And in my grid am displaying around 35 columns and row many go upto 100 in certain cases.

    Now the users what a download option, as we dont save data in appian export to CSV/excle from DSE isn't an option for us.

    So how can I download this large data in Appian.

    Thanks In advance,

    Preji

    Terms & ConditionsAccessibility statement