ETL: Base64EncodeToString

Encode a byte array into a Base64 string using the standard encoding scheme. Use for preparing binary data for API calls in ETL pipelines.

Description

Encodes a byte array argument into a string using Base64 encoding scheme.

Syntax

Base64EncodeToString(bytearray_expression[, chunked])

Arguments

bytearray_expression - an expression that represents a bytearray value to be encoded

chunked (optional) - if true, the output will be chunked into 76 characters blocks (boolean, default false).

Examples

Base64EncodeToString(GetBytes('hello world')) returns ‘aGVsbG8gd29ybGQ=’.

Base64EncodeToString(GetBytes('username:password')) returns ‘dXNlcm5hbWU6cGFzc3dvcmQ=’.

Return value datatype

String

Impact of null value

If input is null, returns null.