Deletes a file on Dropbox
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\"}"CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
DECLARE @sTmp0 nvarchar(4000)
DECLARE @rest int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Rest', @rest OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
-- URL: https://api.dropboxapi.com/2/files/delete_v2
DECLARE @bTls int
SELECT @bTls = 1
DECLARE @port int
SELECT @port = 443
DECLARE @bAutoReconnect int
SELECT @bAutoReconnect = 1
EXEC sp_OAMethod @rest, 'Connect', @success OUT, 'api.dropboxapi.com', @port, @bTls, @bAutoReconnect
IF @success <> 1
BEGIN
EXEC sp_OAGetProperty @rest, 'ConnectFailReason', @iTmp0 OUT
PRINT 'ConnectFailReason: ' + @iTmp0
EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @rest
RETURN
END
-- See the Online Tool for Generating JSON Creation Code
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'path', '/Homework/math/Prime_Numbers.txt'
EXEC sp_OAMethod @rest, 'AddHeader', @success OUT, 'Authorization', 'Bearer DROPBOX-ACCESS-TOKEN'
EXEC sp_OAMethod @rest, 'AddHeader', @success OUT, 'Content-Type', 'application/json'
DECLARE @sbRequestBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbRequestBody OUT
EXEC sp_OAMethod @json, 'EmitSb', @success OUT, @sbRequestBody
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @rest, 'FullRequestSb', @success OUT, 'POST', '/2/files/delete_v2', @sbRequestBody, @sbResponseBody
IF @success <> 1
BEGIN
EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbRequestBody
EXEC @hr = sp_OADestroy @sbResponseBody
RETURN
END
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @rest, 'ResponseStatusCode', @respStatusCode OUT
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Status Code = ' + @respStatusCode
PRINT 'Response Header:'
EXEC sp_OAGetProperty @rest, 'ResponseHeader', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Response Body:'
EXEC sp_OAMethod @sbResponseBody, 'GetAsString', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbRequestBody
EXEC @hr = sp_OADestroy @sbResponseBody
RETURN
END
DECLARE @jsonResponse int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @jsonResponse OUT
EXEC sp_OAMethod @jsonResponse, 'LoadSb', @success OUT, @sbResponseBody
-- See the Online Tool for Generating JSON Parse Code
DECLARE @i int
DECLARE @count_i int
DECLARE @j int
DECLARE @count_j int
DECLARE @metadataTag nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataTag OUT, 'metadata.".tag"'
DECLARE @metadataName nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataName OUT, 'metadata.name'
DECLARE @metadataId nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataId OUT, 'metadata.id'
DECLARE @metadataClient_modified nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataClient_modified OUT, 'metadata.client_modified'
DECLARE @metadataServer_modified nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataServer_modified OUT, 'metadata.server_modified'
DECLARE @metadataRev nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataRev OUT, 'metadata.rev'
DECLARE @metadataSize int
EXEC sp_OAMethod @jsonResponse, 'IntOf', @metadataSize OUT, 'metadata.size'
DECLARE @metadataPath_lower nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataPath_lower OUT, 'metadata.path_lower'
DECLARE @metadataPath_display nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataPath_display OUT, 'metadata.path_display'
DECLARE @metadataSharing_infoRead_only int
EXEC sp_OAMethod @jsonResponse, 'BoolOf', @metadataSharing_infoRead_only OUT, 'metadata.sharing_info.read_only'
DECLARE @metadataSharing_infoParent_shared_folder_id nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataSharing_infoParent_shared_folder_id OUT, 'metadata.sharing_info.parent_shared_folder_id'
DECLARE @metadataSharing_infoModified_by nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataSharing_infoModified_by OUT, 'metadata.sharing_info.modified_by'
DECLARE @metadataHas_explicit_shared_members int
EXEC sp_OAMethod @jsonResponse, 'BoolOf', @metadataHas_explicit_shared_members OUT, 'metadata.has_explicit_shared_members'
DECLARE @metadataContent_hash nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataContent_hash OUT, 'metadata.content_hash'
SELECT @i = 0
EXEC sp_OAMethod @jsonResponse, 'SizeOfArray', @count_i OUT, 'metadata.property_groups'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jsonResponse, 'I', @i
DECLARE @template_id nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @template_id OUT, 'metadata.property_groups[i].template_id'
SELECT @j = 0
EXEC sp_OAMethod @jsonResponse, 'SizeOfArray', @count_j OUT, 'metadata.property_groups[i].fields'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jsonResponse, 'J', @j
DECLARE @name nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @name OUT, 'metadata.property_groups[i].fields[j].name'
DECLARE @value nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @value OUT, 'metadata.property_groups[i].fields[j].value'
SELECT @j = @j + 1
END
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbRequestBody
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jsonResponse
END
GO
{
"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"
}
}