Razorpay v1
Razorpay ETL connector for data replication
Snapshot
Features
Details
Release Status
Beta
Source API Version
v1
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
API Key API Secret
Replication Type
Key Based Replication
Replication Key
Date
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
Payments
Orders
Refunds
Settlements
Integrate RazorPay with Daton
Signin to Daton
Select RazorPay from Integrations page
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide API Key and API Secret to authorize Daton to periodically extract data from RazorPay
Post successful authentication, you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
Workflow
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
RazorPay Data
Payments
Purpose: Retrieve multiple payments
Source API Documentation https://docs.razorpay.com/docs/payments
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
STRING
entity
STRING
amount
NUMERIC
currency
STRING
status
STRING
order_id
STRING
invoice_id
STRING
international
BOOLEAN
method
STRING
amount_refunded
NUMERIC
refund_status
STRING
captured
BOOLEAN
description
STRING
card_id
STRING
bank
STRING
wallet
STRING
vpa
STRING
STRING
contact
STRING
error_code
STRING
error_description
STRING
fee
NUMERIC
tax
NUMERIC
created_at
NUMERIC
Orders
Purpose: Retrieve Orders
Source API Documentation https://docs.razorpay.com/docs/orders
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
STRING
entity
STRING
amount
NUMERIC
amount_paid
NUMERIC
amount_due
NUMERIC
currency
STRING
receipt
STRING
offer_id
STRING
status
STRING
attempts
NUMERIC
created_at
NUMERIC
Refunds
Purpose: Retrieve list of refunds
Source API Documentation https://docs.razorpay.com/docs/refunds
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
STRING
entity
STRING
amount
NUMERIC
currency
STRING
payment_id
STRING
receipt
STRING
created_at
NUMERIC
Settlements
Purpose: Retrieve list of settlements
Source API Documentation https://docs.razorpay.com/docs/settlements
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
STRING
entity
STRING
amount
NUMERIC
status
STRING
fees
NUMERIC
tax
NUMERIC
utr
STRING
created_at
NUMERIC
Last updated