SQL Server
SQL Server
Calculate a X_RISKIFIED_HMAC_SHA256 for riskified.com API Calls
See more REST Misc Examples
Demonstrates how to calculate the value for the X_RISKIFIED_HMAC_SHA256 header for riskified.com HTTP requests (REST API calls).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)
-- This example requires the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
-- Create the JSON that is to be the body of the HTTP request.
-- The JSON created by this code is shown at the bottom of this example.
--
-- The JSON Code Generator at http://tools.chilkat.io/ can be used
-- to generate the following code from sample JSON.
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'order.cancel_reason'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'order.cancelled_at'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.cart_token', '68778783ad298f1c80c3bafcddeea02f'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'order.closed_at'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.created_at', '2008-01-10T11:00:00-05:00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.currency', 'USD'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.email', 'bob.norman@hostmail.com'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.gateway', 'authorize_net'
EXEC sp_OAMethod @json, 'UpdateNumber', @success OUT, 'order.id', '450789469'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.total_discounts', '0.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.total_price', '409.94'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.updated_at', '2008-01-10T11:00:00-05:00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.note', 'some note made by the shop’s stuff member'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'order.browser_ip'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.discount_codes[0].amount', '10.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.discount_codes[0].code', 'TENOFF'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.line_items[0].title', 'IPod Nano - 8gb - green'
EXEC sp_OAMethod @json, 'UpdateNumber', @success OUT, 'order.line_items[0].price', '199.00'
EXEC sp_OAMethod @json, 'UpdateNumber', @success OUT, 'order.line_items[0].product_id', '632910392'
EXEC sp_OAMethod @json, 'UpdateNumber', @success OUT, 'order.line_items[0].quantity', '1'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.line_items[0].sku', 'IPOD2008GREEN'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_lines[0].code', 'Free Shipping'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_lines[0].price', '0.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_lines[0].title', 'Free Shipping'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'order.payment_details.avs_result_code'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'order.payment_details.credit_card_bin'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.payment_details.credit_card_company', 'Visa'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.payment_details.credit_card_number', 'XXXX-XXXX-XXXX-4242'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'order.payment_details.cvv_result_code'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.payment_details.authorization_id', 'RK346IK124'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.address1', 'Chestnut Street 92'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.address2', ''
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.city', 'Louisville'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'order.billing_address.company'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.country', 'United States'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.country_code', 'US'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.first_name', 'Bob'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.last_name', 'Norman'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.name', 'Bob Norman'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.phone', '555-625-1199'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.province', 'Kentucky'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.province_code', 'KY'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.billing_address.zip', '40202'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.address1', 'Chestnut Street 92'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.address2', ''
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.city', 'Louisville'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'order.shipping_address.company'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.country', 'United States'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.country_code', 'US'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.first_name', 'Bob'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.last_name', 'Norman'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.name', 'Bob Norman'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.phone', '555-625-1199'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.province', 'Kentucky'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.province_code', 'KY'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.shipping_address.zip', '40202'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.customer.created_at', '2013-04-23T13:36:50-04:00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.customer.email', 'bob.norman@hostmail.com'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.customer.first_name', 'Bob'
EXEC sp_OAMethod @json, 'UpdateNumber', @success OUT, 'order.customer.id', '207119551'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'order.customer.last_name', 'Norman'
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'order.customer.note'
EXEC sp_OAMethod @json, 'UpdateNumber', @success OUT, 'order.customer.orders_count', '0'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'order.customer.verified_email', 1
-- Emit the JSON in compact format..
EXEC sp_OASetProperty @json, 'EmitCompact', 1
-- Get the JSON that will be HMAC'd and will also be the contents of the HTTP request body.
DECLARE @jsonBody nvarchar(4000)
EXEC sp_OAMethod @json, 'Emit', @jsonBody OUT
DECLARE @crypt int
EXEC @hr = sp_OACreate 'Chilkat.Crypt2', @crypt OUT
EXEC sp_OASetProperty @crypt, 'EncodingMode', 'hex'
EXEC sp_OASetProperty @crypt, 'HashAlgorithm', 'sha256'
EXEC sp_OASetProperty @crypt, 'MacAlgorithm', 'hmac'
EXEC sp_OAMethod @crypt, 'SetMacKeyString', @success OUT, '55fe0f4d4023bbdfbc124cabd88bf9bb'
DECLARE @hmacHexStr nvarchar(4000)
EXEC sp_OAMethod @crypt, 'MacStringENC', @hmacHexStr OUT, @jsonBody
EXEC sp_OAGetProperty @crypt, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 <> 1
BEGIN
EXEC sp_OAGetProperty @crypt, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @crypt
RETURN
END
-- We need a lowercase hmacHexStr...
DECLARE @sbHmacHex int
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbHmacHex OUT
EXEC sp_OAMethod @sbHmacHex, 'Append', @success OUT, @hmacHexStr
EXEC sp_OAMethod @sbHmacHex, 'ToLowercase', @success OUT
EXEC sp_OAMethod @sbHmacHex, 'GetAsString', @hmacHexStr OUT
PRINT 'The value of the X_RISKIFIED_HMAC_SHA256 should be: ' + @hmacHexStr
-- This example is only to show the HMAC SHA256 calculation.
-- See examples of sending REST requests to riskified.com at http://rest-examples.chilkat.io/riskified/default.cshtml
-- ----------------------------------------------
-- This is the JSON created by the above code..
-- {
-- "order": {
-- "cancel_reason": null,
-- "cancelled_at": null,
-- "cart_token": "68778783ad298f1c80c3bafcddeea02f",
-- "closed_at": null,
-- "created_at": "2008-01-10T11:00:00-05:00",
-- "currency": "USD",
-- "email": "bob.norman@hostmail.com",
-- "gateway": "authorize_net",
-- "id": 450789469,
-- "total_discounts": "0.00",
-- "total_price": "409.94",
-- "updated_at": "2008-01-10T11:00:00-05:00",
-- "note": "some note made by the shop’s stuff member",
-- "browser_ip": null,
-- "discount_codes": [
-- {
-- "amount": "10.00",
-- "code": "TENOFF"
-- }
-- ],
-- "line_items": [
-- {
-- "title": "IPod Nano - 8gb - green",
-- "price": 199.00,
-- "product_id": 632910392,
-- "quantity": 1,
-- "sku": "IPOD2008GREEN"
-- }
-- ],
-- "shipping_lines": [
-- {
-- "code": "Free Shipping",
-- "price": "0.00",
-- "title": "Free Shipping"
-- }
-- ],
-- "payment_details": {
-- "avs_result_code": null,
-- "credit_card_bin": null,
-- "credit_card_company": "Visa",
-- "credit_card_number": "XXXX-XXXX-XXXX-4242",
-- "cvv_result_code": null,
-- "authorization_id": "RK346IK124"
-- },
-- "billing_address": {
-- "address1": "Chestnut Street 92",
-- "address2": "",
-- "city": "Louisville",
-- "company": null,
-- "country": "United States",
-- "country_code": "US",
-- "first_name": "Bob",
-- "last_name": "Norman",
-- "name": "Bob Norman",
-- "phone": "555-625-1199",
-- "province": "Kentucky",
-- "province_code": "KY",
-- "zip": "40202"
-- },
-- "shipping_address": {
-- "address1": "Chestnut Street 92",
-- "address2": "",
-- "city": "Louisville",
-- "company": null,
-- "country": "United States",
-- "country_code": "US",
-- "first_name": "Bob",
-- "last_name": "Norman",
-- "name": "Bob Norman",
-- "phone": "555-625-1199",
-- "province": "Kentucky",
-- "province_code": "KY",
-- "zip": "40202"
-- },
-- "customer": {
-- "created_at": "2013-04-23T13:36:50-04:00",
-- "email": "bob.norman@hostmail.com",
-- "first_name": "Bob",
-- "id": 207119551,
-- "last_name": "Norman",
-- "note": null,
-- "orders_count": 0,
-- "verified_email": true
-- }
-- }
-- }
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @crypt
EXEC @hr = sp_OADestroy @sbHmacHex
END
GO