Discussions

Expand all | Collapse all

API_GenResultsTable Only Returns 199 records

Jump to Best Answer
  • 1.  API_GenResultsTable Only Returns 199 records

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


  • 2.  RE: API_GenResultsTable Only Returns 199 records
    Best Answer

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



  • 3.  RE: API_GenResultsTable Only Returns 199 records

    Posted 17 days ago
    Great catch.  Thanks for the help.

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



  • 4.  RE: API_GenResultsTable Only Returns 199 records

    Posted 17 days ago
    You're welcome Jeff!

    And thanks for marking my answer!! I think this may be the first time I've noticed a "best answer" indicator 👍

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