xDI

Hello,

The documented approach is a scripting action in a process, using Java’s built-in Base64 decoder.

1. Add a Java Native Scripting action with Scripting Language set to groovy. Put the script in the action’s expression editor, without the %e(...)% wrapper.
2. Get the Base64 string into the script. For one file per row, link a bind link from your query to the action and read the column with __ctx__.getSourceResultSet().getString("<column>"). For a single file, store the string in a session variable and read it with __ctx__.getVariableValue("<path>").
3. Decode it and write the bytes:

importjava.util.Base64
importjava.nio.file.Files
importjava.nio.file.Paths
def rs = __ctx__.getSourceResultSet()
def bytes = Base64.getMimeDecoder().decode(rs.getString("FILE_CONTENT"))
Files.write(Paths.get("C:/temp/output", rs.getString("FILE_NAME")), bytes)

Things to check if the file is missing or corrupted:

• The file is written on the machine running the runtime. With Designer’s local runtime that is your computer; with a remote runtime it is the server. The folder must exist and be writable.
• If the value starts with data:...;base64,, strip that prefix first.
• For URL-safe Base64 (- and _), use Base64.getUrlDecoder().

Docs: Scripting in processes, Scripting context, Java Native Scripting action.

Thank you