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
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.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 XML: Generate Code to Create XML
-- The following XML is sent in the request body.
-- <?xml version="1.0" encoding="utf-8"?>
-- <supplier>
-- <name>Coupa Supplier 1</name>
-- <display-name>Coupa Supplier 1</display-name>
-- <number>supplier1#</number>
-- <status>active</status>
-- <po-method>email</po-method>
-- <po-change-method>email</po-change-method>
-- <default-locale>en</default-locale>
-- <payment-method>invoice</payment-method>
-- <po-email>coupasupplier@coupa.com</po-email>
-- <invoice-matching-level>3-way</invoice-matching-level>
-- <primary-contact>
-- <email>coupasupplierprimarycontact@gmail.com</email>
-- <name-given>Coupa Supplier Name</name-given>
-- <name-family>Coupa Supplier Family Name</name-family>
-- </primary-contact>
-- <primary-address>
-- <name>Coupa Supplier Name</name>
-- <street1>Test Street</street1>
-- <city>Test City</city>
-- <state>NC</state>
-- <postal-code>27560</postal-code>
-- <country>
-- <code>US</code>
-- </country>
-- </primary-address>
-- <enterprise>
-- <code>GLOBAL</code>
-- </enterprise>
-- <payment-term>
-- <code>2/20 Net 30</code>
-- </payment-term>
-- <content-groups type="array">
-- <content-group>
-- <name>IT</name>
-- </content-group>
-- </content-groups>
-- <supplier-addresses type="array">
-- <supplier-address>
-- <name>Coupa Supplier Address 1</name>
-- <street1>Test Street</street1>
-- <city>Test City</city>
-- <state>NC</state>
-- <postal-code>27560</postal-code>
-- <country>
-- <code>US</code>
-- </country>
-- </supplier-address>
-- <supplier-address>
-- <name>Coupa Supplier Address 2</name>
-- <street1>Test Street</street1>
-- <city>Test City</city>
-- <state>NC</state>
-- <postal-code>27560</postal-code>
-- <country>
-- <code>US</code>
-- </country>
-- <purposes type="array">
-- <purpose>
-- <name>other_address</name>
-- </purpose>
-- </purposes>
-- </supplier-address>
-- </supplier-addresses>
-- <contacts type="array">
-- <contact>
-- <email>coupasupplierprimarycontact@gmail.com</email>
-- <name-given>Coupa Supplier Name</name-given>
-- <name-family>Coupa Supplier Family Name</name-family>
-- </contact>
-- </contacts>
-- <diversities>
-- <diversity>
-- <diversity-category>
-- <code>WBE</code>
-- <category>Woman Owned Business Enterprise</category>
-- </diversity-category>
-- <country>
-- <code>US</code>
-- </country>
-- </diversity>
-- </diversities>
-- </supplier>
--
DECLARE @xml int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Xml', @xml OUT
EXEC sp_OASetProperty @xml, 'Tag', 'supplier'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'name', 'Coupa Supplier 1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'display-name', 'Coupa Supplier 1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'number', 'supplier1#'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'status', 'active'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'po-method', 'email'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'po-change-method', 'email'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'default-locale', 'en'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'payment-method', 'invoice'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'po-email', 'coupasupplier@coupa.com'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'invoice-matching-level', '3-way'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'primary-contact|email', 'coupasupplierprimarycontact@gmail.com'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'primary-contact|name-given', 'Coupa Supplier Name'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'primary-contact|name-family', 'Coupa Supplier Family Name'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'primary-address|name', 'Coupa Supplier Name'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'primary-address|street1', 'Test Street'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'primary-address|city', 'Test City'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'primary-address|state', 'NC'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'primary-address|postal-code', 27560
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'primary-address|country|code', 'US'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'enterprise|code', 'GLOBAL'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'payment-term|code', '2/20 Net 30'
EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'content-groups', 1, 'type', 'array'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'content-groups|content-group|name', 'IT'
EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'supplier-addresses', 1, 'type', 'array'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-addresses|supplier-address|name', 'Coupa Supplier Address 1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-addresses|supplier-address|street1', 'Test Street'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-addresses|supplier-address|city', 'Test City'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-addresses|supplier-address|state', 'NC'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'supplier-addresses|supplier-address|postal-code', 27560
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-addresses|supplier-address|country|code', 'US'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-addresses|supplier-address[1]|name', 'Coupa Supplier Address 2'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-addresses|supplier-address[1]|street1', 'Test Street'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-addresses|supplier-address[1]|city', 'Test City'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-addresses|supplier-address[1]|state', 'NC'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'supplier-addresses|supplier-address[1]|postal-code', 27560
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-addresses|supplier-address[1]|country|code', 'US'
EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'supplier-addresses|supplier-address[1]|purposes', 1, 'type', 'array'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'supplier-addresses|supplier-address[1]|purposes|purpose|name', 'other_address'
EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, 'contacts', 1, 'type', 'array'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'contacts|contact|email', 'coupasupplierprimarycontact@gmail.com'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'contacts|contact|name-given', 'Coupa Supplier Name'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'contacts|contact|name-family', 'Coupa Supplier Family Name'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'diversities|diversity|diversity-category|code', 'WBE'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'diversities|diversity|diversity-category|category', 'Woman Owned Business Enterprise'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'diversities|diversity|country|code', 'US'
-- Adds the "Authorization: Bearer <access_token>" header.
EXEC sp_OASetProperty @http, 'AuthToken', '<access_token>'
DECLARE @sbRequestBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbRequestBody OUT
EXEC sp_OAMethod @xml, 'GetXmlSb', @success OUT, @sbRequestBody
DECLARE @resp int
EXEC sp_OAMethod @http, 'PTextSb', @resp OUT, 'POST', 'https://domain.com/suppliers?fields=["id"]', @sbRequestBody, 'utf-8', 'application/xml', 0, 0
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 @xml
EXEC @hr = sp_OADestroy @sbRequestBody
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 @xml
EXEC @hr = sp_OADestroy @sbRequestBody
END
GO
Curl Command
curl -X POST
-H "Authorization: Bearer <access_token>"
-d '<supplier>
<name>Coupa Supplier 1</name>
<display-name>Coupa Supplier 1</display-name>
<number>supplier1#</number>
<status>active</status>
<po-method>email</po-method>
<po-change-method>email</po-change-method>
<default-locale>en</default-locale>
<payment-method>invoice</payment-method>
<po-email>coupasupplier@coupa.com</po-email>
<invoice-matching-level>3-way</invoice-matching-level>
<primary-contact>
<email>coupasupplierprimarycontact@gmail.com</email>
<name-given>Coupa Supplier Name</name-given>
<name-family>Coupa Supplier Family Name</name-family>
</primary-contact>
<primary-address>
<name>Coupa Supplier Name</name>
<street1>Test Street</street1>
<city>Test City</city>
<state>NC</state>
<postal-code>27560</postal-code>
<country>
<code>US</code>
</country>
</primary-address>
<enterprise>
<code>GLOBAL</code>
</enterprise>
<payment-term>
<code>2/20 Net 30</code>
</payment-term>
<content-groups type="array">
<content-group>
<name>IT</name>
</content-group>
</content-groups>
<supplier-addresses type="array">
<supplier-address>
<name>Coupa Supplier Address 1</name>
<street1>Test Street</street1>
<city>Test City</city>
<state>NC</state>
<postal-code>27560</postal-code>
<country>
<code>US</code>
</country>
</supplier-address>
<supplier-address>
<name>Coupa Supplier Address 2</name>
<street1>Test Street</street1>
<city>Test City</city>
<state>NC</state>
<postal-code>27560</postal-code>
<country>
<code>US</code>
</country>
<purposes type="array">
<purpose>
<name>other_address</name>
</purpose>
</purposes>
</supplier-address>
</supplier-addresses>
<contacts type="array">
<contact>
<email>coupasupplierprimarycontact@gmail.com</email>
<name-given>Coupa Supplier Name</name-given>
<name-family>Coupa Supplier Family Name</name-family>
</contact>
</contacts>
<diversities>
<diversity>
<diversity-category>
<code>WBE</code>
<category>Woman Owned Business Enterprise</category>
</diversity-category>
<country>
<code>US</code>
</country>
</diversity>
</diversities>
</supplier>'
https://domain.com/suppliers?fields=["id"]
Postman Collection Item JSON
{
"name": "Create a supplier",
"request": {
"method": "POST",
"header": [
],
"body": {
"mode": "raw",
"raw": "<supplier>\n <name>Coupa Supplier 1</name>\n <display-name>Coupa Supplier 1</display-name>\n <number>supplier1#</number>\n <status>active</status>\n <po-method>email</po-method>\n <po-change-method>email</po-change-method>\n <default-locale>en</default-locale>\n <payment-method>invoice</payment-method>\n <po-email>coupasupplier@coupa.com</po-email>\n <invoice-matching-level>3-way</invoice-matching-level>\n <primary-contact>\n <email>coupasupplierprimarycontact@gmail.com</email>\n <name-given>Coupa Supplier Name</name-given>\n <name-family>Coupa Supplier Family Name</name-family>\n </primary-contact>\n <primary-address>\n <name>Coupa Supplier Name</name>\n <street1>Test Street</street1>\n <city>Test City</city>\n <state>NC</state>\n <postal-code>27560</postal-code>\n <country>\n <code>US</code>\n </country>\n </primary-address>\n <enterprise>\n <code>GLOBAL</code>\n </enterprise>\n <payment-term>\n <code>2/20 Net 30</code>\n </payment-term>\n <content-groups type=\"array\">\n <content-group>\n <name>IT</name>\n </content-group>\n </content-groups>\n <supplier-addresses type=\"array\">\n <supplier-address>\n <name>Coupa Supplier Address 1</name>\n <street1>Test Street</street1>\n <city>Test City</city>\n <state>NC</state>\n <postal-code>27560</postal-code>\n <country>\n <code>US</code>\n </country>\n </supplier-address>\n <supplier-address>\n <name>Coupa Supplier Address 2</name>\n <street1>Test Street</street1>\n <city>Test City</city>\n <state>NC</state>\n <postal-code>27560</postal-code>\n <country>\n <code>US</code>\n </country>\n <purposes type=\"array\">\n <purpose>\n <name>other_address</name>\n </purpose>\n </purposes>\n </supplier-address>\n </supplier-addresses>\n <contacts type=\"array\">\n <contact>\n <email>coupasupplierprimarycontact@gmail.com</email>\n <name-given>Coupa Supplier Name</name-given>\n <name-family>Coupa Supplier Family Name</name-family>\n </contact>\n </contacts>\n <diversities>\n <diversity>\n <diversity-category>\n <code>WBE</code>\n <category>Woman Owned Business Enterprise</category>\n </diversity-category>\n <country>\n <code>US</code>\n </country>\n </diversity>\n </diversities>\n</supplier>",
"options": {
"raw": {
"language": "xml"
}
}
},
"url": {
"raw": "{{URL}}/suppliers?fields=[\"id\"]",
"host": [
"{{URL}}"
],
"path": [
"suppliers"
],
"query": [
{
"key": "fields",
"value": "[\"id\"]"
}
]
}
},
"response": [
]
}
