CSV download works well on Mac, but isn’t functioning as expected on Windows

App Building
#1

I have a JS Script that looks like this:

(() => {
	getCSVData.trigger({
    onSuccess: (data) => {
      utils.downloadFile(data, 'report', 'csv')
    }
  })
})()

This is working correctly on Mac, but using Firefox on Windows will show the download prompt but not recommend any application (Excel) to open the file with. You can select Save File and open it manually, but not directly by selecting Excel in the download prompt.
This behavior seems to be caused due to the file being downloaded having the MIME type of text/plain instead of text/csv.
I tried writing JS to download the file, but it seems like Retool does not allow this due to sandboxing.
Is there any way of specifying the MIME type of the file that will be downloaded, or is there any workaround for this?

#2

Hey puffpuddy, Unfortunately, there isn't a way to specify the MIME type of the file that will be downloaded when downloading a file from Retool and I'm not aware of a good way to work around this issue in Retool :slightly_frowning_face: I will pass along a report of this issue to engineering internally. I'm not able to provide a timeline of when we might have a fix for this issue at the moment but I'll notify you in this post of any updates. My suggested workaround would be what you've described; to Save the File and open it manually. I wish I had better news!