Active
This application does not need additional settings. So you can make connectionUnique, active service acces point to a network. There are different types of connections (API key, Oauth…). More only by using your login credentials or by following the instructions below .

Airtable

	Important
Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice. Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

Important

Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice.

Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

The Airtable modulesThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More allow you to monitor recordsOne row in the Boost.space database. These are individual rows under spaces in each module. For example single products, but not their variants. More and submitted forms or search, retrieve, create, update, and delete records in your Airtable account.

To get started with Airtable, create an account at airtable.com/signup.

Refer to the Airtable REST API Documentation for a list of available endpoints.

Connect Airtable to Boost.spaceCentralization and synchronization platform, where you can organize and manage your data. More IntegratorPart of the Boost.space system, where you can create your connections and automate your processes. More

You can connect Airtable apps in Boost.space Integrator in three ways:

Connect using OAuth
Connect using Personal Access Token
Connect using API Key (API keys will be deprecated by the end of January 2024)

Connect using OAuth

To connect Airtable using OAuth:

Log in to your Boost.space Integrator account, open the Airtable moduleThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More scenarioA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive. More, click the Add button next to the Connection type field, and selectAirtable OAuth.
Optional: In the Connection name field, enter a name for the connection.
Optional: Click Show Advanced Settings and enter the client credentials created in the section, Obtain OAuth Credentials.
Click Save.
In the Authentication screen, click Add a base and select the base to which you want to grant access.
Click Grant access.

You have successfully connected the Airtable app with Boost.space Integrator.

Obtain OAuth Credentials

Providing OAuth credentials is optional.

When you select the connection type as OAuth, authorize your account without the need to provide OAuth credentials.

To obtain OAuth credentials:

Log in to your Airtable account.
Click Profile > Developer hub.
Click OAuth integrations > Register new OAuth integration.
Enter the name for the integration and OAuth redirect URL as https://integrator.boost.space/oauth/cb/airtable3.
Click Generate client secret.
Copy the Client ID and Client Secret to a safe place.
Select the scopes, enter the support information, and click Save changes.

You have successfully created OAuth credentials.

Connect using Personal Access Token

You can connect Airtable apps using personal access tokenThe API token is a multi-digit code that allows a user to authenticate with cloud applications. More values from your Airtable account.

Log in to your Airtable account.
Click Your Profile Icon > Developer hub.
Click Personal access tokens > Create new token.
Enter a name for the access token, select the Scopes, Access, and click Create token.

Note: UsersCan use the system on a limited basis based on the rights assigned by the admin. More should choose at least the following most frequently required scopes: data.records:read, data.records:write, and schema.bases:read
Copy the Personal Access Token to a safe place, and click Done.
Log in to your Boost.space Integrator account, open the Airtable module scenario, click the Add button next to the Connection type field, and select the connection type as Airtable Token or Key.
Optional: In the Connection name field, enter a name for the connection.
Select the token type as Personal Access Token and enter the token copied in step 5 above.
Optional: Click Show Advanced Settingsand select the proxy service in the Proxyfield.

Note

By choosing a Proxy, you understand and confirm that your Airtable data, including personal access tokens, will be routed through a third-party service.
Click Save.

You have successfully established the connection. You can now edit your scenario and add more Airtable modules. If your connection needs reauthorization, follow the connection renewal steps here.

Connect using API Key

You can connect Airtable apps using an API Key from your Airtable account.

	Caution
	API keys will be deprecated by the end of January 2024. After this date, API keys will stop working, and you will have to migrate to personal access tokens.

Log in to your Airtable account.
Click Your Profile Icon > Developer hub.
Click API key and copy the API key to a safe place.
Log in to your Boost.space Integrator account, open the Airtable module scenario, click the Add button next to the Connection type field, and select the connection type as Airtable Token or Key.
Optional: In the Connection name field, enter a name for the connection.
Select the token type as API Key and enter the token copied in step 3 above.
Optional: Click Show Advanced Settingsand select the proxy service in the Proxyfield.

Note

By choosing a Proxy, you understand and confirm that your Airtable data, including API keys, will be routed through a third-party service.
Click Save.

