BASE64.DECODE

BASE64.DECODE returns the decoded contents of a given base64 encoded string.
Function category: Base64​
Syntax
BASE64.DECODE(arg1)
Arguments
Description
arg1
A based64 encoded string.
Example
Let's say we receive the following user information:
{
  "data": {
    "user": {
      "authorization": "Bearer c2VjcmV0X3VzZXJuYW1lOnNlY3JldF9wYXNzd29yZA=="
    }
  }
}
# Decode user token into human-readable form
BASE64.DECODE(REPLACE(data.user.authorization, 0, 7, ""))
​
# Returns secret_username:secret_password
Notes
To perform the opposite operation, base64 encoding a given string, use BASE64.ENCODE.
AVERAGE
BASE64.ENCODE
Last updated 1 year ago