Sample code for 30+ languages & platforms
SQL Server Requires Chilkat v11.7.0+

Box: Create a Project Folder, Upload, Tag, and Link a Document

See more Box Examples

Run the reusable setup once per HttpCurl object, then select names and execute the operation. The setup is repeated here only to make this published example independently runnable. Resolve the parent documents folder by name, create a new project folder, upload a document, apply pre-existing projectDocument metadata, and create a collaborators-only link. Creation outputs remain cached for subsequent operations; the engine resolves the enterprise scope only when metadata needs it. Multipart formatting and deliberate writes remain explicit.

See the Box API guide for setup and the complete workflow.

Chilkat SQL Server Downloads

SQL Server
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Requires Chilkat 11.7.0 or later and a previously unlocked Chilkat bundle.
    --  See Global Unlock Sample.
    --  Guide: Box API Guide.

    SELECT @success = 0

    --  BEGIN ONE-TIME SETUP
    --  This block is repeated so each published example can run on its own.
    --  In an application, run the setup example once and pass the SAME curl object
    --  to operation code below. Do not recreate it for every operation.
    --  See Reusable Box HttpCurl Setup.
    DECLARE @curl int
    EXEC @hr = sp_OACreate 'Chilkat.HttpCurl', @curl OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @curl, 'SetVar', NULL, 'access_token', 'BOX_ACCESS_TOKEN'
    EXEC sp_OAMethod @curl, 'SetVar', NULL, 'parent_name', '/'
    --  Box's fixed root ID is an implementation detail; callers supply names.
    EXEC sp_OAMethod @curl, 'SetVar', NULL, 'parent_id', '0'
    DECLARE @setupCommand int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @setupCommand OUT

    DECLARE @setupReplacements int

    --  Register findParent; registration sends no request.
    EXEC sp_OAMethod @setupCommand, 'SetString', @success OUT, 'curl -X GET "https://api.box.com/2.0/folders/0/items?limit=1000&fields=id,type,name" -H "Authorization: Bearer ACCESS_TOKEN"'
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @setupCommand, 'Replace', @setupReplacements OUT, 'ACCESS_TOKEN', @sTmp0
    EXEC sp_OAMethod @setupCommand, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @curl, 'AddFunction', @success OUT, 'findParent', @sTmp0
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END

    --  Register findFolder; registration sends no request.
    EXEC sp_OAMethod @setupCommand, 'SetString', @success OUT, 'curl -X GET "https://api.box.com/2.0/folders/{{parent_id}}/items?limit=1000&fields=id,type,name" -H "Authorization: Bearer ACCESS_TOKEN"'
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @setupCommand, 'Replace', @setupReplacements OUT, 'ACCESS_TOKEN', @sTmp0
    EXEC sp_OAMethod @setupCommand, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @curl, 'AddFunction', @success OUT, 'findFolder', @sTmp0
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END

    --  Register findFile; registration sends no request.
    EXEC sp_OAMethod @setupCommand, 'SetString', @success OUT, 'curl -X GET "https://api.box.com/2.0/folders/{{folder_id}}/items?limit=1000&fields=id,type,name" -H "Authorization: Bearer ACCESS_TOKEN"'
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @setupCommand, 'Replace', @setupReplacements OUT, 'ACCESS_TOKEN', @sTmp0
    EXEC sp_OAMethod @setupCommand, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @curl, 'AddFunction', @success OUT, 'findFile', @sTmp0
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END

    --  Register findDestination; registration sends no request.
    EXEC sp_OAMethod @setupCommand, 'SetString', @success OUT, 'curl -X GET "https://api.box.com/2.0/folders/0/items?limit=1000&fields=id,type,name" -H "Authorization: Bearer ACCESS_TOKEN"'
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @setupCommand, 'Replace', @setupReplacements OUT, 'ACCESS_TOKEN', @sTmp0
    EXEC sp_OAMethod @setupCommand, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @curl, 'AddFunction', @success OUT, 'findDestination', @sTmp0
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END

    --  Register getFileDetails; registration sends no request.
    EXEC sp_OAMethod @setupCommand, 'SetString', @success OUT, 'curl -X GET "https://api.box.com/2.0/files/{{file_id}}?fields=id,sha1,file_version" -H "Authorization: Bearer ACCESS_TOKEN"'
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @setupCommand, 'Replace', @setupReplacements OUT, 'ACCESS_TOKEN', @sTmp0
    EXEC sp_OAMethod @setupCommand, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @curl, 'AddFunction', @success OUT, 'getFileDetails', @sTmp0
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END

    --  Register getEnterprise; registration sends no request.
    EXEC sp_OAMethod @setupCommand, 'SetString', @success OUT, 'curl -X GET "https://api.box.com/2.0/users/me?fields=enterprise" -H "Authorization: Bearer ACCESS_TOKEN"'
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @setupCommand, 'Replace', @setupReplacements OUT, 'ACCESS_TOKEN', @sTmp0
    EXEC sp_OAMethod @setupCommand, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @curl, 'AddFunction', @success OUT, 'getEnterprise', @sTmp0
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END

    --  Register output rules once. Chilkat 11.7.0 evaluates {{name}} variables
    --  when extracting each output, using the current value at that time.
    EXEC sp_OAMethod @curl, 'AddOutput2', @success OUT, 'findParent', 'entries', 'name', '{{parent_name}}', 1, 'id', 'parent_id'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END
    EXEC sp_OAMethod @curl, 'AddOutput2', @success OUT, 'findFolder', 'entries', 'name', '{{folder_name}}', 1, 'id', 'folder_id'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END
    EXEC sp_OAMethod @curl, 'AddOutput2', @success OUT, 'findFile', 'entries', 'name', '{{file_name}}', 1, 'id', 'file_id'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END
    EXEC sp_OAMethod @curl, 'AddOutput2', @success OUT, 'findDestination', 'entries', 'name', '{{destination_name}}', 1, 'id', 'destination_id'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END
    EXEC sp_OAMethod @curl, 'AddOutput', @success OUT, 'getFileDetails', 'file_version.id', 'file_version_id'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END
    EXEC sp_OAMethod @curl, 'AddOutput', @success OUT, 'getFileDetails', 'sha1', 'file_sha1'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END
    EXEC sp_OAMethod @curl, 'AddOutput', @success OUT, 'getEnterprise', 'enterprise.id', 'enterprise_id'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @curl, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        RETURN
      END
    --  END ONE-TIME SETUP
    --  The name lookups below assume each listing fits in one page (1000 items).
    --  Parent and destination names select root children; folder_name selects a child
    --  of parent_name. "/" selects the root parent. These are not arbitrary paths.

    --  BEGIN OPERATION -- keep the configured object when reusing it.
    --  Inputs are names. Retain cached IDs when the selected names have not changed.
    DECLARE @parentName nvarchar(4000)
    SELECT @parentName = 'documents'
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'parent_name'
    EXEC sp_OAMethod @curl, 'VarDefined', @iTmp0 OUT, 'parent_id'
    IF (@sTmp0 <> @parentName) or ((@parentName = '/') and (@iTmp0 = 0))
      BEGIN
        EXEC sp_OAMethod @curl, 'SetVar', NULL, 'parent_name', @parentName
        EXEC sp_OAMethod @curl, 'ClearVar', NULL, 'parent_id'
        EXEC sp_OAMethod @curl, 'ClearVar', NULL, 'folder_id'
        EXEC sp_OAMethod @curl, 'ClearVar', NULL, 'file_id'
        EXEC sp_OAMethod @curl, 'ClearVar', NULL, 'file_version_id'
        EXEC sp_OAMethod @curl, 'ClearVar', NULL, 'file_sha1'
        IF @parentName = '/'
          BEGIN
            EXEC sp_OAMethod @curl, 'SetVar', NULL, 'parent_id', '0'
          END
      END
    EXEC sp_OAMethod @curl, 'SetVar', NULL, 'new_folder_name', 'Project CUST-1001'
    --  This workflow creates a new folder. A 409 stops the example; it does not
    --  silently reuse a same-named folder. Retain printed IDs if a later step fails.
    EXEC sp_OAMethod @curl, 'ClearTargetOutput', NULL, '*'
    EXEC sp_OAMethod @curl, 'ClearVar', NULL, 'folder_id'
    EXEC sp_OAMethod @curl, 'AddTargetOutput', NULL, 'id', 'folder_id'
    DECLARE @authorizedCommand1 int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @authorizedCommand1 OUT

    EXEC sp_OAMethod @authorizedCommand1, 'SetString', @success OUT, 'curl -X POST "https://api.box.com/2.0/folders" -H "Authorization: Bearer {{access_token}}" -H "Content-Type: application/json" -d ''{"name":"{{new_folder_name}}","parent":{"id":"{{parent_id}}"}}'''
    DECLARE @headerReplacement1 int
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @authorizedCommand1, 'Replace', @headerReplacement1 OUT, '{{access_token}}', @sTmp0
    EXEC sp_OAMethod @authorizedCommand1, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @curl, 'DoYourThing', @success OUT, @sTmp0
    EXEC sp_OAGetProperty @curl, 'StatusCode', @iTmp0 OUT
    IF (@success <> 1) or (@iTmp0 <> 201)
      BEGIN

        EXEC sp_OAGetProperty @curl, 'StatusCode', @iTmp0 OUT
        PRINT 'Box request failed. HTTP status: ' + @iTmp0

        EXEC sp_OAGetProperty @curl, 'FailReason', @iTmp0 OUT
        PRINT 'Failure reason: ' + @iTmp0
        EXEC sp_OAGetProperty @curl, 'ResponseBodyStr', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        EXEC @hr = sp_OADestroy @authorizedCommand1
        RETURN
      END
    EXEC sp_OAMethod @curl, 'VarDefined', @iTmp0 OUT, '!'
    IF @iTmp0 <> 1
      BEGIN

        PRINT 'Expected response fields are missing.'
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        EXEC @hr = sp_OADestroy @authorizedCommand1
        RETURN
      END

    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'folder_id'
    PRINT 'Created folder: ' + @sTmp0
    --  Resolve the multipart attributes field before passing the command to HttpCurl.
    --  Box folder IDs come from configuration or a previous API response.
    DECLARE @uploadCommand int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @uploadCommand OUT

    DECLARE @authorizedCommand2 int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @authorizedCommand2 OUT

    EXEC sp_OAMethod @authorizedCommand2, 'SetString', @success OUT, 'curl -X POST "https://upload.box.com/api/2.0/files/content" -H "Authorization: Bearer {{access_token}}" -F ''attributes={"name":"invoice.pdf","parent":{"id":"{{folder_id}}"}}'' -F "file=@qa_data/pdf/invoice.pdf;type=application/pdf"'
    DECLARE @headerReplacement2 int
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @authorizedCommand2, 'Replace', @headerReplacement2 OUT, '{{access_token}}', @sTmp0
    EXEC sp_OAMethod @authorizedCommand2, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @uploadCommand, 'SetString', @success OUT, @sTmp0
    DECLARE @replacements int
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'folder_id'
    EXEC sp_OAMethod @uploadCommand, 'Replace', @replacements OUT, '{{folder_id}}', @sTmp0
    EXEC sp_OAMethod @curl, 'ClearTargetOutput', NULL, '*'
    EXEC sp_OAMethod @curl, 'ClearVar', NULL, 'file_id'
    EXEC sp_OAMethod @curl, 'AddTargetOutput', NULL, 'entries[0].id', 'file_id'
    EXEC sp_OAMethod @uploadCommand, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @curl, 'DoYourThing', @success OUT, @sTmp0
    EXEC sp_OAGetProperty @curl, 'StatusCode', @iTmp0 OUT
    IF (@success <> 1) or (@iTmp0 <> 201)
      BEGIN

        EXEC sp_OAGetProperty @curl, 'StatusCode', @iTmp0 OUT
        PRINT 'Box request failed. HTTP status: ' + @iTmp0

        EXEC sp_OAGetProperty @curl, 'FailReason', @iTmp0 OUT
        PRINT 'Failure reason: ' + @iTmp0
        EXEC sp_OAGetProperty @curl, 'ResponseBodyStr', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        EXEC @hr = sp_OADestroy @authorizedCommand1
        EXEC @hr = sp_OADestroy @uploadCommand
        EXEC @hr = sp_OADestroy @authorizedCommand2
        RETURN
      END
    EXEC sp_OAMethod @curl, 'VarDefined', @iTmp0 OUT, '!'
    IF @iTmp0 <> 1
      BEGIN

        PRINT 'Expected response fields are missing.'
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        EXEC @hr = sp_OADestroy @authorizedCommand1
        EXEC @hr = sp_OADestroy @uploadCommand
        EXEC @hr = sp_OADestroy @authorizedCommand2
        RETURN
      END

    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'file_id'
    PRINT 'Uploaded file: ' + @sTmp0
    EXEC sp_OAMethod @curl, 'ClearTargetOutput', NULL, '*'
    DECLARE @authorizedCommand3 int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @authorizedCommand3 OUT

    EXEC sp_OAMethod @authorizedCommand3, 'SetString', @success OUT, 'curl -X POST "https://api.box.com/2.0/files/{{file_id}}/metadata/enterprise_{{enterprise_id}}/projectDocument" -H "Authorization: Bearer {{access_token}}" -H "Content-Type: application/json" -d ''{"customerId":"CUST-1001","status":"received"}'''
    DECLARE @headerReplacement3 int
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @authorizedCommand3, 'Replace', @headerReplacement3 OUT, '{{access_token}}', @sTmp0
    EXEC sp_OAMethod @authorizedCommand3, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @curl, 'DoYourThing', @success OUT, @sTmp0
    EXEC sp_OAGetProperty @curl, 'StatusCode', @iTmp0 OUT
    IF (@success <> 1) or (@iTmp0 <> 201)
      BEGIN

        EXEC sp_OAGetProperty @curl, 'StatusCode', @iTmp0 OUT
        PRINT 'Box request failed. HTTP status: ' + @iTmp0

        EXEC sp_OAGetProperty @curl, 'FailReason', @iTmp0 OUT
        PRINT 'Failure reason: ' + @iTmp0
        EXEC sp_OAGetProperty @curl, 'ResponseBodyStr', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        EXEC @hr = sp_OADestroy @authorizedCommand1
        EXEC @hr = sp_OADestroy @uploadCommand
        EXEC @hr = sp_OADestroy @authorizedCommand2
        EXEC @hr = sp_OADestroy @authorizedCommand3
        RETURN
      END
    EXEC sp_OAMethod @curl, 'ClearTargetOutput', NULL, '*'
    EXEC sp_OAMethod @curl, 'ClearVar', NULL, 'shared_url'
    EXEC sp_OAMethod @curl, 'AddTargetOutput', NULL, 'shared_link.url', 'shared_url'
    DECLARE @authorizedCommand4 int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @authorizedCommand4 OUT

    EXEC sp_OAMethod @authorizedCommand4, 'SetString', @success OUT, 'curl -X PUT "https://api.box.com/2.0/files/{{file_id}}?fields=id,shared_link" -H "Authorization: Bearer {{access_token}}" -H "Content-Type: application/json" -d ''{"shared_link":{"access":"collaborators"}}'''
    DECLARE @headerReplacement4 int
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @authorizedCommand4, 'Replace', @headerReplacement4 OUT, '{{access_token}}', @sTmp0
    EXEC sp_OAMethod @authorizedCommand4, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @curl, 'DoYourThing', @success OUT, @sTmp0
    EXEC sp_OAGetProperty @curl, 'StatusCode', @iTmp0 OUT
    IF (@success <> 1) or (@iTmp0 <> 200)
      BEGIN

        EXEC sp_OAGetProperty @curl, 'StatusCode', @iTmp0 OUT
        PRINT 'Box request failed. HTTP status: ' + @iTmp0

        EXEC sp_OAGetProperty @curl, 'FailReason', @iTmp0 OUT
        PRINT 'Failure reason: ' + @iTmp0
        EXEC sp_OAGetProperty @curl, 'ResponseBodyStr', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        EXEC @hr = sp_OADestroy @authorizedCommand1
        EXEC @hr = sp_OADestroy @uploadCommand
        EXEC @hr = sp_OADestroy @authorizedCommand2
        EXEC @hr = sp_OADestroy @authorizedCommand3
        EXEC @hr = sp_OADestroy @authorizedCommand4
        RETURN
      END
    EXEC sp_OAMethod @curl, 'VarDefined', @iTmp0 OUT, '!'
    IF @iTmp0 <> 1
      BEGIN

        PRINT 'Expected response fields are missing.'
        EXEC @hr = sp_OADestroy @curl
        EXEC @hr = sp_OADestroy @setupCommand
        EXEC @hr = sp_OADestroy @authorizedCommand1
        EXEC @hr = sp_OADestroy @uploadCommand
        EXEC @hr = sp_OADestroy @authorizedCommand2
        EXEC @hr = sp_OADestroy @authorizedCommand3
        EXEC @hr = sp_OADestroy @authorizedCommand4
        RETURN
      END

    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'shared_url'
    PRINT 'Document link: ' + @sTmp0
    --  The link is for existing collaborators. Invite users separately when needed.
    --  ClearTargetOutput removes old extraction rules; it does not clear existing IDs.
    EXEC sp_OAMethod @curl, 'GetVar', @sTmp0 OUT, 'new_folder_name'
    EXEC sp_OAMethod @curl, 'SetVar', NULL, 'folder_name', @sTmp0
    EXEC sp_OAMethod @curl, 'SetVar', NULL, 'file_name', 'invoice.pdf'
    EXEC sp_OAMethod @curl, 'ClearVar', NULL, 'file_version_id'
    EXEC sp_OAMethod @curl, 'ClearVar', NULL, 'file_sha1'

    EXEC @hr = sp_OADestroy @curl
    EXEC @hr = sp_OADestroy @setupCommand
    EXEC @hr = sp_OADestroy @authorizedCommand1
    EXEC @hr = sp_OADestroy @uploadCommand
    EXEC @hr = sp_OADestroy @authorizedCommand2
    EXEC @hr = sp_OADestroy @authorizedCommand3
    EXEC @hr = sp_OADestroy @authorizedCommand4


END
GO