{{ transformations:ImportAirtableAction.png}}
====== IMPORT FROM AIRTABLE======
Category: Import / App/Cloud\\

\\ 
=====Description=====
This action connects to an Airtable database ("base") and retrieves data from a specified table via API Key and Base ID.\\

\\ 
=====Action settings=====
^ Setting  ^ Description  ^
|Connector<sup>*</sup>|Select the pre-constructed connection to your Airtable base, or, build one by selecting //Add connector//.\\  See [[connectors:airtable|Airtable connector]] for details.|
|Table<sup>*</sup>|The name of the table within the selected base you want to retrieve data from.|
|Filter|This option allows you to define a filter for the incoming data using EasyMorph's Expression Editor.|
|Only top rows|This option allows you to limit the number of rows, from the top of the dataset, to import.| 
|Import System ID|Adds a column to the dataset containing the unique record ID generated by Airtable.|
|Import system timestamp|Adds a column to the dataset containing the date each record was created.|
|Load only selected columns|Allows you to define the columns to import.  Selecting this opens a list of the column names found in the\\ target table.  If this list appears blank, click the //Reload column names// button to populate it.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\

\\ 
=====Shortcuts=====
Fast ways to create the action:
  * Press the "Add data" menu button. Pick "Fetch from cloud/application".

\\ 
=====See also=====
  *[[connectors:airtable|Airtable connector]]