SQL Server / Razorpay APIs / Transfer Payment Link Amount to Linked Account
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', 'username'
EXEC sp_OASetProperty @http, 'Password', 'password'
-- 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": 1500,
-- "currency": "INR",
-- "accept_partial": false,
-- "reference_id": "#aasasw8",
-- "description": "Payment for policy no #23456",
-- "customer": {
-- "name": "Gaurav Kumar",
-- "contact": "+919999999999",
-- "email": "gaurav.kumar@example.com"
-- },
-- "notify": {
-- "sms": true,
-- "email": true
-- },
-- "reminder_enable": true,
-- "options": {
-- "order": {
-- "transfers": [
-- {
-- "account": "acc_CPRsN1LkFccllA",
-- "amount": 500,
-- "currency": "INR",
-- "notes": {
-- "branch": "Acme Corp Bangalore North",
-- "name": "Bhairav Kumar"
-- },
-- "linked_account_notes": [
-- "branch"
-- ]
-- },
-- {
-- "account": "acc_CNo3jSI8OkFJJJ",
-- "amount": 500,
-- "currency": "INR",
-- "notes": {
-- "branch": "Acme Corp Bangalore South",
-- "name": "Saurav Kumar"
-- },
-- "linked_account_notes": [
-- "branch"
-- ]
-- }
-- ]
-- }
-- }
-- }
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'amount', 1500
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'currency', 'INR'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'accept_partial', 0
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'reference_id', '#aasasw8'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'description', 'Payment for policy no #23456'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'customer.name', 'Gaurav Kumar'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'customer.contact', '+919999999999'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'customer.email', 'gaurav.kumar@example.com'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'notify.sms', 1
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'notify.email', 1
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'reminder_enable', 1
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.order.transfers[0].account', 'acc_CPRsN1LkFccllA'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'options.order.transfers[0].amount', 500
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.order.transfers[0].currency', 'INR'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.order.transfers[0].notes.branch', 'Acme Corp Bangalore North'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.order.transfers[0].notes.name', 'Bhairav Kumar'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.order.transfers[0].linked_account_notes[0]', 'branch'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.order.transfers[1].account', 'acc_CNo3jSI8OkFJJJ'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'options.order.transfers[1].amount', 500
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.order.transfers[1].currency', 'INR'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.order.transfers[1].notes.branch', 'Acme Corp Bangalore South'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.order.transfers[1].notes.name', 'Saurav Kumar'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.order.transfers[1].linked_account_notes[0]', 'branch'
DECLARE @resp int
EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://api.razorpay.com/v1/payment_links/', '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 'username:password'
-d '{
"amount": 1500,
"currency": "INR",
"accept_partial": false,
"reference_id": "#aasasw8",
"description": "Payment for policy no #23456",
"customer": {
"name": "Gaurav Kumar",
"contact": "+919999999999",
"email": "gaurav.kumar@example.com"
},
"notify": {
"sms": true,
"email": true
},
"reminder_enable": true,
"options": {
"order": {
"transfers": [
{
"account": "acc_CPRsN1LkFccllA",
"amount": 500,
"currency": "INR",
"notes": {
"branch": "Acme Corp Bangalore North",
"name": "Bhairav Kumar"
},
"linked_account_notes": [
"branch"
]
},
{
"account": "acc_CNo3jSI8OkFJJJ",
"amount": 500,
"currency": "INR",
"notes": {
"branch": "Acme Corp Bangalore South",
"name": "Saurav Kumar"
},
"linked_account_notes": [
"branch"
]
}
]
}
}
}'
https://api.razorpay.com/v1/payment_links/
Postman Collection Item JSON
{
"name": "Transfer Payment Link Amount to Linked Account",
"request": {
"auth": {
"type": "basic",
"basic": [
{
"key": "username",
"value": "rzp_test_SfP9tlfnec4ntR",
"type": "string"
},
{
"key": "password",
"value": "4ucQzqIsRp0yEJmtEmj3xNcH",
"type": "string"
},
{
"key": "showPassword",
"value": false,
"type": "boolean"
}
]
},
"method": "POST",
"header": [
],
"body": {
"mode": "raw",
"raw": "{\n \"amount\": 1500,\n \"currency\": \"INR\",\n \"accept_partial\": false,\n \"reference_id\": \"#aasasw8\",\n \"description\": \"Payment for policy no #23456\",\n \"customer\": {\n \"name\": \"Gaurav Kumar\",\n \"contact\": \"+919999999999\",\n \"email\": \"gaurav.kumar@example.com\"\n },\n \"notify\": {\n \"sms\": true,\n \"email\": true\n },\n \"reminder_enable\": true,\n \"options\": {\n \"order\": {\n \"transfers\": [\n {\n \"account\": \"acc_CPRsN1LkFccllA\",\n \"amount\": 500,\n \"currency\": \"INR\",\n \"notes\": {\n \"branch\": \"Acme Corp Bangalore North\",\n \"name\": \"Bhairav Kumar\"\n },\n \"linked_account_notes\": [\n \"branch\"\n ]\n },\n {\n \"account\": \"acc_CNo3jSI8OkFJJJ\",\n \"amount\": 500,\n \"currency\": \"INR\",\n \"notes\": {\n \"branch\": \"Acme Corp Bangalore South\",\n \"name\": \"Saurav Kumar\"\n },\n \"linked_account_notes\": [\n \"branch\"\n ]\n }\n ]\n }\n }\n}",
"options": {
"raw": {
"language": "json"
}
}
},
"url": {
"raw": "https://api.razorpay.com/v1/payment_links/",
"protocol": "https",
"host": [
"api",
"razorpay",
"com"
],
"path": [
"v1",
"payment_links",
""
]
},
"description": "Using Razorpay Payment Links, you can transfer the payments received from your customers automatically to your linked accounts. You no longer need to create a separate transfer using Razorpay Route Transfers API. Instead, you can use the order parameter in <a href=\"https://razorpay.com/docs/api/payment-links/advanced-options/transfers/\" target=\"_blank\">Create Payment Links API</a> to automate the transfer once the payment is received from the customer."
},
"response": [
]
}
