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.