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