Airtable

Open

Airtable is a low-code, easy-to-use online platform that helps to create and share relational databases. This platform provides a simple, friendly, and visual platform that is helpful for building collaborative applications to customize your workflow and collaborate for achieving an effective outcome. This platform connects data, people, and workflows across the organization that allowing each employee to use a single source.

• 1 Authorization
  • 1.1 Basic Auth
  • 1.2 API Key and Base ID
  • 1.3 Oauth 2.0
• 2 Airtable Connections
  • 2.1 Airtable Basic Auth Connections
  • 2.2 Airtable API Key Connections
  • 2.3 Airtable Oauth 2.0 Connection
• 3 Actions
  • 3.1 Create Record In Table
  • 3.2 Create Record for Salesforce Opportunities
  • 3.3 Create Record for Hubspot Deals
  • 3.4 Get Records For Salesforce Users

Authorization

Basic Auth

The Airtable API generally uses API keys to authenticate requests. These requests can be managed and viewed in the Airtable dashboard. The authentication to the API is conducted by the HTTP Basic Auth. To authenticate basic auth for Airtable you need to provide the basic auth username value, you are not needed to provide a password. If you need to authenticate via bearer auth (e.g., for a cross-origin request), use -H "Authorization: Bearer sk_test_4eC39HqLyjWDarjtT1zdp7dc" instead of -u sk_test_4eC39HqLyjWDarjtT1zdp7dc.

All API requests must be made over Http . Calls made over plain HTTP will fail. API requests without authentication will also fail.

curl https://api.stripe.com/v1/charges\-u sk_test_4eC39HqLyjWDarjtT1zdp7dc: # The colon prevents curl from asking for a password.

For more information please visit Airtable Basic

API Key and Base ID

The API key for Airtable allows you to use the public API for creating, fetching, updating, and deleting records based on your access to the platform. This authentication key follows the similar permissions that are required in the Airtable UI account.

The Airtable API key is using a Headers i.e., Bearer key. It consists of various id, fields, and attachments. In the attachments you will be able to get the below information's

• File name

• id

• URL

• Size

• Type

You can also get the list of records along with their specific id’s from the URL. In this field you can ask for sending the API order for the authorization purpose.

Example of authorization URL:

You can get the API key and base id by selecting the specific field. You can get the base id from the documentation.

The metadata API uses token-based authentication like Airtable's standard REST API. You will need to paste their Airtable account's API key (available from your account page) into your integration. Send the API key in the Authorization header of all your requests:

After you receive a client secret from us, you must send an X-Airtable-Client-Secret HTTP header with all your requests to help us identify and authenticate your integration. If you fail to do this, your request will be blocked.

Finally, please perform all requests to these endpoints server-side. Client-side requests are not allowed because they would expose the user's API token.

GEThttps://api.airtable.com/v0/meta/bases

Returns the list of bases the API key can access in the order they appear on the user's home screen, 1000 bases at a time. If there is another page to request, pass the offset as a URL query parameter. (e.g. ?offset=itr23sEjsdfEr3282/appSW9R5uCNmRmfl6)

The Airtable component uses an API key and Base ID for authentication.

• To obtain an API key, log in to Airtable and navigate to https://airtable.com/account. Generate an API key from the Overview page.

• To find your Base ID, visit https://airtable.com/api and select your workspace. The ID of your base is printed in green under the Introduction section of this page.

The more type of field will be added in the future and this will not be considered a breaking change. API consumers are expected to handle unknown field types gracefully.

autoNumber, barcode, button, checkbox, count, createdBy, createdTime, currency, date, dateTime, duration, email, externalSyncSource, formula, lastModifiedBy

lastModifiedTime, multilineText, multipleAttachments, multipleCollaborators, multipleLookupValues

This Airtable API authentication gives you the ability to list all of your bases, tables, fields, and views.

If you want to develop an integration using the Metadata API, you must register here for access and to receive a client secret. Enterprise Airtable accounts do not require a separate Metadata API client secret.

Note that we don't consider adding keys to response objects a breaking change, so the shape of objects may change without notice, but existing keys won't be changed or removed without notice.

This is a single string that is the authentication of the API request, sent in an HTTP “Authorization” header. You can authenticate to the API by providing your API key in the HTTP authorization bearer token header.

• In the Airtbale Datasource Section.

• Select Bearer Token as the authentication type.

• Now, paste your API key and click Save.

You can create queries to fetch, update and delete data from a datasource using the application query editor. Airtable supports the following query methods:

Revoke the Secret

You are not supposed to revel your API key, however, if it get revealed accidentally then you need to regenerate your API key as soon as possible from https://airtable.com/account. You can also delete your API key if required, to do so you need to click on the Delete Key option. Once you click on this option you will get a warning that performing this process will break your API integrations. To proceed further you need to choose the red Yes, click on the delete key button to confirm your key deletion.

For more information visit Airtable Documentation

Oauth 2.0

Most of the API 's are required to do some authorization to secure their authentication process. Generally this process involves entering of API key or token that can function similarly to the passwords. This authentication framework is an alternative way that enable you to securely connect with the third party to their account by minimizing the requirement of manual credentials updating.

You need to select it from the available authentication types to integrate with an Airtable database:

• Airtable API key allows you to use public API to create, fetch, update, and delete records on the bases you have access to the Airtable platform.

• Bearer Tokens are the predominant access token used with OAuth 2.0.

Most APIs require authentication to access their data. This is likely the first part of their documentation. Try searching for the word Authentication in their documentation. Below are the authentication types supported on Sapper:

The most common types of authentication are Bearer Tokens, Username/Password (also referred to as Basic and API token ), and OAuth 2.0. Sapper has integrated these authentication types directly into this step.

Bearer Token

In this method you will be required to send your API Key or Token as a Bearer token. Get a detailed information from the below example:

From this example the below part indicates it’s a bearer token

To add this specific token in Sapper, you need to select Bearer Token from the Authorization menu and add sk_test_WiyegCaE6iGr8eSucOHitqFF as the Bearer Token Value.

Username/Password (Basic)

After the generation of Bearer Token now you need to generate and use the Username and Password for further authentication. Most of the username and password are used for the sign in purpose into the service that can be entered here. Although, In some cases for the API key the username, password or the both elements are used. In this scenario you need to provide the API key in the respective field mentioned in the below documentation.

The Endpoint URL shows a DELETE request being made to a resource called customers. The authorization type can be identified as Basic for two reasons:

1. The -u indicates Basic Authorizationusername.

2. Most APIs reference the username and password formatted as

3. Username : password.

4. There is a colon : This indicates that only a username is required for authentication.

Airtable Connections

Airtable Basic Auth Connections

Open

Airtable API Key Connections

Airtable Oauth 2.0 Connection

Actions

Create Record In Table

Create Record In Table | key: createRecordinTable

Create Record for Salesforce Opportunities

Create Record for Salesforce Opportunities | key: createRecordforSalesforceOpportunities

Create Record for Hubspot Deals

Create Record for Hubspot Deals | key: createRecordforHubspotDeals

Get Records For Salesforce Users

Get Records For Salesforce Users | key: getRecordforSalesforceUsers