Back to Collection Items
-- 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)
-- 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
-- Use this online tool to generate code from sample JSON: Generate Code to Create JSON
-- The following JSON is sent in the request body.
-- {
-- "name": "API Sample Document from PandaDoc Template",
-- "template_uuid": "{{template_id}}",
-- "folder_uuid": "{{documents_folder_uuid}}",
-- "recipients": [
-- {
-- "email": "{{recipient_email}}",
-- "first_name": "Jane",
-- "last_name": "Roe",
-- "role": "user"
-- }
-- ],
-- "tokens": [
-- {
-- "name": "Favorite.Pet",
-- "value": "Panda"
-- }
-- ],
-- "fields": {
-- "Favorite.Color": {
-- "value": "PandaDoc green"
-- },
-- "Delivery": {
-- "value": "Same Day Delivery"
-- },
-- "Like": {
-- "value": true
-- },
-- "Date": {
-- "value": "2019-12-31T00:00:00.000Z"
-- }
-- },
-- "metadata": {
-- "opp_id": "123456",
-- "my_favorite_pet": "Panda"
-- },
-- "tags": [
-- "created_via_api",
-- "test_document"
-- ],
-- "pricing_tables": [
-- {
-- "name": "PricingTable1",
-- "options": {
-- "currency": "USD",
-- "discount": {
-- "is_global": true,
-- "type": "absolute",
-- "name": "Global Discount",
-- "value": 2.26
-- }
-- },
-- "sections": [
-- {
-- "title": "Sample Section",
-- "default": true,
-- "rows": [
-- {
-- "options": {
-- "optional": true,
-- "optional_selected": true,
-- "qty_editable": true
-- },
-- "data": {
-- "name": "Toy Panda",
-- "description": "Fluffy!",
-- "price": 10,
-- "qty": 3,
-- "tax_first": {
-- "value": 7.5,
-- "type": "percent"
-- }
-- },
-- "custom_fields": {
-- "Fluffiness": "5 / 5"
-- }
-- }
-- ]
-- }
-- ]
-- }
-- ]
-- }
DECLARE @json int
-- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'name', 'API Sample Document from PandaDoc Template'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'template_uuid', '{{template_id}}'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'folder_uuid', '{{documents_folder_uuid}}'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'recipients[0].email', '{{recipient_email}}'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'recipients[0].first_name', 'Jane'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'recipients[0].last_name', 'Roe'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'recipients[0].role', 'user'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'tokens[0].name', 'Favorite.Pet'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'tokens[0].value', 'Panda'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'fields."Favorite.Color".value', 'PandaDoc green'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'fields.Delivery.value', 'Same Day Delivery'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'fields.Like.value', 1
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'fields.Date.value', '2019-12-31T00:00:00.000Z'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'metadata.opp_id', '123456'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'metadata.my_favorite_pet', 'Panda'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'tags[0]', 'created_via_api'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'tags[1]', 'test_document'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'pricing_tables[0].name', 'PricingTable1'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'pricing_tables[0].options.currency', 'USD'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'pricing_tables[0].options.discount.is_global', 1
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'pricing_tables[0].options.discount.type', 'absolute'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'pricing_tables[0].options.discount.name', 'Global Discount'
EXEC sp_OAMethod @json, 'UpdateNumber', @success OUT, 'pricing_tables[0].options.discount.value', '2.26'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'pricing_tables[0].sections[0].title', 'Sample Section'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'pricing_tables[0].sections[0].default', 1
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'pricing_tables[0].sections[0].rows[0].options.optional', 1
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'pricing_tables[0].sections[0].rows[0].options.optional_selected', 1
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'pricing_tables[0].sections[0].rows[0].options.qty_editable', 1
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'pricing_tables[0].sections[0].rows[0].data.name', 'Toy Panda'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'pricing_tables[0].sections[0].rows[0].data.description', 'Fluffy!'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'pricing_tables[0].sections[0].rows[0].data.price', 10
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'pricing_tables[0].sections[0].rows[0].data.qty', 3
EXEC sp_OAMethod @json, 'UpdateNumber', @success OUT, 'pricing_tables[0].sections[0].rows[0].data.tax_first.value', '7.5'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'pricing_tables[0].sections[0].rows[0].data.tax_first.type', 'percent'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'pricing_tables[0].sections[0].rows[0].custom_fields.Fluffiness', '5 / 5'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Authorization', 'API-Key {{api_key}}'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Type', 'application/json'
DECLARE @resp int
EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://api.pandadoc.com/public/v1/documents', 'application/json', @json
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT @iTmp0
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
END
GO
Curl Command
curl -X POST
-H "Authorization: Bearer {{access_token}}"
-H "Authorization: API-Key {{api_key}}"
-H "Content-Type: application/json"
-d '{
"name": "API Sample Document from PandaDoc Template",
"template_uuid": "{{template_id}}",
"folder_uuid": "{{documents_folder_uuid}}",
"recipients": [
{
"email": "{{recipient_email}}",
"first_name": "Jane",
"last_name": "Roe",
"role": "user"
}
],
"tokens": [
{
"name": "Favorite.Pet",
"value": "Panda"
}
],
"fields": {
"Favorite.Color": {
"value": "PandaDoc green"
},
"Delivery": {
"value": "Same Day Delivery"
},
"Like": {
"value": true
},
"Date": {
"value": "2019-12-31T00:00:00.000Z"
}
},
"metadata":{
"opp_id": "123456",
"my_favorite_pet": "Panda"
},
"tags": [
"created_via_api",
"test_document"
],
"pricing_tables": [
{
"name": "PricingTable1",
"options": {
"currency": "USD",
"discount": {
"is_global": true,
"type": "absolute",
"name": "Global Discount",
"value": 2.26
}
},
"sections": [
{
"title": "Sample Section",
"default": true,
"rows": [
{
"options": {
"optional": true,
"optional_selected": true,
"qty_editable": true
},
"data":{
"name": "Toy Panda",
"description": "Fluffy!",
"price": 10,
"qty": 3,
"tax_first": {
"value": 7.5,
"type": "percent"
}
},
"custom_fields": {
"Fluffiness": "5 / 5"
}
}
]
}
]
}
]
}'
https://api.pandadoc.com/public/v1/documents
Postman Collection Item JSON
{
"name": "Create Document in a Folder",
"event": [
{
"listen": "test",
"script": {
"type": "text/javascript",
"exec": [
"var jsonData = JSON.parse(responseBody);",
"if (jsonData.uuid !== undefined) {",
" postman.setEnvironmentVariable(\"document_id\", jsonData.uuid);",
"}"
]
}
}
],
"request": {
"method": "POST",
"header": [
{
"key": "Authorization",
"value": "Bearer {{access_token}}",
"disabled": true
},
{
"key": "Authorization",
"value": "API-Key {{api_key}}",
"type": "text"
},
{
"key": "Content-Type",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{ \n \"name\": \"API Sample Document from PandaDoc Template\",\n \"template_uuid\": \"{{template_id}}\",\n \"folder_uuid\": \"{{documents_folder_uuid}}\",\n \"recipients\": [ \n { \n \"email\": \"{{recipient_email}}\",\n \"first_name\": \"Jane\",\n \"last_name\": \"Roe\",\n \"role\": \"user\"\n }\n ],\n \"tokens\": [ \n { \n \"name\": \"Favorite.Pet\",\n \"value\": \"Panda\"\n }\n ],\n \"fields\": { \n \"Favorite.Color\": { \n \"value\": \"PandaDoc green\"\n },\n \"Delivery\": {\n \t\"value\": \"Same Day Delivery\"\n },\n \"Like\": {\n \t\"value\": true\n },\n \"Date\": {\n \t\"value\": \"2019-12-31T00:00:00.000Z\"\n }\n },\n \"metadata\":{ \n \"opp_id\": \"123456\",\n \"my_favorite_pet\": \"Panda\"\n },\n \"tags\": [\n \"created_via_api\",\n \"test_document\"\n\t], \n \"pricing_tables\": [ \n { \n \"name\": \"PricingTable1\",\n \"options\": { \n \"currency\": \"USD\",\n \"discount\": { \n \"is_global\": true,\n \"type\": \"absolute\",\n \"name\": \"Global Discount\",\n \"value\": 2.26\n }\n },\n \"sections\": [ \n { \n \"title\": \"Sample Section\",\n \"default\": true,\n \"rows\": [ \n { \n \"options\": { \n \"optional\": true,\n \"optional_selected\": true,\n \"qty_editable\": true\n },\n \"data\":{ \n \"name\": \"Toy Panda\",\n \"description\": \"Fluffy!\",\n \"price\": 10,\n \"qty\": 3,\n \"tax_first\": { \n \"value\": 7.5,\n \"type\": \"percent\"\n }\n },\n \"custom_fields\": { \n \"Fluffiness\": \"5 / 5\"\n }\n }\n ]\n }\n ]\n }\n ]\n}"
},
"url": {
"raw": "https://api.pandadoc.com/public/v1/documents",
"protocol": "https",
"host": [
"api",
"pandadoc",
"com"
],
"path": [
"public",
"v1",
"documents"
]
},
"description": "Provide value to variables: template_id and documents_folder_uuid ([Postman environments](https://www.getpostman.com/docs/postman/environments_and_globals/manage_environments) is great for it).\n\nFor details and the sample template go to [https://developers.pandadoc.com/v1/reference#create-document-from-pandadoc-template](https://developers.pandadoc.com/v1/reference#create-document-from-pandadoc-template).\n\nFor details of document creation in general go to [https://developers.pandadoc.com/v1/reference#new-document](https://developers.pandadoc.com/v1/reference#new-document)."
},
"response": [
]
}
