- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 26, 2024 10:53 PM
i have a airtable with links its 110 in number in airtable but when i use api to access those links i am getting only 100. rest 10 are missing when i use the api What might be the reason i have provided two pics one of data table and one is my code .
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 27, 2024 11:12 AM
any help please ?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 27, 2024 11:15 AM
Getting a list of records using the API will return a max of 100 records per call. You have to use the returned offset value to paginate through the rest of the results.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 27, 2024 12:10 PM
hello, thank you how can i do it ? Can you give me an example or reference to follow

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 27, 2024 03:09 PM
Everyone does it a bit differently, but I would suggest writing a function with a “while” loop that runs until there is no offset value returned. Each iteration calls the api with an endpoint including the offset from the previous call, and pushes the results into an array. That array should be defined before you enter the loop.
I am on my phone but later I can share some sample JavaScript I wrote to do exactly this (not sure what language you need, but it should get you pretty close).
You could also try checking out stackoverflow for examples of code - search something like “loop through paginated api results”.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 27, 2024 10:42 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 27, 2024 10:50 PM
Basically my data is like this i am grabbing the record as dict key, as i am using python, the looping to get deal link . as i am grabbing the whole record shouldn't it have all the data from the table , my code is in top opening post
