Discussions

Expand all | Collapse all

API_DoQuery options skip-n being ignore

  • 1.  API_DoQuery options skip-n being ignore

    Posted 9 days ago
    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
    ------------------------------


  • 2.  RE: API_DoQuery options skip-n being ignore

    Posted 9 days ago
    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
    ------------------------------