Forum Discussion

PraharshaK's avatar
PraharshaK
Qrew Member
2 years ago

How to get the data of "List All" reports across all tables or a single table using Quickbase API

Hi, I'm trying to get "List All" data of a table and then later of all tables available through Quickbase HTTP API. I cannot use the JSON RESTful API as that doesn't have a way to authenticate using username and password but directly with user token, which I do not want to use.

Can someone help me get this data through Quickbase HTTP documentation?



------------------------------
Praharsha K
------------------------------
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    2 years ago

    If you want the actual "List All" report in Quikbase, you can perform a doQuery using the HTTP API and instead of providing a strict query pass in qid=1. So: 

    /dbid?a=API_DoQuery&qid=1

    If you want a true unfiltered download of all fields in your table, you could do: 

    /dbid?a=API_DoQuery&clist=a

    You are not required to provide any kind of query parameter and in place it will return all records and clist=a returns all fields



    ------------------------------
    Chayce Duncan
    ------------------------------