mail Encryption

Accepted Solutions (1)

Accepted Solutions (1)

saikatk2447661

24-01-2018

Hi Daniel,

Sha256 is a hash function. It will create a hash value which is unique for the particular input. But it is almost impossible to do the reverse (get the input from the hash). You can try the "crypString()" function. It will encrypt the input with the default key (if no key is specified). Then you can use decryptString() to get back your input.

Here you can get a good reference.

SHA: Secure Hashing Algorithm - Computerphile - YouTube

Thanks

Saikat

Answers (2)

Answers (2)

Jean-Serge_Biro

MVP

22-01-2018

Hi wkt,

It depends of your RDBMS (DB engine) version: either you can use the factory function SHA256 directly in the Query assistant (advanced tab) if your DB engine version supports it (as for MD5 encryption), or you can use it in Javascript code by using the JSAPI function as is:

digestStrSha256(source.target__addressSpecific)

(here with nms:subscription addressSpecific field, but of course you can do it with nms:recipient.email field).

Please see below the Query expression editor/advanced choice:
1400582_pastedImage_0.png

Regards

J-Serge