Chilkat Online Tools

SQL Server / CleverTap API / Test Webhook Payload

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.

    -- {
    --   "is_test": true,
    --   "targetId": 1234,
    --   "key_values": {
    --     "key": "value"
    --   },
    --   "profiles": [
    --     {
    --       "Identity": "UserId",
    --       "Email": "User@user.com",
    --       "push_token": "Token"
    --     },
    --     {
    --       "Identity": "UserId",
    --       "Email": "User@user.com",
    --       "push_token": "Token"
    --     },
    --     {
    --       "Identity": "UserId",
    --       "Email": "User@user.com",
    --       "push_token": "Token"
    --     },
    --     {
    --       "Identity": "UserId",
    --       "Email": "User@user.com",
    --       "push_token": "Token"
    --     },
    --     {
    --       "Identity": "UserId",
    --       "Email": "User@user.com",
    --       "push_token": "Token"
    --     }
    --   ]
    -- }

    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, 'UpdateBool', @success OUT, 'is_test', 1
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'targetId', 1234
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'key_values.key', 'value'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[0].Identity', 'UserId'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[0].Email', 'User@user.com'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[0].push_token', 'Token'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[1].Identity', 'UserId'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[1].Email', 'User@user.com'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[1].push_token', 'Token'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[2].Identity', 'UserId'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[2].Email', 'User@user.com'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[2].push_token', 'Token'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[3].Identity', 'UserId'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[3].Email', 'User@user.com'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[3].push_token', 'Token'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[4].Identity', 'UserId'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[4].Email', 'User@user.com'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'profiles[4].push_token', 'Token'

    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Type', '{{type}}'
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'User-Agent', '{{user-agent}}'
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Length', '{{content-length}}'

    DECLARE @resp int
    EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://domain.com/', '{{type}}', @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 "Content-Type: {{type}}"
	-H "Content-Length: {{content-length}}"
	-H "User-Agent: {{user-agent}}"
	-d '{ "is_test" : true , "targetId" : 1234 , "key_values" : { "key" : "value"} , "profiles" : [ { "Identity" : "UserId" , "Email" : "User@user.com" , "push_token" : "Token"} , { "Identity" : "UserId" , "Email" : "User@user.com" , "push_token" : "Token"} , { "Identity" : "UserId" , "Email" : "User@user.com" , "push_token" : "Token"} , { "Identity" : "UserId" , "Email" : "User@user.com" , "push_token" : "Token"} , { "Identity" : "UserId" , "Email" : "User@user.com" , "push_token" : "Token"}]}'
https://domain.com/

Postman Collection Item JSON

{
  "name": "Test Webhook Payload",
  "request": {
    "method": "POST",
    "header": [
      {
        "key": "Content-Type",
        "value": "{{type}}"
      },
      {
        "key": "Content-Length",
        "value": "{{content-length}}"
      },
      {
        "key": "User-Agent",
        "value": "{{user-agent}}"
      }
    ],
    "body": {
      "mode": "raw",
      "raw": "{ \"is_test\" : true , \"targetId\" : 1234 , \"key_values\" : { \"key\" : \"value\"} , \"profiles\" : [ { \"Identity\" : \"UserId\" , \"Email\" : \"User@user.com\" , \"push_token\" : \"Token\"} , { \"Identity\" : \"UserId\" , \"Email\" : \"User@user.com\" , \"push_token\" : \"Token\"} , { \"Identity\" : \"UserId\" , \"Email\" : \"User@user.com\" , \"push_token\" : \"Token\"} , { \"Identity\" : \"UserId\" , \"Email\" : \"User@user.com\" , \"push_token\" : \"Token\"} , { \"Identity\" : \"UserId\" , \"Email\" : \"User@user.com\" , \"push_token\" : \"Token\"}]}"
    },
    "url": {
      "raw": ""
    }
  },
  "response": [
  ]
}