Skip to main content
Question

API Record Limits In Python

  • April 30, 2021
  • 0 replies
  • 147 views

We seem to be limited to only getting 500 records at a time on our API calls.
Any suggestions?

api = qb.QuickBaseApiClient(user_token='TOKEN', realm_hostname='companyname.quickbase.com')
response = api.query(
    table_id='bmhgaf4uj',
    fields_to_select=["35", "34", "26", "3", "1", "2" ], 
    where_str=where_str_var, 
    sort_by=[3]
    )

data = response.json()


------------------------------
Chris Anderson
------------------------------
This topic has been closed for replies.

Hey Chris,

Quickbase uses pagination in their API. This means that you need to write your code to make multiple calls to the API to get all of the records you are looking for.

https://developer.quickbase.com/pagination

I have written some code, in javascript (with the help of a software developer on stackoverflow), to make multiple calls to the API until I have received all of the records. Please see the answer to the stack overflow question I posted. This should help you understand what you need to do in order to make additional API calls. Unfortunately it is in Javascript so it does not 100% answer your question.

https://stackoverflow.com/questions/66820192/how-to-parse-paginated-json-api-response-with-complex-nesting-and-unnamed-array

------------------------------
Matthew Lysinger
------------------------------