New, you have a direct, cloud-to-cloud connection to live Airtable data from your Google Sheets workbook. Live Access to Airtable Data from Cloud Applications
#Airtable permissions install#
Log into Google Sheets, create a new sheet (or open an existing one).The steps below outline connecting to CData Connect Cloud from Google Sheets to access live Airtable data. With the connection configured, you are ready to connect to Airtable data from Google Sheets.Īccess Live Airtable Data in Google Sheets
#Airtable permissions update#
Navigate to the Permissions tab in the Add Airtable Connection page and update the User-based permissions.These are the same names of the views as found in the UI. ViewNames : A comma separated list of views in the format of (table.view) names.These are the same names of tables as found in the UI. TableNames : A comma separated list of table names for the selected base.In the introduction section you can find "The ID of this base is appxxN2ftedc0nEG7." Click on Airtable API, or navigate to and select a base. To obtain this value, it is in the same section as the APIKey. To obtain this value, after logging in go to Account. ViewNames is an optional parameter where views of the tables may be specified. Select "Airtable" from the Add Connection panelĮnter the necessary authentication properties to connect to Airtable.ĪPIKey, BaseId and TableNames parameters are required to connect to Airtable.Log into Connect Cloud, click Connections and click Add Connection.Connect to Airtable in Connect CloudĬData Connect Cloud uses a straightforward, point-and-click interface to connect to data sources.
#Airtable permissions trial#
To get started, sign up a free trial of Connect Cloud and install the free Connect Cloud Google Sheets Add-On. Perhaps the error message could give the Field ID that caused the problem, or even better, just give a generic error message that they couldn’t create a row because they included a field that they don’t have editing permissions for.This setup requires a CData Connect Cloud instance and the CData Connect Cloud Add-On for Google Sheets. It would be amazing if Airtable’s error message was more clear about what the real problem was.
I didn’t realize that the problem was that they don’t have permission to edit a specific field that we included in the POST request. It confused me because when I went back into the base to investigate that table, they actually DID have permission to create records in the table! The confusing thing about this error message is that it says that they don’t have permission to create an entire row. Message: insufficient privileges to create row However, what I didn’t realize is that this user didn’t have permission to edit a SPECIFIC FIELD that we needed to include in their POST request.Īs a result of this discrepancy between table creation permissions & field editing permissions, the API returned an error message that said: Status: 403 Forbidden So tonight, I was trying to create a new record via a user’s API Key in a table where the user actually did have permissions to “create records”. But for now, most 3rd-party apps (like Make and Zapier) are still connecting to Airtable’s API via Airtable user accounts. This sort of situation will mostly be resolved when Airtable fully switches over to Personal Access Tokens. I encountered a confusing error message in the Airtable Web API tonight that threw me off for a little bit.
0 kommentar(er)
