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
EXEC sp_OASetProperty @http, 'BasicAuth', 1
EXEC sp_OASetProperty @http, 'Login', '100100248'
EXEC sp_OASetProperty @http, 'Password', '117f3fe5a01a0e400f3e4782baf8ffa43a9d21e9217a15f50d545bc72480d081ecaecc1d6a42ac7a785b7437232bd4cf62dbee679b78a75a3892547059018f9b'
-- Use this online tool to generate code from sample JSON: Generate Code to Create JSON
-- The following JSON is sent in the request body.
-- {
-- "amount": {
-- "amount": "37.00",
-- "currency": "USD"
-- },
-- "consumer": {
-- "phoneNumber": "2120000000",
-- "givenNames": "Joe",
-- "surname": "Consumer",
-- "email": "test@afterpay.com"
-- },
-- "billing": {
-- "name": "Joe Consumer",
-- "line1": "1004 Point Lobos Ave",
-- "area1": "San Francisco",
-- "region": "CA",
-- "postcode": "94121",
-- "countryCode": "US",
-- "phoneNumber": "2120000000"
-- },
-- "shipping": {
-- "name": "Joe Consumer",
-- "line1": "1004 Point Lobos Ave",
-- "area1": "San Francisco",
-- "region": "CA",
-- "postcode": "94121",
-- "countryCode": "US",
-- "phoneNumber": "2120000000"
-- },
-- "items": [
-- {
-- "name": "Blue Carabiner",
-- "sku": "12341234",
-- "quantity": 1,
-- "pageUrl": "https://www.afterpay-merchant.com/carabiner-354193.html",
-- "imageUrl": "https://img.afterpay-merchant.com/carabiner-7378-391453-1.jpg",
-- "price": {
-- "amount": "40.00",
-- "currency": "USD"
-- },
-- "categories": [
-- [
-- "Sporting Goods",
-- "Climbing Equipment",
-- "Climbing",
-- "Climbing Carabiners"
-- ],
-- [
-- "Discounts",
-- "Climbing"
-- ]
-- ]
-- },
-- {
-- "name": "Jeans",
-- "sku": "12341235",
-- "quantity": 1,
-- "pageUrl": "https://www.afterpay-merchant.com/jeans-354193.html",
-- "imageUrl": "https://img.afterpay-merchant.com/jeans-7378-391453-1.jpg",
-- "price": {
-- "amount": "20.00",
-- "currency": "USD"
-- }
-- }
-- ],
-- "discounts": [
-- {
-- "displayName": "10% Off Subtotal",
-- "amount": {
-- "amount": "3.00",
-- "currency": "USD"
-- }
-- }
-- ],
-- "merchant": {
-- "redirectConfirmUrl": "https://www.afterpay-merchant.com/confirm",
-- "redirectCancelUrl": "https://www.afterpay-merchant.com/cancel"
-- },
-- "merchantReference": "merchant-order-number",
-- "taxAmount": {
-- "amount": "0.00",
-- "currency": "USD"
-- },
-- "shippingAmount": {
-- "amount": "10.00",
-- "currency": "USD"
-- }
-- }
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'amount.amount', '37.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'amount.currency', 'USD'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'consumer.phoneNumber', '2120000000'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'consumer.givenNames', 'Joe'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'consumer.surname', 'Consumer'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'consumer.email', 'test@afterpay.com'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'billing.name', 'Joe Consumer'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'billing.line1', '1004 Point Lobos Ave'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'billing.area1', 'San Francisco'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'billing.region', 'CA'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'billing.postcode', '94121'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'billing.countryCode', 'US'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'billing.phoneNumber', '2120000000'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'shipping.name', 'Joe Consumer'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'shipping.line1', '1004 Point Lobos Ave'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'shipping.area1', 'San Francisco'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'shipping.region', 'CA'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'shipping.postcode', '94121'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'shipping.countryCode', 'US'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'shipping.phoneNumber', '2120000000'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].name', 'Blue Carabiner'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].sku', '12341234'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'items[0].quantity', 1
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].pageUrl', 'https://www.afterpay-merchant.com/carabiner-354193.html'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].imageUrl', 'https://img.afterpay-merchant.com/carabiner-7378-391453-1.jpg'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].price.amount', '40.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].price.currency', 'USD'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].categories[0][0]', 'Sporting Goods'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].categories[0][1]', 'Climbing Equipment'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].categories[0][2]', 'Climbing'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].categories[0][3]', 'Climbing Carabiners'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].categories[1][0]', 'Discounts'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[0].categories[1][1]', 'Climbing'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[1].name', 'Jeans'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[1].sku', '12341235'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'items[1].quantity', 1
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[1].pageUrl', 'https://www.afterpay-merchant.com/jeans-354193.html'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[1].imageUrl', 'https://img.afterpay-merchant.com/jeans-7378-391453-1.jpg'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[1].price.amount', '20.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'items[1].price.currency', 'USD'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'discounts[0].displayName', '10% Off Subtotal'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'discounts[0].amount.amount', '3.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'discounts[0].amount.currency', 'USD'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'merchant.redirectConfirmUrl', 'https://www.afterpay-merchant.com/confirm'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'merchant.redirectCancelUrl', 'https://www.afterpay-merchant.com/cancel'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'merchantReference', 'merchant-order-number'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'taxAmount.amount', '0.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'taxAmount.currency', 'USD'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'shippingAmount.amount', '10.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'shippingAmount.currency', 'USD'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Type', 'application/json'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Accept', 'application/json'
DECLARE @resp int
EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://api.us-sandbox.afterpay.com/v2/checkouts', '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
-u '100100248:117f3fe5a01a0e400f3e4782baf8ffa43a9d21e9217a15f50d545bc72480d081ecaecc1d6a42ac7a785b7437232bd4cf62dbee679b78a75a3892547059018f9b'
-H "Accept: application/json"
-H "Content-Type: application/json"
-d '{
"amount": {
"amount": "37.00",
"currency": "USD"
},
"consumer": {
"phoneNumber": "2120000000",
"givenNames": "Joe",
"surname": "Consumer",
"email": "test@afterpay.com"
},
"billing": {
"name": "Joe Consumer",
"line1": "1004 Point Lobos Ave",
"area1": "San Francisco",
"region": "CA",
"postcode": "94121",
"countryCode": "US",
"phoneNumber": "2120000000"
},
"shipping": {
"name": "Joe Consumer",
"line1": "1004 Point Lobos Ave",
"area1": "San Francisco",
"region": "CA",
"postcode": "94121",
"countryCode": "US",
"phoneNumber": "2120000000"
},
"items":[
{
"name": "Blue Carabiner",
"sku": "12341234",
"quantity": 1,
"pageUrl": "https://www.afterpay-merchant.com/carabiner-354193.html",
"imageUrl": "https://img.afterpay-merchant.com/carabiner-7378-391453-1.jpg",
"price": {
"amount": "40.00",
"currency": "USD"
},
"categories": [
["Sporting Goods", "Climbing Equipment", "Climbing", "Climbing Carabiners"],
["Discounts", "Climbing"]
]
},
{
"name": "Jeans",
"sku": "12341235",
"quantity": 1,
"pageUrl": "https://www.afterpay-merchant.com/jeans-354193.html",
"imageUrl": "https://img.afterpay-merchant.com/jeans-7378-391453-1.jpg",
"price": {
"amount": "20.00",
"currency": "USD"
}
}
],
"discounts": [
{
"displayName": "10% Off Subtotal",
"amount": {
"amount": "3.00",
"currency": "USD"
}
}
],
"merchant": {
"redirectConfirmUrl": "https://www.afterpay-merchant.com/confirm",
"redirectCancelUrl": "https://www.afterpay-merchant.com/cancel"
},
"merchantReference": "merchant-order-number",
"taxAmount": {
"amount": "0.00",
"currency": "USD"
},
"shippingAmount": {
"amount": "10.00",
"currency": "USD"
}
}'
https://api.us-sandbox.afterpay.com/v2/checkouts
Postman Collection Item JSON
{
"name": "Create Checkout",
"event": [
{
"listen": "test",
"script": {
"id": "6e77d6b5-ef19-40b1-a665-41bbc1cff1c8",
"exec": [
"var jsonData = JSON.parse(responseBody);",
"postman.setEnvironmentVariable(\"token\", jsonData.token);"
],
"type": "text/javascript"
}
},
{
"listen": "prerequest",
"script": {
"id": "28dad3a2-886b-4a2a-8605-6257dee08b82",
"exec": [
""
],
"type": "text/javascript"
}
}
],
"request": {
"method": "POST",
"header": [
{
"key": "Accept",
"value": "application/json"
},
{
"key": "Content-Type",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"amount\": {\n \"amount\": \"37.00\",\n \"currency\": \"USD\"\n },\n \"consumer\": {\n \"phoneNumber\": \"2120000000\",\n \"givenNames\": \"Joe\",\n \"surname\": \"Consumer\",\n \"email\": \"test@afterpay.com\"\n },\n \"billing\": {\n \"name\": \"Joe Consumer\",\n \"line1\": \"1004 Point Lobos Ave\",\n \"area1\": \"San Francisco\",\n \"region\": \"CA\",\n \"postcode\": \"94121\",\n \"countryCode\": \"US\",\n \"phoneNumber\": \"2120000000\"\n },\n \"shipping\": {\n \"name\": \"Joe Consumer\",\n \"line1\": \"1004 Point Lobos Ave\",\n \"area1\": \"San Francisco\",\n \"region\": \"CA\",\n \"postcode\": \"94121\",\n \"countryCode\": \"US\",\n \"phoneNumber\": \"2120000000\"\n },\n \"items\":[\n {\n \"name\": \"Blue Carabiner\",\n \"sku\": \"12341234\",\n \"quantity\": 1,\n \"pageUrl\": \"https://www.afterpay-merchant.com/carabiner-354193.html\",\n \"imageUrl\": \"https://img.afterpay-merchant.com/carabiner-7378-391453-1.jpg\",\n \"price\": {\n \"amount\": \"40.00\",\n \"currency\": \"USD\"\n },\n \"categories\": [\n [\"Sporting Goods\", \"Climbing Equipment\", \"Climbing\", \"Climbing Carabiners\"],\n [\"Discounts\", \"Climbing\"]\n ]\n },\n {\n \"name\": \"Jeans\",\n \"sku\": \"12341235\",\n \"quantity\": 1,\n \"pageUrl\": \"https://www.afterpay-merchant.com/jeans-354193.html\",\n \"imageUrl\": \"https://img.afterpay-merchant.com/jeans-7378-391453-1.jpg\",\n \"price\": {\n \"amount\": \"20.00\",\n \"currency\": \"USD\"\n }\n }\n ],\n \"discounts\": [\n {\n \"displayName\": \"10% Off Subtotal\",\n \"amount\": {\n \"amount\": \"3.00\",\n \"currency\": \"USD\"\n }\n }\n ],\n \"merchant\": {\n \"redirectConfirmUrl\": \"https://www.afterpay-merchant.com/confirm\",\n \"redirectCancelUrl\": \"https://www.afterpay-merchant.com/cancel\"\n },\n \"merchantReference\": \"merchant-order-number\",\n \"taxAmount\": {\n \"amount\": \"0.00\",\n \"currency\": \"USD\"\n },\n \"shippingAmount\": {\n \"amount\": \"10.00\",\n \"currency\": \"USD\"\n }\n }"
},
"url": {
"raw": "https://api.us-sandbox.afterpay.com/v2/checkouts",
"protocol": "https",
"host": [
"api",
"us-sandbox",
"afterpay",
"com"
],
"path": [
"v2",
"checkouts"
]
},
"description": "This endpoint creates a checkout that is used to initiate the afterpay payment process. Afterpay uses the information in the checkout request to assist with the consumer’s pre-approval process."
},
"response": [
]
}
