Skip to main content
The Razorpay plugin syncs data locally. Use corsair.razorpay.db.<entity>.search({ data, limit?, offset? }) with the filters listed per entity.
New to Corsair? See database operations, data synchronization, and multi-tenancy.

​
Customers

Path: razorpay.db.customers.search 
const rows = await corsair.razorpay.db.customers.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
namestringequals, contains, startsWith, endsWith, in
emailstringequals, contains, startsWith, endsWith, in
contactstringequals, contains, startsWith, endsWith, in
gstinstringequals, contains, startsWith, endsWith, in
created_atnumberequals, gt, gte, lt, lte, in
createdAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

​
Orders

Path: razorpay.db.orders.search 
const rows = await corsair.razorpay.db.orders.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
amountnumberequals, gt, gte, lt, lte, in
amount_paidnumberequals, gt, gte, lt, lte, in
amount_duenumberequals, gt, gte, lt, lte, in
currencystringequals, contains, startsWith, endsWith, in
receiptstringequals, contains, startsWith, endsWith, in
offer_idstringequals, contains, startsWith, endsWith, in
statusstringequals, contains, startsWith, endsWith, in
attemptsnumberequals, gt, gte, lt, lte, in
created_atnumberequals, gt, gte, lt, lte, in
createdAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

​
Payments

Path: razorpay.db.payments.search 
const rows = await corsair.razorpay.db.payments.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
amountnumberequals, gt, gte, lt, lte, in
currencystringequals, contains, startsWith, endsWith, in
statusstringequals, contains, startsWith, endsWith, in
order_idstringequals, contains, startsWith, endsWith, in
invoice_idstringequals, contains, startsWith, endsWith, in
methodstringequals, contains, startsWith, endsWith, in
capturedbooleanequals
descriptionstringequals, contains, startsWith, endsWith, in
emailstringequals, contains, startsWith, endsWith, in
contactstringequals, contains, startsWith, endsWith, in
created_atnumberequals, gt, gte, lt, lte, in
createdAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

​
Refunds

Path: razorpay.db.refunds.search 
const rows = await corsair.razorpay.db.refunds.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
payment_idstringequals, contains, startsWith, endsWith, in
amountnumberequals, gt, gte, lt, lte, in
currencystringequals, contains, startsWith, endsWith, in
receiptstringequals, contains, startsWith, endsWith, in
speed_processedstringequals, contains, startsWith, endsWith, in
speed_requestedstringequals, contains, startsWith, endsWith, in
statusstringequals, contains, startsWith, endsWith, in
created_atnumberequals, gt, gte, lt, lte, in
createdAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

​
Settlements

Path: razorpay.db.settlements.search 
const rows = await corsair.razorpay.db.settlements.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
amountnumberequals, gt, gte, lt, lte, in
feesnumberequals, gt, gte, lt, lte, in
taxnumberequals, gt, gte, lt, lte, in
utrstringequals, contains, startsWith, endsWith, in
created_atnumberequals, gt, gte, lt, lte, in
createdAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

​
Subscriptions

Path: razorpay.db.subscriptions.search 
const rows = await corsair.razorpay.db.subscriptions.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

​
Searchable filters

FieldTypeOperators
entity_idstringequals, contains, startsWith, endsWith, in
idstringequals, contains, startsWith, endsWith, in
plan_idstringequals, contains, startsWith, endsWith, in
customer_idstringequals, contains, startsWith, endsWith, in
statusstringequals, contains, startsWith, endsWith, in
current_startnumberequals, gt, gte, lt, lte, in
current_endnumberequals, gt, gte, lt, lte, in
ended_atnumberequals, gt, gte, lt, lte, in
charge_atnumberequals, gt, gte, lt, lte, in
offer_idstringequals, contains, startsWith, endsWith, in
start_atnumberequals, gt, gte, lt, lte, in
end_atnumberequals, gt, gte, lt, lte, in
auth_attemptsnumberequals, gt, gte, lt, lte, in
quantitynumberequals, gt, gte, lt, lte, in
total_countnumberequals, gt, gte, lt, lte, in
paid_countnumberequals, gt, gte, lt, lte, in
remaining_countnumberequals, gt, gte, lt, lte, in
customer_notifybooleanequals
expire_bynumberequals, gt, gte, lt, lte, in
short_urlstringequals, contains, startsWith, endsWith, in
has_scheduled_changesbooleanequals
change_scheduled_atnumberequals, gt, gte, lt, lte, in
sourcestringequals, contains, startsWith, endsWith, in
created_atnumberequals, gt, gte, lt, lte, in
createdAtdateequals, before, after, between
Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.