Airtable | Everyone's app platform

apikey should be generated in your account :

Airtable | Everyone's app platform

Then go to their REST API documentation and choose the workspace you wanna connect and on the Authentication section, you should see :

database_key is the value between v0/ and /

table_name is the value after the last /

REST API - Airtable

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')

Tip

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