python-airtable 0.5

Python module for accessing Airtable (largely based on the original airtable-python-wrapper).

Python Airtable

This is a Python module for accessing Airtable largely based on the original airtable-python-wrapper by Gui Talarico with some modifications.

Installing

pip install python-airtable

Documentation

Thee original full documentation is available here.

Usage Example

from airtable import Airtable

# We updated the signature of `Airtable` class to support `airtable://` scheme URLs along with `view` and `sort` supported within the URLs.
airtable = Airtable('airtable://app1234567890/table_name?view=My%20View&sort=ID')

for record_id, fields in airtable.iter_records():
    print(f'Record ID: {record_id}, Fields: {fields}')

# Now you can get all the Airtable records as a big dictionary with record ID as keys
airtable.get_all_as_dict()

airtable.insert({'Name': 'Brian'})

# We added `batch_insert` and support generators for the records arguments; chunking of records to 10 each is done automatically.
airtable.batch_insert([record1, record2, ...])
airtable.batch_update([(id1, record1), (id2, record2), ...))  # same for batch_update

airtable.search('Name', 'Tom')

airtable.update_by_field('Name', 'Tom', {'Phone': '1234-4445'})

airtable.delete_by_field('Name', 'Tom')