Chilkat Online Tools

SQL Server / Salesforce Platform APIs / Create Payment Method

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.

    -- {
    --   "paymentGatewayId": "{{defaultPaymentGatewayId}}",
    --   "cardPaymentMethod": {
    --     "cardHolderName": "{{_userFullName}}",
    --     "expiryMonth": "11",
    --     "expiryYear": "2222",
    --     "cardNumber": "4111111111111111",
    --     "cvv": "111",
    --     "cardCategory": "CreditCard",
    --     "cardType": "VISA",
    --     "startYear": "2013",
    --     "startMonth": "7",
    --     "nickName": "Default Payment Method",
    --     "accountId": "{{defaultAccountId}}"
    --   },
    --   "phone": "4155551212",
    --   "email": "{{_userEmail}}",
    --   "additionalData": {
    --     "key1": "value1",
    --     "key2": "value2"
    --   }
    -- }

    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, 'paymentGatewayId', '{{defaultPaymentGatewayId}}'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'cardPaymentMethod.cardHolderName', '{{_userFullName}}'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'cardPaymentMethod.expiryMonth', '11'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'cardPaymentMethod.expiryYear', '2222'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'cardPaymentMethod.cardNumber', '4111111111111111'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'cardPaymentMethod.cvv', '111'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'cardPaymentMethod.cardCategory', 'CreditCard'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'cardPaymentMethod.cardType', 'VISA'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'cardPaymentMethod.startYear', '2013'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'cardPaymentMethod.startMonth', '7'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'cardPaymentMethod.nickName', 'Default Payment Method'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'cardPaymentMethod.accountId', '{{defaultAccountId}}'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'phone', '4155551212'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'email', '{{_userEmail}}'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'additionalData.key1', 'value1'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'additionalData.key2', 'value2'

    -- Adds the "Authorization: Bearer <access_token>" header.
    EXEC sp_OASetProperty @http, 'AuthToken', '<access_token>'

    DECLARE @resp int
    EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://domain.com/services/data/v{{version}}/commerce/payments/payment-methods', '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>"
	-d '{
    "paymentGatewayId" : "{{defaultPaymentGatewayId}}",
    "cardPaymentMethod": {
    "cardHolderName": "{{_userFullName}}",
    "expiryMonth": "11",
    "expiryYear": "2222",
    "cardNumber": "4111111111111111",
    "cvv": "111", 
    "cardCategory": "CreditCard",
    "cardType": "VISA",
    "startYear": "2013",
    "startMonth": "7",
    "nickName": "Default Payment Method",
    "accountId": "{{defaultAccountId}}"
    },
  "phone": "4155551212",
  "email": "{{_userEmail}}",
  "additionalData":{
      "key1":"value1",
      "key2":"value2"
    }
}'
https://domain.com/services/data/v{{version}}/commerce/payments/payment-methods

Postman Collection Item JSON

{
  "name": "Create Payment Method",
  "request": {
    "method": "POST",
    "header": [
    ],
    "body": {
      "mode": "raw",
      "raw": "{\n    \"paymentGatewayId\" : \"{{defaultPaymentGatewayId}}\",\n    \"cardPaymentMethod\": {\n    \"cardHolderName\": \"{{_userFullName}}\",\n    \"expiryMonth\": \"11\",\n    \"expiryYear\": \"2222\",\n    \"cardNumber\": \"4111111111111111\",\n    \"cvv\": \"111\", \n    \"cardCategory\": \"CreditCard\",\n    \"cardType\": \"VISA\",\n    \"startYear\": \"2013\",\n    \"startMonth\": \"7\",\n    \"nickName\": \"Default Payment Method\",\n    \"accountId\": \"{{defaultAccountId}}\"\n    },\n  \"phone\": \"4155551212\",\n  \"email\": \"{{_userEmail}}\",\n  \"additionalData\":{\n      \"key1\":\"value1\",\n      \"key2\":\"value2\"\n    }\n}",
      "options": {
        "raw": {
          "language": "json"
        }
      }
    },
    "url": {
      "raw": "{{_endpoint}}/services/data/v{{version}}/commerce/payments/payment-methods",
      "host": [
        "{{_endpoint}}"
      ],
      "path": [
        "services",
        "data",
        "v{{version}}",
        "commerce",
        "payments",
        "payment-methods"
      ]
    }
  },
  "response": [
  ]
}