Copy a file or folder to a different location in the user's Dropbox. If the source path is a folder all its contents will be copied.
curl -X POST https://api.dropboxapi.com/2/files/copy_v2 \
--header "Authorization: Bearer DROPBOX-ACCESS-TOKEN" \
--header "Content-Type: application/json" \
--data "{\"from_path\": \"/ocean/starfish.jpg\",\"to_path\": \"/ocean/starfish2.jpg\",\"allow_shared_folder\": false,\"autorename\": false,\"allow_ownership_transfer\": false}"
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/copy_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, 'from_path', '/ocean/starfish.jpg'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'to_path', '/ocean/starfish2.jpg'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'allow_shared_folder', 0
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'autorename', 0
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'allow_ownership_transfer', 0
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/copy_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 @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 @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 @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 @metadataContent_hash nvarchar(4000)
EXEC sp_OAMethod @jsonResponse, 'StringOf', @metadataContent_hash OUT, 'metadata.content_hash'
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": "starfish2.jpg",
"path_lower": "/ocean/starfish2.jpg",
"path_display": "/ocean/starfish2.jpg",
"id": "id:JSXYsxHo1hAAAAAAAAAADg",
"client_modified": "2018-10-22T22:38:18Z",
"server_modified": "2018-10-22T22:40:38Z",
"rev": "1c482db15f",
"size": 6229,
"content_hash": "9fa9d692d0762ee759c22dea993c7de0068f9ba2ca842e761a1636d3b0b3cbba"
}
}