(VBScript) Download File from Dropbox

Downloads a file from Dropbox.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' 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.

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Rest")
set rest = CreateObject("Chilkat.Rest")

' Connect to Dropbox
success = rest.Connect("content.dropboxapi.com",443,1,1)
If (success <> 1) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

' Add request headers.
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",
' }

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.AppendString("path","/Homework/lit/hamlet.xml")
success = rest.AddHeader("Dropbox-API-Arg",json.Emit())

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.BinData")
set bd = CreateObject("Chilkat.BinData")
success = rest.FullRequestNoBodyBd("POST","/2/files/download",bd)
If (success = 0) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

' When successful, Dropbox responds with a 200 response code.
If (rest.ResponseStatusCode <> 200) Then
    ' Examine the request/response to see what happened.
    outFile.WriteLine("response status code = " & rest.ResponseStatusCode)
    outFile.WriteLine("response status text = " & rest.ResponseStatusText)
    outFile.WriteLine("response header: " & rest.ResponseHeader)
    outFile.WriteLine("response body (if any): " & bd.GetString("utf-8"))
    outFile.WriteLine("---")
    outFile.WriteLine("LastRequestStartLine: " & rest.LastRequestStartLine)
    outFile.WriteLine("LastRequestHeader: " & rest.LastRequestHeader)
    WScript.Quit
End If

' The file was downloaded into bd.
' Save it to the filesystem.
success = bd.WriteFile("c:/temp/qa_output/hamlet.xml")

' 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")
outFile.WriteLine(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...
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set jsonResult = CreateObject("Chilkat.JsonObject")
jsonResult.EmitCompact = 0
success = jsonResult.Load(apiResult)
' Show the JSON pretty-printed...
outFile.WriteLine(jsonResult.Emit())

' Sample code to get data from the JSON response:
size = jsonResult.IntOf("size")
outFile.WriteLine("size = " & size)

rev = jsonResult.StringOf("rev")
outFile.WriteLine("rev = " & rev)

clientModified = jsonResult.StringOf("client_modified")
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.CkDateTime")
set ckdt = CreateObject("Chilkat.CkDateTime")
success = ckdt.SetFromTimestamp(clientModified)
bLocalTime = 1
' dt is a Chilkat.DtObj
Set dt = ckdt.GetDtObj(bLocalTime)
outFile.WriteLine(dt.Day & "/" & dt.Month & "/" & dt.Year & " " & dt.Hour & ":" & dt.Minute)


outFile.Close