How to export only Read Grid Data in an Excel

Question

Hi All, 
 Could someone help me on the below? 
 I want to export a read only Grid Data in an excel when the source is not a record type but a Query Entity? 
 
 Thanks 
 Faisal

Danny Verb · Answer

The easiest thing to do is use your data base and make a record type for your data. If that is not an option, you can create a dynamic link about your grid and use the function a!exportDataStoreEntityToExcel, https://docs.appian.com/suite/help/20.4/Export_To_Excel_Smart_Service.html#a!exportdatastoreentitytoexcel() 
 This function will generate an excel document in the system but will not download it to the users browser. The allow the user to download the document you will need two links which will swap places. First, have a dynamic link to generate the excel document and use the document output in the onSuccess parameter to to save it into a local variable. Then have a new dynamic link appear using a!documentDownloadLink()