Solved
API_GenResultsTable Only Returns 199 records
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
------------------------------
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
------------------------------
- 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
------------------------------
