Visual FoxPro Dropbox: Dropbox Delete a File

Back to Index

Deletes a file on Dropbox

Documentation: https://www.dropbox.com/developers/documentation/http/documentation#files-delete

CURL Command

curl -X POST https://api.dropboxapi.com/2/files/delete_v2 \
    --header "Authorization: Bearer DROPBOX-ACCESS-TOKEN" \
    --header "Content-Type: application/json" \
    --data "{\"path\": \"/Homework/math/Prime_Numbers.txt\"}"

Visual FoxPro Example

LOCAL loRest
LOCAL lnSuccess
LOCAL lnBTls
LOCAL lnPort
LOCAL lnBAutoReconnect
LOCAL loJson
LOCAL loSbRequestBody
LOCAL loSbResponseBody
LOCAL lnRespStatusCode
LOCAL loJsonResponse
LOCAL i
LOCAL lnCount_i
LOCAL j
LOCAL lnCount_j
LOCAL lcMetadataTag
LOCAL lcMetadataName
LOCAL lcMetadataId
LOCAL lcMetadataClient_modified
LOCAL lcMetadataServer_modified
LOCAL lcMetadataRev
LOCAL lnMetadataSize
LOCAL lcMetadataPath_lower
LOCAL lcMetadataPath_display
LOCAL lnMetadataSharing_infoRead_only
LOCAL lcMetadataSharing_infoParent_shared_folder_id
LOCAL lcMetadataSharing_infoModified_by
LOCAL lnMetadataHas_explicit_shared_members
LOCAL lcMetadataContent_hash
LOCAL lcTemplate_id
LOCAL lcName
LOCAL lcValue

loRest = CreateObject('Chilkat_9_5_0.Rest')

*  URL: https://api.dropboxapi.com/2/files/delete_v2
lnBTls = 1
lnPort = 443
lnBAutoReconnect = 1
lnSuccess = loRest.Connect("api.dropboxapi.com",lnPort,lnBTls,lnBAutoReconnect)
IF (lnSuccess <> 1) THEN
    ? "ConnectFailReason: " + STR(loRest.ConnectFailReason)
    ? loRest.LastErrorText
    RELEASE loRest
    CANCEL
ENDIF

*  See the Online Tool for Generating JSON Creation Code
loJson = CreateObject('Chilkat_9_5_0.JsonObject')
loJson.UpdateString("path","/Homework/math/Prime_Numbers.txt")

loRest.AddHeader("Authorization","Bearer DROPBOX-ACCESS-TOKEN")
loRest.AddHeader("Content-Type","application/json")

loSbRequestBody = CreateObject('Chilkat_9_5_0.StringBuilder')
loJson.EmitSb(loSbRequestBody)
loSbResponseBody = CreateObject('Chilkat_9_5_0.StringBuilder')
lnSuccess = loRest.FullRequestSb("POST","/2/files/delete_v2",loSbRequestBody,loSbResponseBody)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loRest
    RELEASE loJson
    RELEASE loSbRequestBody
    RELEASE loSbResponseBody
    CANCEL
ENDIF

lnRespStatusCode = loRest.ResponseStatusCode
IF (lnRespStatusCode >= 400) THEN
    ? "Response Status Code = " + STR(lnRespStatusCode)
    ? "Response Header:"
    ? loRest.ResponseHeader
    ? "Response Body:"
    ? loSbResponseBody.GetAsString()
    RELEASE loRest
    RELEASE loJson
    RELEASE loSbRequestBody
    RELEASE loSbResponseBody
    CANCEL
ENDIF

loJsonResponse = CreateObject('Chilkat_9_5_0.JsonObject')
loJsonResponse.LoadSb(loSbResponseBody)

*  See the Online Tool for Generating JSON Parse Code

lcMetadataTag = loJsonResponse.StringOf('metadata.".tag"')
lcMetadataName = loJsonResponse.StringOf("metadata.name")
lcMetadataId = loJsonResponse.StringOf("metadata.id")
lcMetadataClient_modified = loJsonResponse.StringOf("metadata.client_modified")
lcMetadataServer_modified = loJsonResponse.StringOf("metadata.server_modified")
lcMetadataRev = loJsonResponse.StringOf("metadata.rev")
lnMetadataSize = loJsonResponse.IntOf("metadata.size")
lcMetadataPath_lower = loJsonResponse.StringOf("metadata.path_lower")
lcMetadataPath_display = loJsonResponse.StringOf("metadata.path_display")
lnMetadataSharing_infoRead_only = loJsonResponse.BoolOf("metadata.sharing_info.read_only")
lcMetadataSharing_infoParent_shared_folder_id = loJsonResponse.StringOf("metadata.sharing_info.parent_shared_folder_id")
lcMetadataSharing_infoModified_by = loJsonResponse.StringOf("metadata.sharing_info.modified_by")
lnMetadataHas_explicit_shared_members = loJsonResponse.BoolOf("metadata.has_explicit_shared_members")
lcMetadataContent_hash = loJsonResponse.StringOf("metadata.content_hash")
i = 0
lnCount_i = loJsonResponse.SizeOfArray("metadata.property_groups")
DO WHILE i < lnCount_i
    loJsonResponse.I = i
    lcTemplate_id = loJsonResponse.StringOf("metadata.property_groups[i].template_id")
    j = 0
    lnCount_j = loJsonResponse.SizeOfArray("metadata.property_groups[i].fields")
    DO WHILE j < lnCount_j
        loJsonResponse.J = j
        lcName = loJsonResponse.StringOf("metadata.property_groups[i].fields[j].name")
        lcValue = loJsonResponse.StringOf("metadata.property_groups[i].fields[j].value")
        j = j + 1
    ENDDO
    i = i + 1
ENDDO

RELEASE loRest
RELEASE loJson
RELEASE loSbRequestBody
RELEASE loSbResponseBody
RELEASE loJsonResponse

Sample JSON Response Body

{
  "metadata": {
    ".tag": "file",
    "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"
    },
    "property_groups": [
      {
        "template_id": "ptid:1a5n2i6d3OYEAAAAAAAAAYa",
        "fields": [
          {
            "name": "Security Policy",
            "value": "Confidential"
          }
        ]
      }
    ],
    "has_explicit_shared_members": false,
    "content_hash": "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855"
  }
}