You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.
Forum Discussion
Download file with VBA
Hi
I'm a DB beginner and have to use VBA from Excel
I'm using, in between others:
Set xmlhttp = CreateObject("WinHttp.WinHttpRequest.5.1")
myURL = "https://content.dropboxapi.com/2/files/download"
xmlhttp.SetRequestHeader "Dropbox-API-Arg", argumentString
xmlhttp.send ""
and it all seems to go well and with
xmlhttp.ResponseText
I get a bunch of unreadable text which I believe is the file content
But I don't get the file
what should be the last statament to actually download it to my PC?
thank you
Riccardo
The /2/files/download endpoint is a "content-download" style endpoint, meaning that when the call is successful, the requested file data is returned in the response body.
It sounds like that is what you're seeing. That is, the text you're reading out is the raw file data. What you do with that data is up to you.
For instance, in this case, it sounds like you want to save that file data to the local file system. Dropbox can't offer support for interacting with the local filesystem in VBA, as that's not made by Dropbox, but it looks like you may want to use FileSystemObject.
- Greg-DB
Dropbox Staff
The /2/files/download endpoint is a "content-download" style endpoint, meaning that when the call is successful, the requested file data is returned in the response body.
It sounds like that is what you're seeing. That is, the text you're reading out is the raw file data. What you do with that data is up to you.
For instance, in this case, it sounds like you want to save that file data to the local file system. Dropbox can't offer support for interacting with the local filesystem in VBA, as that's not made by Dropbox, but it looks like you may want to use FileSystemObject.
Hi Greg
thanks for your prompt and clear feedback
I get what you mean and I'm going to dig into it
I have another question but I'll start a new thread
Riccardo
About Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.
