API Record Limits In Python

Question

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

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

data&nbsp;=&nbsp;response.json()

------------------------------Chris Anderson------------------------------

matthewlysinger · Answer

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

chrisanderson · Answer

Thanks Matthew. Very helpful.

Forum Discussion

API Record Limits In Python

2 Replies

Related Content

Calculation/Performance Limits Inquiry

Kanban records per column limit

Duplicate Record Checker

Custom Record Titles

Record limit when searching table