API_DoQuery options skip-n being ignore

Question

I'm implementing pagination for queries through the API using the API_DoQuery action and the skip-n and num-n options. For my queries, the API is ignoring the skip-n option.

The following call returns >3800 records:

https://<companyurl>.quickbase.com/db/<dbid>?a=API_DoQuery&apptoken=%27<apptoken>%27&usertoken=%27<usertoken>%27&query={226.EX.%27XYZ%27}AND{42.EX.1}AND{358.EX.%27WXYZ%27}&clist=3

To paginate, I use the options skip-n and num-n. But the following API calls return the exact same 500 records:

https://<companyurl>.quickbase.com/db/<dbid>?a=API_DoQuery&apptoken=%27<apptoken>%27&usertoken=%27<usertoken>%27&query={226.EX.%27XYZ%27}AND{42.EX.1}AND{358.EX.%27WXYZ%27}&clist=3&options=num-500.skip-0

https://<companyurl>.quickbase.com/db/<dbid>?a=API_DoQuery&apptoken=%27<apptoken>%27&usertoken=%27<usertoken>%27&query={226.EX.%27XYZ%27}AND{42.EX.1}AND{358.EX.%27WXYZ%27}&clist=3&options=num-500.skip-500

https://<companyurl>.quickbase.com/db/<dbid>?a=API_DoQuery&apptoken=%27<apptoken>%27&usertoken=%27<usertoken>%27&query={226.EX.%27XYZ%27}AND{42.EX.1}AND{358.EX.%27WXYZ%27}&clist=3&options=num-500.skip-3500

That is, the skip-n option seems to be completely ignored, but the num-n option is not, as only 500 records are returned with each of the queries. Also, if I reverse the order of the options and put skip-n first (i.e. "options=skip-500.num-500"), nothing changes. Anyone have any ideas? Thx.

------------------------------
Brian Yarrington
------------------------------

BrianYarrington · Answer

Never mind.  No sooner had I posted this than realized there is no "i" in the skip option.  It's working fine now.------------------------------Brian Yarrington------------------------------

Sign up

Login to the community