Create a folder. Creates the folder /Halloween/emojis
curl -X POST https://api.dropboxapi.com/2/files/create_folder_v2 \
--header "Authorization: Bearer DROPBOX-ACCESS-TOKEN" \
--header "Content-Type: application/json" \
--data "{\"path\": \"/Halloween/emojis\",\"autorename\": 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/create_folder_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', '/Halloween/emojis'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'autorename', 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/create_folder_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 @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 @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_infoTraverse_only int
EXEC sp_OAMethod @jsonResponse, 'BoolOf', @metadataSharing_infoTraverse_only OUT, 'metadata.sharing_info.traverse_only'
DECLARE @metadataSharing_infoNo_access int
EXEC sp_OAMethod @jsonResponse, 'BoolOf', @metadataSharing_infoNo_access OUT, 'metadata.sharing_info.no_access'
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": {
"name": "emojis",
"id": "id:a4ayc_80_OEAAAAAAAAAXz",
"path_lower": "/halloween/emojis",
"path_display": "/Halloween/emojis",
"sharing_info": {
"read_only": false,
"parent_shared_folder_id": "84528192421",
"traverse_only": false,
"no_access": false
},
"property_groups": [
{
"template_id": "ptid:1a5n2i6d3OYEAAAAAAAAAYa",
"fields": [
{
"name": "Security Policy",
"value": "Confidential"
}
]
}
]
}
}