URL parameter to show more lines in a report

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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?
Photo of Mark Winter

Mark Winter

  • 252 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
&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...
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
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