Airtable

Interact with Airtable app

Don't feel like reading the doc πŸ˜… ? Get started with this 3min video.

Find below is their official websiteπŸ‘‡

apikey should be generated in your account :

You should find it there:

Screenshot of account API section

Then go to :

and choose the workspace you wanna connect and on the Authentication section, you should see :

Screenshot of official doc

database_key is the value between v0/ and /

table_name is the value after the last /

Get

from naas_drivers import airtable
api_key = "******"
db_key = "appuBFPzX94pEqXUJ"
table = "Opportunities"
view = "MyView" # the name of your view in airtable
data = airtable.connect(api_key, db_key, table).get(view=view, maxRecords=20)

Send

from naas_drivers import airtable
api_key = "******"
db_key = "appuBFPzX94pEqXUJ"
table = "Opportunities"
view = "MyView" # the name of your view in airtable
data = airtable.connect(api_key, db_key, table).send({'Name': 'Brian'})

Search

from naas_drivers import airtable
api_key = "******"
db_key = "appuBFPzX94pEqXUJ"
table = "Opportunities"
view = "MyView" # the name of your view in airtable
data = airtable.connect(api_key, db_key, table).search('Name', 'Tom')

Update

from naas_drivers import airtable
api_key = "******"
db_key = "appuBFPzX94pEqXUJ"
table = "Opportunities"
view = "MyView" # the name of your view in airtable
data = airtable.connect(api_key, db_key, table).update_by_field('Name', 'Tom', {'Phone': '1234-4445'})

Delete

from naas_drivers import airtable
api_key = "******"
db_key = "appuBFPzX94pEqXUJ"
table = "Opportunities"
view = "MyView" # the name of your view in airtable
data = airtable.connect(api_key, db_key, table).delete_by_field('Name', 'Tom')

Connect

You can also save your connection and don't repeat it for each method.

from naas_drivers import airtable
api_key = "******"
db_key = "appuBFPzX94pEqXUJ"
table = "Opportunities"
view = "MyView" # the name of your view in airtable
data = airtable.connect(api_key, db_key, table)
data = at.get(view='MyView', maxRecords=20)

Official documentation