Hi, I have dreamfactory 1.5.9 running on my debian machine. I attached a mysql database and use several tables via rest api. Now I discovered one problem. I have one table which has 1097 records. I want to fetch them in one step, the problem is, that I only get 1000 records. It seems that there is…

It is possible to fetch more that 1000 records at a time. The default setting (1,000) is in place so users do not accidentally call an exceedingly large number of records with a single call, and potentially crash a browser or other client. You can change this setting on a case-by-case basis by navi…

Hi Rainer, Yes, that value is easy to override. In the config/common.config.php file, just change the value of ‘dsp.db_max_records_returned’. // change the value here 'dsp.db_max_records_returned' => 1000

Hi Ben, thanks for the Info. After searching a while, I already found this setting and it works perfect. Thanks, Rainer

Hi Ben, Just now I’m facing same issue to get more then 1000 Records. But I’m using Dreamfactory 2.1.0, How can i Fix it??

[image] benbusse: In the config/common.config.php file, just change the value of ‘dsp.db_max_records_returned’. // change the value here ‘dsp.db_max_records_returned’ => 1000 Did you try changing db_max_records_returned?

Hi Ben, Happy to See your Reply, In Dreamfactory 2.1.0 there is no config/common.config.php file. That’s why I got Confused. After that I got solution from your clue. (i.e) Override code like below in bootstrap/cache/config.php array ( ‘max_records_returned’ => 10000, Thanks for Your Support…

Hi Ben, Also I found a blocker issue that is, I was successfully created the SQL DB in Dreamfactory. After that If I add new table or add a new column in the existing table in phpmyadmin that not reflect in created service(api_doc) for your reference: DB name: Test->add new table(user) Service n…

DreamFactory caches the database schema, so if you change it in PhpMyAdmin you need to clear the cache to see the changes in DreamFactory. Go to the Config tab in the admin console and select Cache then click the ‘Flush System-Wide Cache’ button. After that you should see the changes reflected in …

If you’re doing this programmatically, you can also refresh the schema of a service by calling service_name/_schema?refresh=true

Hi Todd & Drew Thanks For Quick Response, It’s Really Working Fine… Thanks for your Support!

Hi Ben, I’m using DreamFactory Version: 2.1.1 and hit this issue while trying to fetch more than 1000 rows from an Oracle DB. I included the count parameter in the API call and it listed the total number of records (currently a little above 41,000 Records) as well as the actually number of fetched …

Fetch more than 1000 records in one step

Connecting to SQL

benbusse March 15, 2016, 5:21pm 5

Did you try changing db_max_records_returned?

Is there is any way to get the unlimited row from the Database?

Topic		Replies	Views
Fetch more than 1000 records in one api call REST API	1	1907	October 29, 2018
Changing max_records_returned doesn't have any effect on returned data REST API	1	2219	January 4, 2016
Limit pagination json return REST API	3	2760	October 4, 2022
Maximum Records of Cassandra CRUD REST API App Configuration	1	1601	July 17, 2018
Db limited to 1000 records, again Schema & Data	6	1920	May 15, 2018

Fetch more than 1000 records in one step

Related topics