Hello,
I have designed a flow to download a file from QuickBase via HTTP action and add this file to Dropbox with the build in add file action.
The HTTP action supplies in the body an object of
{
"$content-type": "image/png",
"$content": "sample123654"
}
When I supply this output to file content in the add file to Dropbox the automation works fine but the file cannot be opened in Dropbox it is a corrupted file.
(when i have downloaded the file from Dropbox and opened the file with notepad it was null)
I tried to input the whole output object.
I tried to input just the $content part of the file output.
I tried to append to the array like bellow.
{
"name": "test.png",
"contentBytes": {
"$content-type": "image/png",
"$content": "sample123654"
}
based on the QB documentation this output encoded in base64 format
based on Power Automate documentation the file content should be supplied in binary
I don't have much understanding in those formats. I tried to use the formula to convert base64 to binary
but the result of the conversion didn't change the file content it still had the same characters in the $content the only change i saw was the "$content-type": changed from "image/png" to "application/octet-stream" and the result in Dropbox was also a corrupted file.
Please help me figure what I need to supply to the file content and if format conversion is needed.
or if I'm missing something else.
Thank you.