Hi @nonecked ,
This is Marlon from the Support Team.
The download action will get the file contents. There are different ways to handle file contents that need to be transformed and moved to a record/table.
To transform a file's content to binary in Workato, you can use the Base64 encoding and decoding features. Here are the steps you can follow:
Download the File Content: First, download the file content from the source system. This can be done using the appropriate connector and action, such as "Download file" from Dropbox, Google Drive, or any other supported service.
Base64 Encode the Content: Use Workato's formula to encode the file content to Base64. This converts the binary content into a set of standard characters, which can be useful for transferring over networks or storing in systems that require Base64 encoding.
- Formula for encoding: Base64.encode(file_content)
Base64 Decode the Content: If you need to convert the Base64 encoded content back to binary, use the decoding formula.
- Formula for decoding: Base64.decode(encoded_content)
Upload the Binary Content: Finally, upload the binary content to the destination system using the appropriate connector and action, such as "Upload file" or "Upload file using file contents"
For more detailed instructions and examples, you can refer to the Workato documentation on handling binary files and Base64 encoding:
