SQL Server / Razorpay APIs / Transfer via Orders
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
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": 200,
-- "payment_capture": 1,
-- "currency": "INR",
-- "transfers": [
-- {
-- "account": "acc_id",
-- "amount": 100,
-- "currency": "INR",
-- "notes": {
-- "branch": "Acme Corp Bangalore North",
-- "name": "Gaurav Kumar"
-- },
-- "linked_account_notes": [
-- "branch"
-- ],
-- "on_hold": true,
-- "on_hold_until": 1691222870
-- },
-- {
-- "account": "acc_id",
-- "amount": 100,
-- "currency": "INR",
-- "notes": {
-- "branch": "Acme Corp Bangalore South",
-- "name": "Saurav Kumar"
-- },
-- "linked_account_notes": [
-- "branch"
-- ],
-- "on_hold": false,
-- "on_hold_until": null
-- }
-- ]
-- }
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, 'UpdateInt', @success OUT, 'amount', 200
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'payment_capture', 1
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'currency', 'INR'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transfers[0].account', 'acc_id'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'transfers[0].amount', 100
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transfers[0].currency', 'INR'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transfers[0].notes.branch', 'Acme Corp Bangalore North'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transfers[0].notes.name', 'Gaurav Kumar'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transfers[0].linked_account_notes[0]', 'branch'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'transfers[0].on_hold', 1
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'transfers[0].on_hold_until', 1691222870
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transfers[1].account', 'acc_id'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'transfers[1].amount', 100
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transfers[1].currency', 'INR'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transfers[1].notes.branch', 'Acme Corp Bangalore South'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transfers[1].notes.name', 'Saurav Kumar'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transfers[1].linked_account_notes[0]', 'branch'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'transfers[1].on_hold', 0
EXEC sp_OAMethod @json, 'UpdateNull', @success OUT, 'transfers[1].on_hold_until'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'content-type', 'application/json'
DECLARE @resp int
EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://api.razorpay.com/v1/orders', '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'
-H "content-type: application/json"
-d '{
"amount": 200,
"payment_capture": 1,
"currency":"INR",
"transfers": [
{
"account": "acc_id",//Please replace with appropriate ID.
"amount": 100,
"currency": "INR",
"notes": {
"branch": "Acme Corp Bangalore North",
"name": "Gaurav Kumar"
},
"linked_account_notes": [
"branch"
],
"on_hold": true,
"on_hold_until": 1691222870
},
{
"account": "acc_id",//Please replace with appropriate ID.
"amount": 100,
"currency": "INR",
"notes": {
"branch": "Acme Corp Bangalore South",
"name": "Saurav Kumar"
},
"linked_account_notes": [
"branch"
],
"on_hold": false,
"on_hold_until": null
}
]
}'
https://api.razorpay.com/v1/orders
Postman Collection Item JSON
{
"name": "Transfer via Orders",
"request": {
"method": "POST",
"header": [
{
"key": "content-type",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"amount\": 200,\n \"payment_capture\": 1,\n \"currency\":\"INR\",\n \"transfers\": [\n {\n \"account\": \"acc_id\",//Please replace with appropriate ID.\n \"amount\": 100,\n \"currency\": \"INR\",\n \"notes\": {\n \"branch\": \"Acme Corp Bangalore North\",\n \"name\": \"Gaurav Kumar\"\n },\n \"linked_account_notes\": [\n \"branch\"\n ],\n \"on_hold\": true,\n \"on_hold_until\": 1691222870\n },\n {\n \"account\": \"acc_id\",//Please replace with appropriate ID.\n \"amount\": 100,\n \"currency\": \"INR\",\n \"notes\": {\n \"branch\": \"Acme Corp Bangalore South\",\n \"name\": \"Saurav Kumar\"\n },\n \"linked_account_notes\": [\n \"branch\"\n ],\n \"on_hold\": false,\n \"on_hold_until\": null\n }\n ]\n}"
},
"url": {
"raw": "https://api.razorpay.com/v1/orders",
"protocol": "https",
"host": [
"api",
"razorpay",
"com"
],
"path": [
"v1",
"orders"
]
},
"description": "You can set up a transfer of funds when creating an order using the Orders API. This can be done by passing the `transfers` parameters as part of the Order API request body.\n\nKnow more about this [API](https://razorpay.com/docs/api/route/#create-transfers-from-orders)."
},
"response": [
]
}
