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:
Then go to :
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 /
from naas_drivers import airtableapi_key = "******"db_key = "appuBFPzX94pEqXUJ"table = "Opportunities"view = "MyView" # the name of your view in airtabledata = airtable.connect(api_key, db_key, table).get(view=view, maxRecords=20)
from naas_drivers import airtableapi_key = "******"db_key = "appuBFPzX94pEqXUJ"table = "Opportunities"view = "MyView" # the name of your view in airtabledata = airtable.connect(api_key, db_key, table).send({'Name': 'Brian'})
from naas_drivers import airtableapi_key = "******"db_key = "appuBFPzX94pEqXUJ"table = "Opportunities"view = "MyView" # the name of your view in airtabledata = airtable.connect(api_key, db_key, table).search('Name', 'Tom')
from naas_drivers import airtableapi_key = "******"db_key = "appuBFPzX94pEqXUJ"table = "Opportunities"view = "MyView" # the name of your view in airtabledata = airtable.connect(api_key, db_key, table).update_by_field('Name', 'Tom', {'Phone': '1234-4445'})
from naas_drivers import airtableapi_key = "******"db_key = "appuBFPzX94pEqXUJ"table = "Opportunities"view = "MyView" # the name of your view in airtabledata = airtable.connect(api_key, db_key, table).delete_by_field('Name', 'Tom')
You can also save your connection and don't repeat it for each method.
from naas_drivers import airtableapi_key = "******"db_key = "appuBFPzX94pEqXUJ"table = "Opportunities"view = "MyView" # the name of your view in airtabledata = airtable.connect(api_key, db_key, table)data = at.get(view='MyView', maxRecords=20)
Last updated 3 months ago