Expand my Community achievements bar.

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

Administrator

Hi @Malarrajan_Sundarraj,

Could you please help @Ofattah further here?

Thanks!



Sukrity Wadhwa

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

 

Avatar

Level 2

Hi @Malarrajan_Sundarraj 

Thank you for your help, 

I will try your suggested solutions.

Thanks

 

Best regards