PowerBuilder

Download File from Dropbox into a String Variable

See more Dropbox Examples

Demonstrates how to download a file from Dropbox directly into a string variable. PowerBuilder

integer li_rc
integer li_Success
oleobject loo_Rest
oleobject loo_Json
string ls_FileContent
string ls_ApiResult
oleobject loo_JsonResult
integer li_Size
string ls_Rev
string ls_ClientModified
oleobject loo_Ckdt
integer li_BLocalTime
oleobject loo_Dt

li_Success = 0

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

loo_Rest = create oleobject
li_rc = loo_Rest.ConnectToNewObject("Chilkat.Rest")
if li_rc < 0 then
    destroy loo_Rest
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// Connect to Dropbox
li_Success = loo_Rest.Connect("content.dropboxapi.com",443,1,1)
if li_Success = 0 then
    Write-Debug loo_Rest.LastErrorText
    destroy loo_Rest
    return
end if

// Add request headers.
loo_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": "/jack.txt",
// }

loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.AppendString("path","/jack.txt")
loo_Rest.AddHeader("Dropbox-API-Arg",loo_Json.Emit())

// The content of the file on Dropbox is returned.
ls_FileContent = loo_Rest.FullRequestNoBody("POST","/2/files/download")
if loo_Rest.LastMethodSuccess = 0 then
    Write-Debug loo_Rest.LastErrorText
    destroy loo_Rest
    destroy loo_Json
    return
end if

// When successful, Dropbox responds with a 200 response code.
if loo_Rest.ResponseStatusCode <> 200 then
    // Examine the request/response to see what happened.
    Write-Debug "response status code = " + string(loo_Rest.ResponseStatusCode)
    Write-Debug "response status text = " + loo_Rest.ResponseStatusText
    Write-Debug "response header: " + loo_Rest.ResponseHeader
    Write-Debug "response body (if any): " + ls_FileContent
    Write-Debug "---"
    Write-Debug "LastRequestStartLine: " + loo_Rest.LastRequestStartLine
    Write-Debug "LastRequestHeader: " + loo_Rest.LastRequestHeader
    destroy loo_Rest
    destroy loo_Json
    return
end if

// Show the file content that was downloaded:
Write-Debug ls_FileContent
Write-Debug "----"

// 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:
ls_ApiResult = loo_Rest.ResponseHdrByName("dropbox-api-result")
Write-Debug ls_ApiResult

// In this case, the pretty-formatted dropbox-api-result JSON 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
// }

// Load the JSON, pretty-print it, and demonstrate how to get some values...
loo_JsonResult = create oleobject
li_rc = loo_JsonResult.ConnectToNewObject("Chilkat.JsonObject")

loo_JsonResult.EmitCompact = 0
loo_JsonResult.Load(ls_ApiResult)
// Show the JSON pretty-printed...
Write-Debug loo_JsonResult.Emit()

// Sample code to get data from the JSON response:
li_Size = loo_JsonResult.IntOf("size")
Write-Debug "size = " + string(li_Size)

ls_Rev = loo_JsonResult.StringOf("rev")
Write-Debug "rev = " + ls_Rev

ls_ClientModified = loo_JsonResult.StringOf("client_modified")
loo_Ckdt = create oleobject
li_rc = loo_Ckdt.ConnectToNewObject("Chilkat.CkDateTime")

loo_Ckdt.SetFromTimestamp(ls_ClientModified)
li_BLocalTime = 1
loo_Dt = create oleobject
li_rc = loo_Dt.ConnectToNewObject("Chilkat.DtObj")

loo_Ckdt.ToDtObj(li_BLocalTime,loo_Dt)

Write-Debug string(loo_Dt.Day) + "/" + string(loo_Dt.Month) + "/" + string(loo_Dt.Year) + " " + string(loo_Dt.Hour) + ":" + string(loo_Dt.Minute)


destroy loo_Rest
destroy loo_Json
destroy loo_JsonResult
destroy loo_Ckdt
destroy loo_Dt