Airtable modules
With the Airtable connector for ÃÛ¶¹ÊÓƵ Workfront Fusion, you can start a scenario based on events in your Airtable account, create, upload, and update records, search records, and make custom API calls to the Airtable API.
Access requirements
You must have the following access to use the functionality in this article:
To find out what plan, license type, or access you have, contact your Workfront administrator.
For information on ÃÛ¶¹ÊÓƵ Workfront Fusion licenses, see ÃÛ¶¹ÊÓƵ Workfront Fusion licenses.
Prerequisites
You must have an Airtable account to use the functionality in this article.
Airtable API information
The Airtable connector uses the following:
Connect Airtable to Workfront Fusion connect-airtable-to-workfront-fusion
- Open Workfront Fusion and the Create a connection dialog of the desired module.
- Enter a name for the connection.
- (Optional) Click Show advancet settings, and enter your Airtable Client ID and Client Secret.
- Click the Continue button to create the connection and return to the module.
Airtable modules and their fields
Records
Create a Record create-a-record
This action module creates a new record.
You specify the data you want in the record and where you want it to be stored.
The module returns any standard fields associated with the record, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.
When you are configuring this module, the following fields display.
Delete a Record delete-a-record
This action module deletes a particular record.
You specify the ID and locates of the record.
The module returns the ID of the record and any associated fields, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.
When you are configuring this module, the following fields display.
Get a record get-a-record
This action module retrieves record details.
Search Records search-records
This search module looks for records in an object in Airtable that match the search query you specify.
You can map this information in subsequent modules in the scenario.
When you are configuring this module, the following fields display.
Update a Record update-a-record
This action module updates a particular record.
You specify the ID of the record and the new data you want it to contain.
The module returns any standard fields associated with the record, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.
When you are configuring this module, the following fields display.
Upsert a record
This action module updates or inserts a particular record.
You specify the ID of the record and the new data you want it to contain.
The module returns any standard fields associated with the record, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.
When you are configuring this module, the following fields display.
Watch Records watch-records
This trigger module starts a scenario when a record is created or updated in the specified table.
Watch Responses
This trigger module starts a scenario when a form is submitted.
The webhook URL needs to be generated in Workfront Fusion and then added to form configuration in Airtable.
-
Add the Watch New Responses module to your Workfront Fusion scenario.
-
Generate and copy the webhook URL.
For instructions, see Instant triggers (webhooks) in ÃÛ¶¹ÊÓƵ Workfront Fusion.
-
Log in to your Airtable account.
-
Open the Base and the table you want to use 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:
-
Go back to your Workfront Fusion scenario and run the Watch Responses module only to load fields from Airtable and to be able to map those fields into the other modules.
-
Submit the form in Airtable where the Redirect to URL after the form is submitted option is enabled and Webhook URL added (step 6 above).
The Watch Responses module is triggered and the desired data are loaded.
-
Add the Airtable > Get a Record module just after the Airtable > Watch Responses module and map the record_id to the Record ID field.
Now, every time the form is submitted, the Watch Responses module in your Workfront Fusion scenario is triggered, and the Get a Record module returns the submitted form details.
Make an API call
Custom API Call
This action module lets you make a custom authenticated call to the Airtable API. This way, you can create a data flow automation that can’t be accomplished by the other Airtable modules.
The action is based on the entity type (Allocadia object type) you specify.
When you are configuring this module, the following fields display.
https://api.airtable.com/}. Example: v0/{base}/{table}Add the headers of the request in the form of a standard JSON object.
For example, {"Content-type":"application/json"}
Workfront Fusion adds the authorization headers for you.
Add the body content for the API call in the form of a standard JSON object.
Note:
When using conditional statements such as if in your JSON, put the quotation marks outside of the conditional statement.
