Hello Community,
This is how I am getting the records using the Python requests library: How to get more than 100 rows using Airtable API in Python using offest?
But some fields only show the “Record_id” instead of actual values. I hit a wall trying to find solutions to this. How do I resolve this?
Any leads would be appreciated.
Thank you in advance!
I assume you actually meant -
But some records only show the “Record_id” instead of actual fields and their values.
Is it possible you have empty rows in your table?
Yes, you understood me correctly.
These are filled but they show the “Record_ID” only.
Almost impossible to assist without seeing the code.
This is exactly the code I am using :
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.appen…