SQL Server / Razorpay APIs / Rename Labels in Payment Details Section
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": 1000,
-- "currency": "INR",
-- "accept_partial": true,
-- "first_min_partial_amount": 100,
-- "reference_id": "#412232",
-- "description": "Payment for policy no #23456",
-- "expire_by": 1599193801,
-- "customer": {
-- "name": "Gaurav Kumar",
-- "contact": "+919999999999",
-- "email": "gaurav.kumar@example.com"
-- },
-- "notify": {
-- "sms": true,
-- "email": true
-- },
-- "reminder_enable": true,
-- "options": {
-- "hosted_page": {
-- "label": {
-- "receipt": "Ref No.",
-- "description": "Course Name",
-- "amount_payable": "Course Fee Payable",
-- "amount_paid": "Course Fee Paid",
-- "partial_amount_due": "Fee Installment Due",
-- "partial_amount_paid": "Fee Installment Paid",
-- "expire_by": "Pay Before",
-- "expired_on": "Link Expired. Please contact Admin",
-- "amount_due": "Course Fee Due"
-- },
-- "show_preferences": {
-- "issued_to": false
-- }
-- }
-- }
-- }
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'amount', 1000
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'currency', 'INR'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'accept_partial', 1
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'first_min_partial_amount', 100
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'reference_id', '#412232'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'description', 'Payment for policy no #23456'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'expire_by', 1599193801
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.hosted_page.label.receipt', 'Ref No.'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.hosted_page.label.description', 'Course Name'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.hosted_page.label.amount_payable', 'Course Fee Payable'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.hosted_page.label.amount_paid', 'Course Fee Paid'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.hosted_page.label.partial_amount_due', 'Fee Installment Due'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.hosted_page.label.partial_amount_paid', 'Fee Installment Paid'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.hosted_page.label.expire_by', 'Pay Before'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.hosted_page.label.expired_on', 'Link Expired. Please contact Admin'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'options.hosted_page.label.amount_due', 'Course Fee Due'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'options.hosted_page.show_preferences.issued_to', 0
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": 1000,
"currency": "INR",
"accept_partial": true,
"first_min_partial_amount": 100,
"reference_id": "#412232",
"description": "Payment for policy no #23456",
"expire_by": 1599193801,
"customer": {
"name": "Gaurav Kumar",
"contact": "+919999999999",
"email": "gaurav.kumar@example.com"
},
"notify": {
"sms": true,
"email": true
},
"reminder_enable": true,
"options": {
"hosted_page": {
"label": {
"receipt": "Ref No.",
"description": "Course Name",
"amount_payable": "Course Fee Payable",
"amount_paid": "Course Fee Paid",
"partial_amount_due": "Fee Installment Due",
"partial_amount_paid": "Fee Installment Paid",
"expire_by": "Pay Before",
"expired_on": "Link Expired. Please contact Admin",
"amount_due": "Course Fee Due"
},
"show_preferences": {
"issued_to": false
}
}
}
}'
https://api.razorpay.com/v1/payment_links/
Postman Collection Item JSON
{
"name": "Rename Labels in Payment Details Section",
"request": {
"method": "POST",
"header": [
],
"body": {
"mode": "raw",
"raw": "{\n \"amount\": 1000,\n \"currency\": \"INR\",\n \"accept_partial\": true,\n \"first_min_partial_amount\": 100,\n \"reference_id\": \"#412232\",\n \"description\": \"Payment for policy no #23456\",\n \"expire_by\": 1599193801,\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 \"hosted_page\": {\n \"label\": {\n \"receipt\": \"Ref No.\",\n \"description\": \"Course Name\",\n \"amount_payable\": \"Course Fee Payable\",\n \"amount_paid\": \"Course Fee Paid\",\n \"partial_amount_due\": \"Fee Installment Due\",\n \"partial_amount_paid\": \"Fee Installment Paid\",\n \"expire_by\": \"Pay Before\",\n \"expired_on\": \"Link Expired. Please contact Admin\",\n \"amount_due\": \"Course Fee Due\"\n },\n \"show_preferences\": {\n \"issued_to\": false\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": "Learn how to customize and rename the labels in the Payment Details section of the Payment Links payment request page using Razorpay API. You can also display labels in a different language, for example, Hindi or Tamil."
},
"response": [
]
}
