How to perform operations on data before Export To Excel functionality

Certified Senior Developer

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 export

I 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