Need help: Appwrite API stuck at 25 results (cannot export full data)
Hi! I need help urgently.
I’m trying to export all users/documents from my Appwrite Cloud project, but the API always returns only the first 25 items. Pagination is completely ignored.
Details:
- Project ID: 66ebc361002d14664f07
- Database ID: 66f2733500073163a8fb
- Collection ID: 66f27b12001822f1182c
- I have created a Project API Key with FULL permissions (“Select All”).
What I tried:
- limit(100), offset(100)
- queries[] syntax
- cursorAfter() pagination
- Recreating API key
- Using the Databases API and Users API
But every request always returns the same first 25 documents only.
Example:
GET /databases/{db}/collections/{col}/documents?limit=100
→ still returns only the same 25 items.
It looks like my API key scopes are not being applied or pagination is not working for this project.
I have around ~3,631 records in the table and need to export all of them.
Can you please:
- Refresh/repair the API key scopes for my project, OR
- Tell me if something is wrong on the backend, OR
- Provide a way to download a full database export/backup?
Thanks!
Are you using an SDK? The pure HTML example you shared doesn't use the correct syntax for changing the limit.
See some examples here: https://appwrite.io/docs/apis/rest#queries
