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

Ofattah
Level 2
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
Malarrajan_Sundarraj
Correct answer by
Level 3
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
Malarrajan_Sundarraj
Correct answer by
Level 3
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

Ofattah
Level 2
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

Rishabh_v
Level 1
Level 1

Hi @Ofattah ,

 

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

Sha256Digest (<String>)

Sha512Digest (<String>)

 

Thanks!

Ofattah
Level 2
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

Malarrajan_Sundarraj
Level 3
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

 

Ofattah
Level 2
Level 2

Hi @Malarrajan_Sundarraj 

Thank you for your help, 

I will try your suggested solutions.

Thanks

 

Best regards