I have a Table which contains encrypted data in some columns, I want to export that data to excel file, but before that I need to run some decryption functions (can be achieved on Appian side only and not on DB side) and then mail to X Team from Appian. How can I achieve this?I have tried a!exportDataStoreEntityToExcel() which does not allow data manipulation during exportI have similar functionality where I use excel tools plugin to achieve a downloadable file using getdatasubsetdownloadlinkfromprocess() which downloads the file directly to the local machine. Can this be modified to the above purpose?
Discussion posts and replies are publicly visible
Appian recommends using Export Data Store Entity to Excel Smart Service, so you could read the encrypted data from the table in Appian, process it in Appian, write it back to a temp table and then call a!exportDataStoreEntityToExcel.
For what it's worth (and at the risk of beating a dead horse), export DSE to Excel is not useful for basically any of my use cases until it at least gains the ability to use a Base Excel Template while exporting, and accepts sorting parameters (since at the moment there's literally no way to sort exported data other than handling sorting directly in the database, which is definitely unscalable).
I agree, not being able to use sorting and excel template hurts. it is as good as exporting data to CSV file but in excel formatted file.
Sadly, no recent activity on my feature request, which basically addresses all these points.