airtable-python
airtable-python is an API wrapper for Airtable, written in Python
- Use this library if you are interested in Oauth authentication and webhook notifications.
Installing
pip install airtable-python
Usage
from airtable.client import Client
client = Client(client_id, client_secret, redirect_uri, code_verifier)
Note: If you already have an access token, you can initiate Client without any parameters and directly set token with the access token you have as a dictionary client.set_token({"access_token": token})
Get access_token
To get the access token using Oauth2 follow the next steps. Check https://airtable.com/developers/web/api/oauth-reference for more info:
- Get authorization URL to receive code
url = client.authorization_url(state)
- Get access token using code
token = client.token_creation(code)
- Set access token
client.set_token(access_token)
If your access token expired, you can get a new one using refresh_token:
response = client.refresh_access_token(refresh_token)
And then set access token again...
Get current user
user = client.get_current_user()
List Bases
bases = client.list_bases()
List Tables
tables = client.list_base_tables(baseId)
List records
records = client.list_records(
baseId,
tableId,
pageSize=None,
maxRecords=None,
filter_field=None,
filter_value=None,
sort_field=None,
sort_direction=None
)
# baseId and tableId are required
# sort_direction options are 'desc' or 'asc'
Create Records
records = [
{
"fields": {
"Projects": "Project from python",
"Status": "In progress",
"Complete?": False
}
},
]
records = client.create_records(baseId, tableId, records)
Update Record
data = {
"Status": "Complete",
"Complete?": True
}
record = client.update_record(baseId, tableId, recordId, data)
Update Multiple Records
records = [
{
"id": "recB4UscNECOHnT7y",
"fields": {
"Number": 10000,
},
},
{
"id": "recFkktx671jlvyj8",
"fields": {
"Number": 20000,
},
},
]
updated_records = client.update_record(baseId, tableId, records)
List Collaborators (needs enterprise scopes access)
collabs = client.list_collaborators(baseId)
Metadata
Release files for airtable-python 0.1.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| airtable_python-0.1.1.tar.gz | 4.5 kB | Without provenance | Details for airtable_python-0.1.1.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| airtable_python-0.1.1-py3-none-any.whl | Python 3 | none | any | Details for airtable_python-0.1.1-py3-none-any.whl |
Total release size: 9.9 kB
Release files / airtable_python-0.1.1.tar.gz
| Download URL | airtable_python-0.1.1.tar.gz |
|---|---|
| Size | 4.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
5dc6e5be6c2422bc187831e89635bd686c666258f72f2b69515a4df29f873ef7
|
|
BLAKE2b-256 checksum How to use checksums |
61ac909f9da9b21bc1d179183de254c4c188cada687156a0e33d66c5fde0dba2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.10.9
|
Release files / airtable_python-0.1.1-py3-none-any.whl
| Download URL | airtable_python-0.1.1-py3-none-any.whl |
|---|---|
| Size | 5.4 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
9da8a08575b8f91f22de33699159ca68e297ee5392a2eb4e65f1ceb2c4f9805a
|
|
BLAKE2b-256 checksum How to use checksums |
0abd68399f71ce61fb35db8dda6a17796686b0e0c13a326edddd88391b280a4f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.10.9
|
Security for airtable-python 0.1.1
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.