Data Encription of PII Data While Data Import in Campaign Classic

[ShineVv0823]

Hi Team,

We are have a requriement to encrypt PII data (first name, last name, email, etc) and store in recipents schema and when the delivery is being configured and executed the email, first name, last name have to be decrypted to their actual form and sent in the Email / SMS.

Can anyone please help on the same?

Thanks in Advance.

Thanks,

Shine v.v

[Shubham_Goyal__ · Accepted solution]

Hi @ShineVv0823 ,

You can achieve this by using AES encryption functions.

Use: 

cryptString > to first encrypt and store the data.

decryptPassword > to decrypt when extracting data

One of the similar discussions that I can recall and that you can refer to is: here

Br,

Shubham