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. Signin to Daton

2. Select RazorPay from Integrations page

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. Provide API Key and API Secret to authorize Daton to periodically extract data from RazorPay

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

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. Users would be able to edit/pause/re-activate/delete integration anytime

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