English Flag English
  

The reliable home for your data

How to get 15 000 records from a database with a single API call

Video tutorial

The QuintaDB service offers a unique opportunity - retrieving 15,000 records using one API call.

This feature will greatly expand the potential of your business application!

 

It is enough to add the fetch_all: true parameter, which will increase the maximum number of records (up to 15 000) on one page. The number of records must be passed in the per_page parameter. This functionality is only available for paid accounts.

Request and URL example:

URL: /apps/APP_ID/dtypes/entity/ENTITY_ID.json


Request body:
{"rest_api_key":"API_KEY",
"page": 1,
"fetch_all": true,
"per_page": 15000}

Notation:

APP_ID - database identifier. You can find ID using Fetch All Databases call. Once you know it, you'll need to add this ID to URL in the link below, i.e. change /apps/ID.json to /apps/aOWO_dVXHdHie1WeGFE8k2.json

ENTITY_ID - form identifier. You can find ID using Fetch All Forms call. Once you know it, you'll need to add this ID to URL in the link below, i.e. change /apps/APP_ID/entities.json to /apps/aOWO_dVXHdHie1WeGFE8k2/entities.json

page - records page number. From 1 to Table Records count/per_page.

Method used - GET

 

Restrictions on the maximum number of entries by plans:

FREE - 200
STANDARD - 500
PROFESSIONAL - 1000
ENTERPRISE - 2000
STANDARD EXPRESS - 4000
PROFESSIONAL EXPRESS - 8000
ENTERPRISE EXPRESS - 15000

This option will help you get records in your own applications and with Adalo and Integromat services integrations.


Explore all features