[ckan-dev] CKAN datastore API number of records limited to 1500

Helena Lindén helena.linden at softronic.se
Mon May 5 09:13:53 UTC 2014


Hi,
I have uploaded a .xls file as a dataset resource to my ckan instance and have no problem downloading it with its full content.The problem is that in the preview table only the first 1500 rows shows up (the file contains 23 000 rows). The same problem occurs when fetching records from ckan datastore API.
The following request returns the first 1500 records (as expected):{domain url}/api/3/action/datastore_search?limit=1500&resource_id=413f4b95-a49c-4ae2-a6e2-1c9a8d2ab984
But when I try to find the next 1500 records, none are returned!{domain url}/api/3/action/datastore_search?offset=1500&limit=1500&resource_id=413f4b95-a49c-4ae2-a6e2-1c9a8d2ab984
My question: is there a limit of number of record that can be uploaded to the datastore? I have found no information on this on ckan.org, the official documentation (http://docs.ckan.org/en/latest/) or in the mailing list (https://lists.okfn.org/mailman/listinfo/ckan-dev). Is there any configuration that can be made?
I have a CKAN 2.1 installation.
Thanks! 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140505/a1764e08/attachment-0002.html>


More information about the ckan-dev mailing list