Hi @Nic, after lots of trial and error, it does look like this is a limitation with converting the ANSI format to base64.
Here are my findings:
I uploaded the PDF you shared with us during OH on Retool Storage. When I get it through the built-in Retool Storage query, it looks like this:
Here is the response object:
To simulate getting this as the response of an API, I created a REST Api resource that does the same thing, it gets the file:
Update:
We are able to download the pdf file with the following query:
Note: query4 is the one from the first screenshot.
The download is successful:
However, it seems like when we are trying to make the base64 with the response from your API:
... lots of scrolling later ...
It looks like we get the base64 but it seems to not be a perfect convertion. Which leads to the file being corrupted.