- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 08, 2023 08:07 AM
Hello. I have been using an API token (the original method) for authenication to get records from a particular table. I have been using the 'airtable' Python library to do this. We are now switching to use a personal access token (PAT) because the API token authentication method is going away. So, I can no longer use the 'airtable' Python library because it doesn't support PATs. So, I am simply using the 'requests' Python library this time around. For whatever reason, I have a handful of columns that will not download when using the 'requests' Python library with my PAT. However, I can download these columns when using the 'airtable' Python library and my API token. Below is my code. In the field list, I put a comment to denote the fields that won't download when I run my code. These columns just don't appear in my final downloaded file. Is there something I'm missing? Or is there a better library that I should be using? Thanks!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 09, 2023 02:12 PM
Are you sure you can't use the PAT? In all of my integrations, I simply swapped the API key for the token.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2023 05:06 AM
So I messed up! You are correct, I can use the PAT with the Airtable Python libary. I wish I had figured that out sooner! Haha!!! Thanks for responding though! I appreciate it!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2023 05:08 AM
However, I do find it strange that using the requests library, I was unable to get the same results as when using the Airtable library. The results usign the requests library had slighty more records (around a hundred or so) and a couple columns would not come through. ??

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 10, 2023 08:43 AM
Yes that is strange, although it's hard for me to give an explanation without directly working with your code.
