Razorpay
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

  1. 1.
    Signin to Daton
  2. 2.
    Select RazorPay from Integrations page
  3. 3.
    Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
  4. 4.
    Provide API Key and API Secret to authorize Daton to periodically extract data from RazorPay
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 1.
    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
  2. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 3.
    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
email
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 modified 2yr ago