English Flag English Español Flag Español Deutsch Flag Deutsch Italiano Flag Italiano Polski Flag Polski Nederlands Flag Nederlands Português Flag Português Français Flag Français 中文 Flag 中文 日本語 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 Čeština Flag Čeština
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.