Encrypt data

[Ofattah]

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

[Malarrajan_Sundarraj · Accepted solution]

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

[Ofattah]

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

[Sukrity_Wadhwa]

Hi @Malarrajan_Sundarraj,

Could you please help @Ofattah further here?

Thanks!

[Rishabh_v]

Hi @Ofattah ,

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

Sha256Digest (<String>)

Sha512Digest (<String>)

Thanks!

[Ofattah]

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

[Malarrajan_Sundarraj]

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

[Ofattah]

Hi @Malarrajan_Sundarraj 

Thank you for your help, 

I will try your suggested solutions.

Thanks

Best regards