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


Please, login to QuintaDB to be able to post comments
Share the discussion in the social networks: