SQL Server
SQL Server
Send DocuSign XML Request
See more HTTP Misc Examples
Demonstrates how to send a DocuSign XML request.Chilkat SQL Server Downloads
-- 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
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
DECLARE @success int
SELECT @success = 0
-- This requires the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @req int
EXEC @hr = sp_OACreate 'Chilkat.HttpRequest', @req OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
EXEC sp_OASetProperty @req, 'HttpVerb', 'POST'
-- Replace "12999999" with your own account number. (12999999 is a ficticious account number)
EXEC sp_OASetProperty @req, 'Path', '/restapi/v2/accounts/12999999/envelopes'
EXEC sp_OAMethod @req, 'AddHeader', NULL, 'Accept', 'application/xml'
-- Don't worry about the boundary string. Chilkat will automatically generate one and include it.
EXEC sp_OASetProperty @req, 'ContentType', 'multipart/form-data'
DECLARE @xmlCred int
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xmlCred OUT
EXEC sp_OASetProperty @xmlCred, 'Tag', 'DocuSignCredentials'
EXEC sp_OAMethod @xmlCred, 'UpdateChildContent', NULL, 'Username', 'YOUR_DOCUSIGN_USERNAME'
EXEC sp_OAMethod @xmlCred, 'UpdateChildContent', NULL, 'Password', 'YOUR_DOCUSIGN_PASSWORD'
EXEC sp_OAMethod @xmlCred, 'UpdateChildContent', NULL, 'IntegratorKey', 'ABCD-12345678-1234-AAAA-BBBB-abcdabcdabcd'
EXEC sp_OASetProperty @xmlCred, 'EmitXmlDecl', 0
EXEC sp_OASetProperty @xmlCred, 'EmitCompact', 1
EXEC sp_OAMethod @xmlCred, 'GetXml', @sTmp0 OUT
EXEC sp_OAMethod @req, 'AddHeader', NULL, 'X-DocuSign-Authentication', @sTmp0
-- Don't worry about Host or Content-Length headers, Chilkat automatically adds them...
-- Build the XML for the 1st body part..
DECLARE @xml int
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT
EXEC sp_OASetProperty @xml, 'Tag', 'envelopeDefinition'
EXEC sp_OAMethod @xml, 'AddAttribute', @success OUT, 'xmlns', 'http://www.docusign.com/restapi'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'emailSubject', 'Signature Request: Test Test:001019:033611'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'status', 'sent'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|documentId', '1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|name', '001019_TestTest_RetailDeals_163357'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|hostEmail', 'admin@chilkatsoft.com'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|hostName', 'Chilkat Admin'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|signerName', 'Test Test'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|recipientId', '1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|routingOrder', '1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|signerEmail', 'test@tyest.com'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere|anchorString', '\SDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere|optional', 'False'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere[1]|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere[1]|anchorString', '\OSDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere[1]|optional', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere[2]|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere[2]|anchorString', '\OPSSDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere[2]|optional', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere[2]|scaleValue', '0.7'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere[3]|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere[3]|anchorString', '\PSSDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere[3]|optional', 'False'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|signHereTabs|signHere[3]|scaleValue', '0.7'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere|anchorString', '\IDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere|optional', 'False'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere[1]|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere[1]|anchorString', '\OIDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere[1]|optional', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere[2]|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere[2]|anchorString', '\OPSIDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere[2]|optional', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere[2]|scaleValue', '0.5'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere[3]|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere[3]|anchorString', '\PSIDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere[3]|optional', 'False'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner|tabs|initialHereTabs|initialHere[3]|scaleValue', '0.5'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|hostEmail', 'admin@chilkatsoft.com'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|hostName', 'Chilkat Admin'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|signerName', 'Dealer Representative'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|recipientId', '2'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|routingOrder', '2'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|signHereTabs|signHere|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|signHereTabs|signHere|anchorString', '\DSDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|signHereTabs|signHere|optional', 'False'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|signHereTabs|signHere[1]|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|signHereTabs|signHere[1]|anchorString', '\DOSDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|signHereTabs|signHere[1]|optional', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|initialHereTabs|initialHere|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|initialHereTabs|initialHere|anchorString', '\DIDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|initialHereTabs|initialHere|optional', 'False'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|initialHereTabs|initialHere[1]|anchorIgnoreIfNotPresent', 'True'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|initialHereTabs|initialHere[1]|anchorString', '\DOIDP'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'recipients|inPersonSigners|inPersonSigner[1]|tabs|initialHereTabs|initialHere[1]|optional', 'True'
EXEC sp_OASetProperty @xml, 'EmitXmlDecl', 0
EXEC sp_OAMethod @xml, 'GetXml', @sTmp0 OUT
PRINT @sTmp0
EXEC sp_OASetProperty @xml, 'EmitCompact', 1
EXEC sp_OAMethod @xml, 'GetXml', @sTmp0 OUT
EXEC sp_OAMethod @req, 'AddStringForUpload2', @success OUT, '', '', @sTmp0, 'utf-8', 'application/xml'
EXEC sp_OAMethod @req, 'AddFileForUpload2', @success OUT, '', 'qa_data/pdf/signatureForm.pdf', 'application/pdf'
EXEC sp_OAMethod @req, 'AddSubHeader', @success OUT, 1, 'Content-Disposition', 'file; filename="signatureForm.pdf";documentid=1'
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
EXEC sp_OASetProperty @http, 'SessionLogFilename', 'qa_output/log.txt'
DECLARE @resp int
EXEC @hr = sp_OACreate 'Chilkat.HttpResponse', @resp OUT
EXEC sp_OAMethod @http, 'HttpSReq', @success OUT, 'na2.docusign.net', 443, 1, @req, @resp
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @req
EXEC @hr = sp_OADestroy @xmlCred
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @resp
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
IF @iTmp0 <> 201
BEGIN
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
PRINT @sTmp0
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT 'Response status code: ' + @iTmp0
PRINT 'Failed.'
EXEC @hr = sp_OADestroy @req
EXEC @hr = sp_OADestroy @xmlCred
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @resp
RETURN
END
-- Examine the response..
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
EXEC sp_OAMethod @xml, 'LoadXml', @success OUT, @sTmp0
DECLARE @envelopeId nvarchar(4000)
EXEC sp_OAMethod @xml, 'GetChildContent', @envelopeId OUT, 'envelopeId'
PRINT 'envelopeId = ' + @envelopeId
DECLARE @status nvarchar(4000)
EXEC sp_OAMethod @xml, 'GetChildContent', @status OUT, 'status'
PRINT 'status = ' + @status
DECLARE @statusDateTime nvarchar(4000)
EXEC sp_OAMethod @xml, 'GetChildContent', @statusDateTime OUT, 'statusDateTime'
PRINT 'statusDateTime = ' + @statusDateTime
DECLARE @uri nvarchar(4000)
EXEC sp_OAMethod @xml, 'GetChildContent', @uri OUT, 'uri'
PRINT 'uri = ' + @uri
EXEC @hr = sp_OADestroy @req
EXEC @hr = sp_OADestroy @xmlCred
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @resp
END
GO