Skip to main content
Solved

API_GenResultsTable Only Returns 199 records

  • December 30, 2019
  • 0 replies
  • 78 views
Forum|alt.badge.img+5
I use the API_GenResultsTable in a CSS page to pull all applicable records to show in a matrix. This report was working and now is not. The URL used is

https://<Target Domain>.quickbase.com/db/<Target DB>?a=API_GenResultsTable&qid=92&jsa=1&option=num-800

This report should return 414 records. It is now only returning 199 records which (I believe) is the default without the option=num-800 records

Anyone have any insight on this problem?   I opened a Support Case with QuickBase Support, but they are taking forever to respond.

What changed in this API call? I double checked the API Guide for this and it has not changed with regards to "option=num-n" description.

------------------------------
Jeff Mickelsen
------------------------------

Best answer by QuickBaseJunkie

Hi Jeff!

Looking at my personal notes on the API_GenResultsTable, I noticed a small difference from the URL you provided. My notes indicate the use of "options" and not "option" as you've written here.

I double checked in my own QB and when only using "option" I also get 199 records, vs when I used "options" I got all 800.

Let me know if that resolves the issue for you 😀👍

–Sharon

------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
This topic has been closed for replies.

QuickBaseJunkie
Forum|alt.badge.img+15
  • QuickBaseJunkie
  • Quickbase Alumni
  • Answer
  • January 1, 2020
Hi Jeff!

Looking at my personal notes on the API_GenResultsTable, I noticed a small difference from the URL you provided. My notes indicate the use of "options" and not "option" as you've written here.

I double checked in my own QB and when only using "option" I also get 199 records, vs when I used "options" I got all 800.

Let me know if that resolves the issue for you 😀👍

–Sharon

------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
    Terms & ConditionsAccessibility statement