English Flag English Italiano Flag Italiano Español Flag Español Français Flag Français Deutsch Flag Deutsch Português Flag Português Ελληνικά Flag Ελληνικά Nederlands Flag Nederlands Polski Flag Polski Čeština Flag Čeština 中文 Flag 中文 日本語 Flag 日本語 हिन्दी Flag हिन्दी اللغة العربية Flag اللغة العربية Русский Flag Русский Українська Flag Українська עִברִית Flag עִברִית Türk Flag Türk Latvietis Flag Latvietis Dansk Flag Dansk Norsk Flag Norsk Íslenska Flag Íslenska 한국어 Flag 한국어 Suomen Flag Suomen Gaeilge Flag Gaeilge Bahasa Melayu Flag Bahasa Melayu Svenska Flag Svenska
User IconLog In
English Flag English

Log In

 

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.