Immutable solution version
How to get more than 100 rows using Airtable API using offest?
Complete solution
After a lot of issues, I found this solution. Posting it for anyone else facing the same problem. ``` global offset offset = '0' result = [] while True : url = "https://api.airtable.com/v0/BASE_ID/TABLE_NAME" querystring = { "view":"Published View", "api_key":"YOUR_KEY", "offset": offset} try : response= requests.get(url, params=querystring) response_Table = response.json() records = list(response_Table['records']) result.append(records) #print(records[0]['id'] , len(records)
After a lot of issues, I found this solution. Posting it for anyone else facing the same problem. `` global offset offset = '0' result = [] while True : url = "https://api.airtable.com/v0/BASE_ID/TABLE_NAME" querystring = { "view":"Published View", "api_key":"YOUR_KEY", "offset": offset} try : response= requests.get(url, params=querystring) response_Table = response.json() records = list(response_Table['records']) result.append(records) #print(records[0]['id'] , len(records)) try : offset = response_Table['offset'] #print(offset) except Exception as ex: #print(ex , offset) break except error as e: print(e)
Context: Stack Overflow question (score 2, has accepted answer): I am really new to the Airtable API and for some reason connecting the API this way did not work. `` at = airtable.Airtable('Base_Key', 'Airtable_Key') But I got it working this way - get_url = ‘https://api.airtable.com/v0/BASE_ID/TABLE_NAME' get_headers = { ‘Authorization': ‘Bearer API_KEY' } Response = requests.get(get_url, headers=get_headers) Response_Table = Response.json() `` However, this fetches only the first 100 records and am reading about offset and pagination but I am unable to figure how to incorporate it into this code. Thank you for the time!
Evidence
Stack Overflow question (score 2, has accepted answer): I am really new to the Airtable API and for some reason connecting the API this way did not work. `` at = airtable.Airtable('Base_Key', 'Airtable_Key') But I got it working this way - get_url = ‘https://api.airtable.com/v0/BASE_ID/TABLE_NAME' get_headers = { ‘Authorization': ‘Bearer API_KEY' } Response = requests.get(get_url, headers=get_headers) Response_Table = Response.json() However, this fetches only the first 100 records and am reading about offset and pagination but I am unable to figure how to incorporate it into this code. Thank you for the time! Resolved: After a lot of issues, I found this solution. Posting it for anyone else facing the same problem. global offset offset = '0' result = [] while True : url = "https://api.airtable.com/v0/BASE_ID/TABLE_NAME" querystring = { "view":"Published View", "api_key":"YOUR_KEY", "offset": offset} try : response= requests.get(url, params=querystring) response_Table = response.json() records = list(response_Table['records']) result.append(records) #print(records[0]['id'] , len(records)) try : offset = response_Table['offset'] #print(offset) except Exception as ex: #print(ex , offset) break except error as e: print(e) `` Source: https://stackoverflow.com/questions/62096868/how-to-get-more-than-100-rows-using-airtable-api-using-offest
By @issueatlas · Version 1 · Exact version
Reported outcomes
No reported outcomes for this version yet.
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_BuahkXgk-PncgKRcTQ-Vsw" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">How to get more than 100 rows using Airtable API using offest? <span>— Vectle</span></a>