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:

1. Refresh/repair the API key scopes for my project, OR
2. Tell me if something is wrong on the backend, OR
3. 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

I tried again on Windows PowerShell and I am still getting the same error.

PowerShell on Windows does NOT support System.Web.HttpUtility, so I used the raw query as the docs show:

GET https://cloud.appwrite.io/v1/databases/66f2733500073163a8fb/collections/66f27b12001822f1182c/documents?queries[]=limit(100)

But Appwrite returns this error directly from the API:

{"message":"Invalid queries param: Value must a valid array no longer than 100 items and Value must be a valid string and at least 1 chars and no longer than 4096 chars","code":400}

This means the server is rejecting queries[]=limit(100) even though this is the exact syntax shown in the Appwrite REST docs.

So the issue is not my client code — the API itself is not accepting the queries[] parameter for this project.

Can you please check if the queries parser or scope validation is broken on my project?

Project ID: 66ebc361002d14664f07
DB ID: 66f2733500073163a8fb
Collection ID: 66f27b12001822f1182c

Look at the docs linked. What you're passing does not match the docs