Retrieving secure string from datatable

[Will_Tyler]

I have a secure string type in my datatable but when I try to extract it or even use a Type SecureString I’m not able to do anything because I can’t convert an object to a secure string. Any advice?

[ranjith]

@Will_Tyler

secureString = new system.Net.NetworkCredential(string.Empty, your_object.ToString).SecurePassword

Try the above expression in assign activity

[Lahiru.Fernando]

Hi @Will_Tyler

Check the below thread which I posted some time back on Secure string. It has a working sample workflow as well. it helps you to convert string to secure string and secure string back to string…

I guess this is what you are looking for…

How to convert SecureString to String: Password from Orchestrator credentials

Hi @vonswanity Welcome to the community!! I have a sample workflow which converts a string to secure string (represents Orchestrator password), and secure string back to normal string. Check this out… It should help you… Secure String Sample.xaml (5.9 KB) If this helps you, please make sure to mark my answer as the solution too Let know how it goes…

[ClaytonM]

You can try using CType - to convert type…
CType(row("col"), System.Security.SecureString)

EDIT: Also, reason I am suggesting this is because you say your value is already a secure string type but is just inside an object type, which means you need to convert the object to the secure string. If it was a string type, then this will be different, and would need to use NetworkCredential() suggestions to take a string and convert to a secure string.

[Will_Tyler]

@ClaytonM

CType(row(“col”), System.Security.SecureString)

That worked. Thank you!