Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(SQL Server) DocuSign List FoldersSee more DocuSign ExamplesRetrieves a list of the folders for the account, including the folder hierarchy. You can specify type kinds of folders to return with the include query parameter. For more information, see https://developers.docusign.com/docs/esign-rest-api/reference/folders/folders/list/
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls. -- CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int -- Important: Do not use nvarchar(max). See the warning about using nvarchar(max). DECLARE @sTmp0 nvarchar(4000) -- This example assumes the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. DECLARE @http int -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END DECLARE @success int -- Implements the following HTTP request: -- GET /restapi/v2.1/accounts/{accountId}/folders -- Adds the "Authorization: Bearer eyJ0eXAi.....UE8Kl_V8KroQ" header. DECLARE @jsonToken int -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jsonToken OUT -- Load a previously obtained OAuth2 access token. EXEC sp_OAMethod @jsonToken, 'LoadFile', @success OUT, 'qa_data/tokens/docusign.json' IF @success = 0 BEGIN EXEC sp_OAGetProperty @jsonToken, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @jsonToken RETURN END EXEC sp_OAMethod @jsonToken, 'StringOf', @sTmp0 OUT, 'access_token' EXEC sp_OASetProperty @http, 'AuthToken', @sTmp0 -- Use your account ID here: EXEC sp_OAMethod @http, 'SetUrlVar', @success OUT, 'accountId', '7f3f65ed-5e87-418d-94c1-92499ddc8252' DECLARE @sbResponseBody int -- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT EXEC sp_OAMethod @http, 'QuickGetSb', @success OUT, 'https://demo.docusign.net/restapi/v2.1/accounts/{$accountId}/folders', @sbResponseBody IF @success = 0 BEGIN EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @jsonToken EXEC @hr = sp_OADestroy @sbResponseBody RETURN END DECLARE @jResp int -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jResp OUT EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody EXEC sp_OASetProperty @jResp, 'EmitCompact', 0 PRINT 'Response Body:' EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT PRINT @sTmp0 DECLARE @respStatusCode int EXEC sp_OAGetProperty @http, 'LastStatus', @respStatusCode OUT PRINT 'Response Status Code = ' + @respStatusCode IF @respStatusCode >= 400 BEGIN PRINT 'Response Header:' EXEC sp_OAGetProperty @http, 'LastHeader', @sTmp0 OUT PRINT @sTmp0 PRINT 'Failed.' EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @jsonToken EXEC @hr = sp_OADestroy @sbResponseBody EXEC @hr = sp_OADestroy @jResp RETURN END -- Sample JSON response: -- (Sample code for parsing the JSON response is shown below) -- { -- "resultSetSize": "4", -- "startPosition": "0", -- "endPosition": "3", -- "totalSetSize": "4", -- "folders": [ -- { -- "name": "Draft", -- "type": "draft", -- "owner": { -- "userName": "Joe Sample", -- "userId": "14602117-2430-4582-8a49-ba8766302272", -- "email": "admin@chilkatsoft.com" -- }, -- "folderId": "f0bc5174-610d-4d80-80d7-91037843ccdb", -- "uri": "/folders/f0bc5174-610d-4d80-80d7-91037843ccdb", -- "itemCount": "0", -- "subFolderCount": "0", -- "hasSubFolders": "false" -- }, -- { -- "name": "Inbox", -- "type": "inbox", -- "owner": { -- "userName": "Joe Sample", -- "userId": "14602117-2430-4582-8a49-ba8766302272", -- "email": "admin@chilkatsoft.com" -- }, -- "folderId": "06c97346-f7b4-46fd-a204-038287d655ec", -- "uri": "/folders/06c97346-f7b4-46fd-a204-038287d655ec", -- "itemCount": "1", -- "subFolderCount": "0", -- "hasSubFolders": "false" -- }, -- { -- "name": "Deleted Items", -- "type": "recyclebin", -- "owner": { -- "userName": "Joe Sample", -- "userId": "14602117-2430-4582-8a49-ba8766302272", -- "email": "admin@chilkatsoft.com" -- }, -- "folderId": "6df0919e-b152-49fc-a4c9-9b430a29d4f5", -- "uri": "/folders/6df0919e-b152-49fc-a4c9-9b430a29d4f5", -- "itemCount": "0", -- "subFolderCount": "0", -- "hasSubFolders": "false" -- }, -- { -- "name": "Sent Items", -- "type": "sentitems", -- "owner": { -- "userName": "Joe Sample", -- "userId": "14602117-2430-4582-8a49-ba8766302272", -- "email": "admin@chilkatsoft.com" -- }, -- "folderId": "456f3c76-b265-4453-a024-c39b1a5cb387", -- "uri": "/folders/456f3c76-b265-4453-a024-c39b1a5cb387", -- "itemCount": "1", -- "subFolderCount": "0", -- "hasSubFolders": "false" -- } -- ] -- } -- Sample code for parsing the JSON response... -- Use the following online tool to generate parsing code from sample JSON: -- Generate Parsing Code from JSON DECLARE @name nvarchar(4000) DECLARE @v_type nvarchar(4000) DECLARE @ownerUserName nvarchar(4000) DECLARE @ownerUserId nvarchar(4000) DECLARE @ownerEmail nvarchar(4000) DECLARE @folderId nvarchar(4000) DECLARE @uri nvarchar(4000) DECLARE @itemCount nvarchar(4000) DECLARE @subFolderCount nvarchar(4000) DECLARE @hasSubFolders nvarchar(4000) DECLARE @resultSetSize nvarchar(4000) EXEC sp_OAMethod @jResp, 'StringOf', @resultSetSize OUT, 'resultSetSize' DECLARE @startPosition nvarchar(4000) EXEC sp_OAMethod @jResp, 'StringOf', @startPosition OUT, 'startPosition' DECLARE @endPosition nvarchar(4000) EXEC sp_OAMethod @jResp, 'StringOf', @endPosition OUT, 'endPosition' DECLARE @totalSetSize nvarchar(4000) EXEC sp_OAMethod @jResp, 'StringOf', @totalSetSize OUT, 'totalSetSize' DECLARE @i int SELECT @i = 0 DECLARE @count_i int EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'folders' WHILE @i < @count_i BEGIN EXEC sp_OASetProperty @jResp, 'I', @i EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'folders[i].name' EXEC sp_OAMethod @jResp, 'StringOf', @v_type OUT, 'folders[i].type' EXEC sp_OAMethod @jResp, 'StringOf', @ownerUserName OUT, 'folders[i].owner.userName' EXEC sp_OAMethod @jResp, 'StringOf', @ownerUserId OUT, 'folders[i].owner.userId' EXEC sp_OAMethod @jResp, 'StringOf', @ownerEmail OUT, 'folders[i].owner.email' EXEC sp_OAMethod @jResp, 'StringOf', @folderId OUT, 'folders[i].folderId' EXEC sp_OAMethod @jResp, 'StringOf', @uri OUT, 'folders[i].uri' EXEC sp_OAMethod @jResp, 'StringOf', @itemCount OUT, 'folders[i].itemCount' EXEC sp_OAMethod @jResp, 'StringOf', @subFolderCount OUT, 'folders[i].subFolderCount' EXEC sp_OAMethod @jResp, 'StringOf', @hasSubFolders OUT, 'folders[i].hasSubFolders' SELECT @i = @i + 1 END EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @jsonToken EXEC @hr = sp_OADestroy @sbResponseBody EXEC @hr = sp_OADestroy @jResp END GO |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.