You have successfully established the connection. You can now edit your scenario and add more Airtable modules. If your connection needs reauthorization, follow the connection renewal steps here.

Build Airtable ScenariosA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive. More

After connecting the app, you can perform the following actions:

Records

You can watch, create, update, search, retrieve, upsert, delete records, and watch responses using the following modules.

Watch Records

Returns all newly created or updated records in a view (required Created Time or Last Modified Time fields).

Connection	Establish a connection to your Airtable account.
Base	Select the base that contains the table you want to watch for records.
Table	Select the table you want to watch for new records.
TriggerEvery scenario has a trigger, an event that starts your scenario. A scenario must have a trigger. There can only be one trigger for each scenario. When you create a new scenario, the first module you choose is your trigger for that scenario. Create a trigger by clicking on the empty module of a newly created scenario or moving the... configuration	Trigger field Select the `Created Time` option to watch for new records or the `Last Modified Time` option to watch for modified records. If you do not have a `Created Time` or `Last Modified Time` field in your scheme, we ask you to create one. Without this field, the trigger will not work correctly. LabelA label is a “tag” that can be added to items within a module. It's a flexible tool used to categorize and organize data, making it easier to customize workflows and processes. More field: used as a label for a recordOne row in the Boost.space database. These are individual rows under spaces in each module. For example single products, but not their variants. More. For example, Choose where to start dialog.
Limit	The maximum number of records Boost.space Integrator will return during one execution cycleA cycle is the operation and commit/rollback phases of scenario execution. A scenario may have one or more cycles (one is the default)..
View	Select the view to watch the records. If selected, it will return the records only in that view.
Formula	Enter the formula to filter records. For more details, refer to the Formula field reference documentation. The formula will be evaluated for each record, and if the result is not `0`, `false`, `""`, `NaN`, `[]`, or `#Error!`, includes the record in the response. If combined with the `view` parameter, it returns only records in that view that satisfy the formula. For example, to only include records where Name isn’t empty, pass in `NOT({Name} = '')` as a parameter like this: `filterByFormula=NOT%28%7BName%7D%20%3D%20%27%27%29`
Use Column ID	Select whether to use column ID instead of column name for mappingMapping links the modules in your scenario. When you map an item, you connected the data retrieved by one module to another module to perform the desired action. For example, you can map the email address and subject lines from the Email > Watch emails module to Google Sheets > Add a row and create a spreadsheet of email addresses.... This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario.

Watch Responses

TriggersEvery scenario has a trigger, an event that starts your scenario. A scenario must have a trigger. There can only be one trigger for each scenario. When you create a new scenario, the first module you choose is your trigger for that scenario. Create a trigger by clicking on the empty module of a newly created scenario or moving the... when a new response is submitted.

	Warning
	Available for paid Pro PlanCombination of a license (enabled features) and tier (numeric limits) and a subscription period (monthly / yearly).only. See the Airtable pricing page.

The webhookA webhook is a way for an app to send real-time information to a specific URL in response to certain events or triggers. URL needs to be generated in Boost.space Integrator and added to the form configuration in the Airtable.

Add the Watch Responses module to your Boost.space Integratorscenario.
Generate and copy the webhook URL.
Log in to your Airtable account.
Open the Base and the table you want for the form and create a Form view.
Set the form as needed, scroll down the form, and enable the Redirect to URL after the form is submitted option.
Enter the Webhook URL generated in step 2 to the displayed dialog box and add the ?record_id={record_id}just after the webhook URL to include the Record ID in the module’s output, then click Save. The resulting URL will, for example, look like this:

https://hook.eu1.make.com/tgnp28pewooafbdgobvbh225hmocbn85?record_id={record_id}
Go back to your Boost.space Integratorscenario and run the Watch Responses module only to load the Record ID from Airtable and to be able to map that field into the other modules.

Note: Airtable only supports sending the record_id parameter.
Submit the form in Airtable where the Redirect to URL after the form is submitted option is enabled and the Webhook URL is added (step 6 above).

