Quick update, I’ve managed to get things working without a function with the following nodes:
- MySQL node:
The key guidance here was using the TO_BASE64(content) in the SQL statement, but also by adding TO_BASE64(content) as binaryfield as follows so that the variable is available to other nodes:
SELECT TO_BASE64(content) as binaryfield FROM TABLE
- Move Binary Data node
This node moves the data from JSON to Binary, but only works if I enable the Data is Base64 from the options as circled below:
Then it was just a simple case of writing binary file with the final node.
The final workflow is below - I’ll have to fumble my way through a javascript function at some point in the future! Thanks to everybody for their help.