Airtable Format Attributes (Feature Representation)

In addition to the generic FME feature attributes that FME Workbench adds to all features (see About Feature Type Attributes), this format also adds format-specific attributes (Format Attributes).

Note  Format attribute values provided by the Airtable Reader are for informational purposes and cannot be used to control the behavior of the writer.

 

Attribute Name

Contents

airtable_type

The type of geometry represented in the feature. Airtable is a non-spatial format, so the only value is airtable_none.

airtable_base_id

The id of the base in which the record was contained.

airtable_base_name

The name of the base in which the record was contained.

airtable_table_id

The id of the table in which the record was contained.

airtable_table_name

The name of the table in which the record was contained.

airtable_table_description

The user-defined description of the airtable table to which the record belongs.

airtable_field_descriptions

A JSON containing descriptions for fields in the table and their user-defined descriptions. Only fields in the table which have a description defined will be included.

airtable_view_id

If the feature type corresponds to a view, this attribute contains the view id. Otherwise, it is empty.

airtable_view_name

If the feature type corresponds to a view, this attribute contains the name of the view. Otherwise, it is empty.

airtable_view_type

If the feature type corresponds to a view, this attribute contains the type of the view. Otherwise, it is empty. Values are view types supported by Airtable, including [grid, form, calendar, gallery, kanban].

airtable_record_creation_time

An ISO formatted datetime string with the time the record was created.

airtable_record_json

A JSON containing the raw data with all the requested fields in the record. This can be used to retrieve additional data for attachment or collaborator fields in the record.

airtable_record_id

The ID of the record in Airtable. This attribute can be used to update/delete/replace records when used with the Airtable Writer. This format attribute is exposed by default on features output from the Airtable Reader.