Discussions

Expand all | Collapse all

URL parameter to show more lines in a report

  • 1.  URL parameter to show more lines in a report

    Posted 09-20-2017 22:38
    There is a URL parameter that I can't seem to find.  The parameter allows you to specify how many records display in a QuickBase report, thereby removing pages.  Does someone know that parameter?


  • 2.  RE: URL parameter to show more lines in a report

    Top
    Contributor
    Posted 09-21-2017 16:14
    &options=num-n  (where n is the number of records you want displayed)

    is supposed to be the url parameter according to QB API, but I have never been able to get it to work.

    Their API is really outdated and incomplete;

    https://help.quickbase.com/api-guide/index.html#do_query.html%3FTocPath%3DQuick%2520Base%2520API%252...


  • 3.  RE: URL parameter to show more lines in a report

    Top
    Contributor
    Posted 09-22-2017 02:05
    I think &qskip and &grppg are what you are looking for. This URL skips 400 records and returns a set of the next 200 records:

    https://SUBDOMAIN.quickbase.com/db/DBID?a=q&qid=1&qskip=400&qrppg=200

    The analagous API URL to skip 400 records and return a set of the next 200 records would be this:

    https://SUBDOMAIN.quickbase.com/db/DBID?act=API_DoQuery&qid=1&options=num-200.skp-400