(Excel) Create a Temporary Public Link to a DropBox File

Get a temporary link to stream content of a file. This link will expire in four hours and afterwards you will get 410 Gone.

For more information, see https://www.dropbox.com/developers/documentation/http/documentation#files-get_temporary_link

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Implements the following CURL command:

' curl -X POST https://api.dropboxapi.com/2/files/get_temporary_link \
'     --header "Authorization: Bearer DROPBOX_ACCESS_TOKEN" \
'     --header "Content-Type: application/json" \
'     --data "{\"path\": \"/video.mp4\"}"

' Use this online tool to generate code from sample JSON:
' Generate Code to Create JSON

' The following JSON is sent in the request body.

' {
'   "path": "/video.mp4"
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.UpdateString("path","/video.mp4")

http.SetRequestHeader "Authorization","Bearer DROPBOX_ACCESS_TOKEN"
http.SetRequestHeader "Content-Type","application/json"


Set resp = http.PostJson3("https://api.dropboxapi.com/2/files/get_temporary_link","application/json",json)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = resp.GetBodySb(sbResponseBody)
Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.Print "Response Body:"
Debug.Print jResp.Emit()


respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "metadata": {
'     "name": "Prime_Numbers.txt",
'     "id": "id:a4ayc_80_OEAAAAAAAAAXw",
'     "client_modified": "2015-05-12T15:50:38Z",
'     "server_modified": "2015-05-12T15:50:38Z",
'     "rev": "a1c10ce0dd78",
'     "size": 7212,
'     "path_lower": "/homework/math/prime_numbers.txt",
'     "path_display": "/Homework/math/Prime_Numbers.txt",
'     "sharing_info": {
'       "read_only": true,
'       "parent_shared_folder_id": "84528192421",
'       "modified_by": "dbid:AAH4f99T0taONIb-OurWxbNQ6ywGRopQngc"
'     },
'     "is_downloadable": true,
'     "property_groups": [
'       {
'         "template_id": "ptid:1a5n2i6d3OYEAAAAAAAAAYa",
'         "fields": [
'           {
'             "name": "Security Policy",
'             "value": "Confidential"
'           }
'         ]
'       }
'     ],
'     "has_explicit_shared_members": false,
'     "content_hash": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"
'   },
'   "link": "https://dl.dropboxusercontent.com/apitl/1/YXNkZmFzZGcyMzQyMzI0NjU2NDU2NDU2"
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON


metadataName = jResp.StringOf("metadata.name")

metadataId = jResp.StringOf("metadata.id")

metadataClient_modified = jResp.StringOf("metadata.client_modified")

metadataServer_modified = jResp.StringOf("metadata.server_modified")

metadataRev = jResp.StringOf("metadata.rev")

metadataSize = jResp.IntOf("metadata.size")

metadataPath_lower = jResp.StringOf("metadata.path_lower")

metadataPath_display = jResp.StringOf("metadata.path_display")

metadataSharing_infoRead_only = jResp.BoolOf("metadata.sharing_info.read_only")

metadataSharing_infoParent_shared_folder_id = jResp.StringOf("metadata.sharing_info.parent_shared_folder_id")

metadataSharing_infoModified_by = jResp.StringOf("metadata.sharing_info.modified_by")

metadataIs_downloadable = jResp.BoolOf("metadata.is_downloadable")

metadataHas_explicit_shared_members = jResp.BoolOf("metadata.has_explicit_shared_members")

metadataContent_hash = jResp.StringOf("metadata.content_hash")

link = jResp.StringOf("link")

i = 0

count_i = jResp.SizeOfArray("metadata.property_groups")
Do While i < count_i
    jResp.I = i
    template_id = jResp.StringOf("metadata.property_groups[i].template_id")
    j = 0
    count_j = jResp.SizeOfArray("metadata.property_groups[i].fields")
    Do While j < count_j
        jResp.J = j
        name = jResp.StringOf("metadata.property_groups[i].fields[j].name")
        value = jResp.StringOf("metadata.property_groups[i].fields[j].value")
        j = j + 1
    Loop
    i = i + 1
Loop