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