RestAPI query is send twice if server-side pagination is enabled

Hi everyone,

i am relatively new to retool, so i am not sure if its on me or a bug.
If i use server-side pagination on an table with a restAPI enpoint as the source, the query is send twice:

if i use static values for "size" and "page" its run only once.
tried to set run behavior on manual but it does not help.

Any idea?

I noticed the query is only send twice if the reruned number of rows is samller than "Page size" for pagination. If i switch between two views (different "location") the query is only triggered once.

Hey @edni Welcome to the community,

For implementing pagination, you might find this forum thread helpful Forum

If you need any further assistance, feel free to reach out—I’m happy to help!
Let me know if you'd like a more casual or more formal version too.

4 Likes

Is this the expected behaviour you want or need help still?