Airtable - Download Table or View to CSV
Overview​
First time using this Blueprint? Make sure you follow our Airtable authorization guide.​
Quickly export data from a single table on an Airtable base to a CSV.
Only one table or view of data can be downloaded at a time, since CSVs are flat files.
Content of the downloaded file can be further refined by providing a view. Otherwise, the entire contents of the table will be downloaded.
Variables​
Name | Reference | Type | Required | Default | Options | Description |
---|---|---|---|---|---|---|
Base ID | AIRTABLE_BASE_ID | Alphanumeric | ✅ | - | - | The ID of your Airtable base. Found in the URL of your base and starts with app |
Table Name or ID | AIRTABLE_TABLE_NAME | Alphanumeric | ✅ | - | - | Can be the Name (case sensitive) or the ID of the table. The ID can be found in the URL and always starts with tbl . |
View Name or ID | AIRTABLE_VIEW_NAME | Alphanumeric | âž– | - | - | Can be the Name (case sensitive) or the ID of the view. The ID can be found in the URL and always starts with viw . |
Include Record IDs? | AIRTABLE_INCLUDE_RECORD_ID | Boolean | ✅ | true | - | If checked, an additional column named airtable_record_ids will be created in the CSV containing each row's unique Airtable Record ID. This is recommended if data ever needs to be reloaded back into Airtable in the future. |
API Key | AIRTABLE_API_KEY | Password | ✅ | - | - | API Key associated with a user that has access to the specified Base, Table, and View listed. Will usually start with key . |
Local File Name | AIRTABLE_DESTINATION_FILE_NAME | Alphanumeric | ✅ | - | - | Name of file to be generated with the results. Should be .csv extension. |
Local Folder Name | AIRTABLE_DESTINATION_FOLDER_NAME | Alphanumeric | âž– | - | - | lder where the file should be downloaded. Leaving blank will place the file in the home directory. |
YAML​
Below is the YAML template for this Blueprint and can be used in the Fleet YAML Editor.
source:
blueprint: Airtable - Download Table or View to CSV
inputs:
AIRTABLE_BASE_ID: null ## REQUIRED
AIRTABLE_TABLE_NAME: null ## REQUIRED
AIRTABLE_VIEW_NAME: null
AIRTABLE_INCLUDE_RECORD_ID: true ## REQUIRED
AIRTABLE_API_KEY: null ## REQUIRED
AIRTABLE_DESTINATION_FILE_NAME: null ## REQUIRED
AIRTABLE_DESTINATION_FOLDER_NAME: null
type: BLUEPRINT
guardrails:
retry_count: 1
retry_wait: 0s
runtime_cutoff: 4h0m0s
exclude_exit_code_ranges:
- "200-203"