(Excel) Upload String to Dropbox

Uploads a string to a file on Dropbox. This example can upload content up to 150MB, assuming a 150MB string fits in memory for your app. Larger files must be uploaded with an upload session (upload_session/start).

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("Content-Type","application/octet-stream")
success = rest.AddHeader("Authorization","Bearer DROPBOX_ACCESS_TOKEN")

' The upload "parameters" contained in JSON passed in an HTTP request header.
' This is the JSON to be added in this example:
' { 
'    "path": "/jack.txt",
'    "mode": "add",
'    "autorename": true,
'    "mute": false
' }

' This will be the content of the file created in Dropbox.

content = "All work and no play makes Jack a dull boy"

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.AppendString("path","/jack.txt")
success = json.AppendString("mode","add")
success = json.AppendBool("autorename",True)
success = json.AppendBool("mute",False)
success = rest.AddHeader("Dropbox-API-Arg",json.Emit())

' Do the upload.  The URL is https://content.dropboxapi.com/2/files/upload.
' We already connected to content.dropboxapi.com using TLS (i.e. HTTPS),
' so now we only need to specify the path "/2/files/upload".


responseStr = rest.FullRequestString("POST","/2/files/upload",content)
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

Debug.Print "LastRequestHeader: "; rest.LastRequestHeader

' The response is JSON.
Dim jsonResp As Chilkat.JsonObject
Set jsonResp = Chilkat.NewJsonObject
jsonResp.EmitCompact = False
success = jsonResp.Load(responseStr)

' Show the JSON response.
Debug.Print jsonResp.Emit()

' Returns JSON that looks like this:
' { 
'  "name": "jack.txt",
'  "path_lower": "/jack.txt",
'  "path_display": "/jack.txt",
'  "id": "id:yqx4-tE_NKAAAAAAAAAAAQ",
'  "client_modified": "2016-06-02T20:42:11Z",
'  "server_modified": "2016-06-02T20:42:11Z",
'  "rev": "8482db15f",
'  "size": 42
' }

' Sample code to get data from the JSON response:

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


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


clientModified = jsonResp.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