Skip to main content
Question

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

  • September 27, 2023
  • 0 replies
  • 186 views

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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+9

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
------------------------------