The Watch Responses module is triggered and loads the Record ID.
Add the Airtable > Get a Record module just after the Airtable > Watch Responses module and map the record_id to the Record ID field.

Every time the form is submitted, the Watch Responses module in your Boost.space Integratorscenario is triggered, and the Get a Record module returns the submitted form details.

Search Records

Searches for specific records or returns all records.

Connection	Establish a connection to your Airtable account.
Base	Select or map the base that contains the table you want to search for records.
Table	Select the table you want to search for records.
Formula	Enter the formula to filter records. For more details about formulae, refer to the Formula field reference documentation. The formula will be evaluated for each record, and if the result is not `0`, `false`, `""`, `NaN`, `[]`, or `#Error!`, includes the record in the response. If combined with the `view` parameter, returns only the records in that view that satisfy the formula. For example, to only include records where Name isn’t empty, pass in `NOT({Name} = '')` as a parameter like this: `filterByFormula=NOT%28%7BName%7D%20%3D%20%27%27%29`
Sort	Specify sorting, if needed. The higher itemItems are rows in records (order/request/invoice/purchase...) in the list has precedence.
View	Select or map the view for the search results.
Output Fields	Add the fields you want to receive in the output. If no field is provided, all fields will be returned. It can be the field’s name, for example, `Email`, or the field’s ID, for example, `fldzuOSozlM84fYV3`.
Limit	Set the maximum number of records Boost.space Integrator will return during one execution cycle. The default value is 10.
Use Column ID	Select whether to use column ID instead of column name for mapping. This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario.

Get a Record

Retrieves a single record by its ID.

Connection	Establish a connection to your Airtable account.
Base	Select the base that contains the table with the record whose details you want to retrieve.
Table	Select the table that contains the record whose details you want to retrieve.
Record ID	Enter (map) the Record ID whose details you want to retrieve. Alternatively, you can use the search option to select the record.
Use Column ID	Select whether to use column ID instead of column name for mapping. This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario.

Create a Record

Creates a new record in a Airtable.

Connection	Establish a connection to your Airtable account.
Base	Select the base containing the table you want to create a record.
Table	Select the table in which you want to create a record.
Record	Enter values to the desired fields. See also Airtable’s guide to basic field types.
Smart links	Enable this option if you want to enter names instead of record IDs to fields that link to another table. The record is automatically created in the linked table if there is no match.
Use Column ID	Select whether to use column ID instead of column name for mapping. This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario.

Update a Record

Updates a record by its ID.

Connection

Establish a connection to your Airtable account.

Base

Select the base containing the table whose records you want to update.

Table

Select the table whose record you want to update.

Records ID

Enter (map) the Record ID you want to update. You can retrieve the ID, for example, using the Search Records or Watch Records module. Alternatively, you can use the Search button to select the Record ID.

Record

Enter values in the fields you want to update. See also Airtable’s guide to basic field types.

	Note
	To delete the content of the field, use the `erase` functionFunctions you can use in Boost.space Integrator - create, update, delete, get, search..

Smart links

Enable this option if you want to enter names instead of record IDs to fields that link to another table. The record is automatically created in the linked table if there is no match.

Use Column ID

Select whether to use column ID instead of column name for mapping.

This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario.

Upsert a Record

Creates a new or updates an existing record.

Connection	Establish a connection to your Airtable account.
Base	Select the base containing the table you want to update or create a record.
Table	Select the table where you want to create or update a record.
Record ID	Enter (map) the ID of the record you want to update. If no ID is entered, it will create a new record. You can retrieve the ID, for example, using the Search Records or Watch Recordsmodule. Alternatively, you can use the Search button to select the Record ID. If you enter an ID that does not exist, an errorService is unavailable due to a failure, a service responds with unexpected data or the validation of input data fails. More occurs, and no action is performed.
Record	Enter values in the fields you want to update or create. See also Airtable’s guide to basic field types.
Smart links	Enable this option if you want to enter names instead of record IDs to fields that link to another table. The record is automatically created in the linked table if there is no match.
Use Column ID	Select whether to use column ID instead of column name for mapping. This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario.

Delete a Record

Deletes a record by its ID.

