1 of 14

Security

AesDecrypt

The AesDecrypt() function decrypts a base64 encoded ciphertext to plaintext, using the given key and initialization vector.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a plaintext. Returns Unknown if one of the parameter values is unknown or outside the common valid boundaries.

Syntax

AesDecrypt(ciphertext, key, vector)

ciphertext = "e3ieQNh8nKH/pHImo+JQmZvr+rhSGn4WHQJyTBmPCbA=" key = "77616d666c51673763346e764b6c725242313668357a7a597131515a78303733" vector = "00000000000000000000000000000000"

AesDecrypt(ciphertext, key, vector)=> "abcdefghijklmnopqrstuvwxyz"

AesDecrypt(ciphertext, key, vector, encoding with BOM)

ciphertext = "e3ieQNh8nKH/pHImo+JQmZvr+rhSGn4WHQJyTBmPCbA=" key = "77616d666c51673763346e764b6c725242313668357a7a597131515a78303733" vector = "00000000000000000000000000000000"

AesDecrypt(ciphertext, key, vector, false)=> "abcdefghijklmnopqrstuvwxyz"

ciphertext BOM = "+8oDxXf+w91SR+/AkjpdcLSbygah8m3OQdapwnkAjvY="

AesDecrypt(ciphertext, key, vector, true)=> "abcdefghijklmnopqrstuvwxyz"

Parameters

Name

Type

Required

Description

ciphertext

text

☑️

The input base64 encoded text which was encrypted you want to decrypt. It should be encrypted with the same key and vector values and using the AES algorithm.

key

text

☑️

Text or data field that holds the encryption key. A key can be generated using AesKey()

vector

text

☑️

Text or data field that holds the encryption vector. A proper Vector value can be generated using AesIv()

encoding with BOM

yes/no

enable or disable encoding with BOM.

AesIv

AesKey

Generates a unique 256 bit AES key, to be used with the AES encryption and decryption functions.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Syntax

AesKey()

AesKey()=> 98cb66a97c968b631cf8135a6add789b848fb1f16cb1cf522d8f3a2c6f3fb759