Airtable Reader Parameters

About Web Connections

Connections store authentication information.

For general information about web connections, please see Using Web Connections.

For information about managing web services (including authorization credentials such as Client Id and Client Secret), please see Managing Web Services.

Connection

From the Connection parameter in a web service format, you can do one of the following:

  • Select an existing previously defined connection. For information, see the section Reusing a Web Connection in Using Web Connections.
  • Select Add Web Connection to define a new connection. The new connection can be made visible only to the current user, or can be shared among multiple users.

Connection

Select an existing Airtable connection, or Add Web Connection...

Add Airtable Web Connection

To define a new connection from the Connection parameter in an Airtable format, see the topic Airtable: Add Web Connection.

Note  Use of the Airtable format requires you to set up your own Web Service. To configure a Web Service, refer to the instructions in the Airtable Web Service template included with this package. (From FME Workbench, open FME Options > Web Connections and click the Manage Services button. Navigate to the Airtable template.)

Service Connection

The name of the Airtable web connection.

Constraints

Base – The ID of the Airtable base from which to select tables or views. After a valid connection has been established, click the browse [...] button to list the Airtable bases which can be accessed using the current credentials.

Table or Views – One or more table/view names to generate feature types for. After a valid base has been selected, click the browse [...] button to list the Airtable tables in the base and the views for each table. Each table will be listed, followed by any views corresponding to that table.

For example:

Table 1
Table 1 (Grid view)
Table 2
Table 2 (Grid view)
Table 2 (Kanban view)

Selecting a table with a view will apply any filters or sort settings contained in that view when reading records from that table.

Schema Attributes

Additional Attributes to Expose

Use this parameter to expose Format Attributes in FME Workbench when you create a workspace:

  • In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
  • In a non-dynamic scenario, this parameter allows you to expose additional attributes on multiple feature types. Click the browse button to view the available format attributes (which are different for each format) for the reader.