I need help from this wonderful community.
Situation: I am working on an automation project where some of the columns in the input datatable flowing from one workflow to the another must be encrypted.
I currently use a for loop to iterate through the datatable column and use UiPath.Cryptography pack activity to encrypt each cell value for the given column in the datatable.
This approach works well when the datatable has around 50 to 100 rows, unfortunately the datatable in production will be a minimum of 5000 rows. Using the current approach might not be suitable as I don’t want the dispatcher to take a long time to encrypt and decrypt column values. I have waited for over 10 minutes for 3 columns values to be encrypted (little over 9000 cells to encrypt).
Minimal version of the current Approach in .XAML: EncryptColumValuesCurrentApproach.xaml (10.3 KB)
However, is there a better alternative method to encrypt / decrypt column values in a datatable? For example, Linq method? I am looking to improve the performance and so I am open to any ideas, which can outperform the current approach.
Example: DT with columns ColumnA, ColumnB, ColumnC
Wish: An encrypt / decrypt approach which performs faster than UiPath.Cryptography pack in a for loop
Expected outcome: (lets say I want to encrypt Columns “ColumnA” and “ColumnB” in DT using the AES algorithm)
Thank you for your time and reply