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
ColumnA,ColumnB,ColumnC
TestA1,TestB1,TestC1
TestA2,TestB2,TestC2
TestA3,TestB3,TestC3
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)
ColumnA,ColumnB,ColumnC
dpfOvRN2kt2yZ1GDEfP2eA+Kdwt0D9SEXn4pB17q6pqvAsLmNE1tQw==,ynVuivnU8DtIrqNbRIm14oJxVfAtS5yZam7MVa111OEZ0PpWYf8Qww==,TestC1
zKkgXApZEhLmkb1sBTz7eylxKkpcWXakhWBve9N+CS2FUck4cODQYg==,r3zev69xZQCVpjLzkwuu4mXQgq/FA9Fyuh6sIZp09sfLrM9cxG9bDA==,TestC2
PvRH5StneKbRFX7BDw3xHd72OHEOvsIZEHHSfqxYdwNpzHOEL2k6IQ==,CKzyp3m0nSOCcJoMlMotwxDAZfMSrgTYF64WVIlalzoxnDqzpYpyiw==,TestC3
Thank you for your time and reply