Introduction:
I have a table with 547 records. The “Get Row row Number” block works well with a record number less than or equal to 100, otherwise it does absolutely nothing.
I searched Airtable and it doesn’t seem to be a restriction by the free plan. Nor a limit on the API. Has anyone experienced the same and knows the cause?
I explain what I’m doing:
I use “Get column column Name” to retrieve all the codes from the table and store them in a list called “studentList”. No problem, the block works very well and brings me a list with the 547 records.
I look for a code in the “studentList” list and locate its index. There’s no problem here either
If the variable “recordNumber” is greater than 100, nothing happens, no error message is shown either.
If the variable “recordNumber” is less than or equal to 100, success!
I have used both means and of course the result is the same.
I think the problem has something to do with what I found in the Airtable API.
maxRecordsnumber optional
The maximum total number of records that will be returned in your requests. If this value is larger than pageSize (which is 100 by default), you may have to load multiple pages to reach this total. See the Pagination section below for more.
pageSizenumber optional
The number of records returned in each request. Must be less than or equal to 100. Default is 100. See the Pagination section below for more.
That’s right, I only retrieve one record in each query. In this situation 100 is the key number that is also mentioned in the API, although I do not see why it would cause a problem.