(Excel) Download File from Dropbox

Downloads a file from Dropbox, streaming it directly to a file in the filesystem.

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' A Dropbox access token should have been previously obtained.
' Dropbox access tokens do not expire.
' See Dropbox Access Token.

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect to Dropbox

success = rest.Connect("content.dropboxapi.com",443,True,True)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Add request headers.
Dim success As Boolean
success = rest.AddHeader("Authorization","Bearer DROPBOX_ACCESS_TOKEN")

' The download "parameters" are contained in JSON passed in an HTTP request header.
' This is the JSON indicating the file to be downloaded:
' { 
'    "path": "/Homework/lit/hamlet.xml",
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.AppendString("path","/Homework/lit/hamlet.xml")
success = rest.AddHeader("Dropbox-API-Arg",json.Emit())

' Setup a file stream for the download
Dim fileStream As Chilkat.Stream
Set fileStream = Chilkat.NewStream
fileStream.SinkFile = "qa_output/hamletFromDropbox.xml"

' Indicate that the call to FullRequestNoBody should send the response body
' to fileStream if the response status code is 200.
' If a non-success response status code is received, then nothing
' is streamed to the output file and the error response is returned by FullRequestNoBody.

expectedStatus = 200
success = rest.SetResponseBodyStream(expectedStatus,True,fileStream)


responseStr = rest.FullRequestNoBody("POST","/2/files/download")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' When successful, Dropbox responds with a 200 response code.
If (rest.ResponseStatusCode <> 200) Then
    ' Examine the request/response to see what happened.
    Debug.Print "response status code = "; rest.ResponseStatusCode
    Debug.Print "response status text = "; rest.ResponseStatusText
    Debug.Print "response header: "; rest.ResponseHeader
    Debug.Print "response body (if any): "; responseStr
    Debug.Print "---"
    Debug.Print "LastRequestStartLine: "; rest.LastRequestStartLine
    Debug.Print "LastRequestHeader: "; rest.LastRequestHeader
    Exit Sub
End If

' Information about the downloaded file is also available as JSON in a response header.
' The "dropbox-api-result" response header contains the information.  For example:

apiResult = rest.ResponseHdrByName("dropbox-api-result")
Debug.Print apiResult

' In this case, the pretty-formatted dropbox-api-result JSON looks like this:
' { 
'   "name": "hamlet.xml",
'   "path_lower": "/homework/lit/hamlet.xml",
'   "path_display": "/Homework/lit/hamlet.xml",
'   "id": "id:74FkdeNuyKAAAAAAAAAAAQ",
'   "client_modified": "2016-06-02T23:19:00Z",
'   "server_modified": "2016-06-02T23:19:00Z",
'   "rev": "9482db15f",
'   "size": 279658
' }

' Load the JSON, pretty-print it, and demonstrate how to get some values...
Dim jsonResult As Chilkat.JsonObject
Set jsonResult = Chilkat.NewJsonObject
jsonResult.EmitCompact = False
success = jsonResult.Load(apiResult)
' Show the JSON pretty-printed...
Debug.Print jsonResult.Emit()

' Sample code to get data from the JSON response:

size = jsonResult.IntOf("size")
Debug.Print "size = "; size


rev = jsonResult.StringOf("rev")
Debug.Print "rev = "; rev


clientModified = jsonResult.StringOf("client_modified")
Dim ckdt As Chilkat.CkDateTime
Set ckdt = Chilkat.NewCkDateTime
success = ckdt.SetFromTimestamp(clientModified)

bLocalTime = True

Set dt = ckdt.GetDtObj(bLocalTime)
Debug.Print dt.Day; "/"; dt.Month; "/"; dt.Year; " "; dt.Hour; ":"; dt.Minute