Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Encrypt data

Avatar

Level 2

Hello everyone,

I was wondering if there's any function that we can use to encrypt data, for instance an email of a client in the enrichment box.

 

Thank you.

 

Best regards

1 Accepted Solution

Avatar

Correct answer by
Level 3

Hi @Ofattah ,

1.Cretae sql function based on the configured database(Postgres,Oracle..etc) to encrypt/decrypt the string.

2. Using javascript call the function to encrypt/decrypt the string.

var encrypt = sqlGetString('select encrypt($(sz))', email);

 

Regards,

Malarrajan Sundarraj

 

 

View solution in original post

7 Replies

Avatar

Correct answer by
Level 3

Hi @Ofattah ,

1.Cretae sql function based on the configured database(Postgres,Oracle..etc) to encrypt/decrypt the string.

2. Using javascript call the function to encrypt/decrypt the string.

var encrypt = sqlGetString('select encrypt($(sz))', email);

 

Regards,

Malarrajan Sundarraj

 

 

Avatar

Level 2

Hi @Malarrajan_Sundarraj 

 

Thank you for your response.

Is there any built-in function that we can use in the enrichment box to encrypt whatever fields we want please?

I found this function :

encryption_aescbcEncrypt

but it's usable only on Adobe campaign standard, I need a function that we can use in the enrichment box on Adobe Campaign Classic.

 

Thanks

 

Best regards

Avatar

Level 2

Hi @Ofattah ,

 

You can try the below basic encryption functions available in advance section: 

Sha256Digest (<String>)

Sha512Digest (<String>)

 

Thanks!

Avatar

Level 2

Hi,

Thank you for your help,

Is the Ecrypted data by Sha256Digest (<String>) or Sha512Digest (<String>) decryptable? Because we need to decrypt it too.

 

Thanks

Best regards

Avatar

Level 3

Hi @Ofattah ,

Yes, encryption_aescbcEncrypt function usable only in ACS for encryption alone.

 

We do have function in ACC as well.

https://experienceleague.adobe.com/developer/campaign-api/api/f-cryptString.html

But we cannot decrypt the string, because the function was deprecated.

 

Better approach would be create SQL based encrypt/decrypt fucntion and can be used via JS/Enrichment box

 

https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/api/addi...

 

Regards,

Malarrajan Sundarraj