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.
Hey ,Thanks for the solution!I might have to consult with business before implementing the solution as the data is sensitive and not recommended to be stored in DB in unencrypted format under any situation.Note: The DB is shared between various teams who should not be able to view this data.Can you suggest any other methods to achieve this?Also I personally feel like this is very long path we are taking here due to functionality constrains. I hope we can get a new feature update on this soon. As this adds overhead of data management of the temp table.Thank you!
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).
As a workaround (and since we've been given basically no choice) i suggest you look into the Export CDT to Excel smart service in the Excel Tools plug-in; it's deprecated but as far as I know it is still available and still works. This allows us to query, sort, and transform data in a process instance, then write that data to a new Excel file based on a Base Excel Template, all of which can't be done with Export DSE to Excel ().
Thanks Mike SchmittWhere can I grab old version of plugin? I am on Appian cloud here and already have the latest deployed. I am ready to handle the downgrading part of plugin functions if this is gonna help.
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.
I have been able to access the smart service while in the current Appian version and with the current Excel Tools version. If you type "excel" in the node search bar, do you see it?
Sadly, no recent activity on my feature request, which basically addresses all these points.
Awesome! found it using the search bar. it does not get listed in deprecated services drop-down for me somehow hence was not able to find it before. I always thought that we lost a very useful plugin there.