This query function performs Base64 decoding of a field. The decoded value is subsequently decoded as binary representation of a string according to the charset parameter, which defaults to UTF-8. To work with actual binary data, use ISO-8859-1 character set.

Function Traits: FieldComputationFunction, Transformation

asstringoptional_base64Decode Name of the field in which to store the decoded value.
charsetstringoptionalUTF-8 The character set to use when transforming bytes to string. Validated type is java.nio.char set.Charset.
  Valid ValuesISO-8859-1
field[a]stringrequired  The field on which to decode Base64 values.

[a] The argument name field can be omitted.

The parameter name for field can be omitted; the following forms are equivalent:




Behavior on Invalid Encoding

An input field that does not contain a valid Base64 encoding may result in the following behavior:

  • Characters outside the base encoding alphabet are ignored.

  • If the base encoding is invalid, the output field is not created.

  • When decoding to a code point that is invalid with respect to the selected charset, the invalid code point is replaced with a placeholder character.

Decode the Base64 value in encoded and stores it in decoded:

decoded := base64Decode(encoded)