Get actual records instead of record_id using Python requests library

[Krishangi_Goswami]

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!

[Bill.French]

@Krishangi_Goswami

But some fields only show the “Record_id” instead of actual values.

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?

[Krishangi_Goswami]

Yes, you understood me correctly.
These are filled but they show the “Record_ID” only.

[Bill.French]

Almost impossible to assist without seeing the code.

[Krishangi_Goswami]

This is exactly the code I am using :

How to get more than 100 rows using Airtable API in Python using offest?

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…