Connection	Establish a connection to your Airtable account.
Base	Select the base that contains the table you want to delete a record from.
Table	Select the table you want to delete the record from.
Record ID	Enter the ID of the record you want to delete. You can retrieve the ID, for example, using the Search Records or Watch Records module. Alternatively, you can use the Search button to select the Record ID.

Create a Record (Advanced)

Creates a record with mapped fields.

Connection	Establish a connection to your Airtable account.
Base	Enter the base that contains the table you want to create a record in.
Table	Enter the table you want to create a record in.
Record Fields as ArrayWithin a bundle, data items of the same type are sometimes in an array. You can find an array by looking at the details of a bundle. Depending on the details of your scenario, you can map other modules to a specific item in an array or use iterators and aggregators to manipulate your data into other formats. When mapping,... More	Add the Column ID and Field value by selecting the field type for the record you want to create.
Smart links	Enable this field to enter the userCan use the system on a limited basis based on the rights assigned by the admin. More name in the linked record fields instead of record IDs to select an existing record or create a new one if it doesn’t exist and use it to add new options in single/multiple select fields.

Update a Record (Advanced)

Updates a record with mapped fields.

Connection	Establish a connection to your Airtable account.
Base	Enter the base that contains the table whose record details you want to update.
Table	Enter the table whose record details you want to update.
Record ID	Enter the Record ID whose details you want to update.
Record Fields	Add a new Column ID and Field value by selecting the field type you want to update.
Smart links	Enable this field to enter the user name in the linked record fields instead of record IDs to select an existing record or create a new one if it doesn’t exist and use it to add new options in single/multiple select fields.

Search Records (Advanced)

Searches for specific records or returns all records. Advanced module for mapping.

Connection	Establish a connection to your Airtable account.
Base ID	Enter the Base ID that contains the table whose records you want to search.
Table	Enter the table whose records you want to search.
Sort	A list of sort objects that specifies the way you want to order the records. For example, asc.
View	The name or ID of a view of the records in the table.
Formula	A formula is used to filter records. The formula will be evaluated for each record, and if the result is not `0`, `false`, `""`, `NaN`, `[]`, or `#Error!` includes the record in the response.
Output Fields	Add the fields you want to receive in the output. If no field is provided, all fields will be returned. It can be the field’s name, for example, `Email`, or the field’s ID, for example, `fldzuOSozlM84fYV3`.
Limit	Set the maximum number of records Boost.space Integrator will return during one execution cycle.
Use Column ID	Select whether to use column ID instead of column name for mapping. This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this scenario.

Other

You can list bases, table schemas, and call APIs using the following modules.

Make an API Call

Allows you to perform a custom API call.

Connection

Establish a connection to your Airtable account.

URL

Enter a path relative to https://api.airtable.com/. For example, /v0/{base_id}/{table_id}.

	Note
	For the list of available endpoints, refer to the Airtable REST API Documentation.

Method

Select the HTTP method you want to use:

GET

to retrieve information for an entry.
POST

to create a new entry.
PUT

to update/replace an existing entry.
PATCH

to make a partial entry update.
DELETE

to delete an entry.

Headers

Enter the desired request headers. You don’t have to add authorization headers; we already did that for you.

Query String

Enter the request query string.

Body

Enter the body content for your API call.

Example of Use – List Records

The following API call returns all records in the specified table in your Airtable account:

URL:

/v0/{base_id}/{table_id}

Method:

GET

Search results can be found in the module’s Output under Bundle > Body > records.

In our example, 4 records were returned:

List Bases

Returns the detailed list of all bases.

Connection	Establish a connection to your Airtable account.
Limit	Set the maximum number of bases Boost.space Integrator will return during one execution cycle.

List Table Schemas

Returns the schema of the tables in the specified base.

Connection	Establish a connection to your Airtable account.
Base	Select or map the base whose table schemas you want to list.
Limit	Set the maximum number of table schemas Boost.space Integrator will return during one execution cycle.

	Note
	By choosing a Proxy, you understand and confirm that your Airtable data, including personal access tokens, will be routed through a third-party service.