![]() The primary field and unique ID must be present in the header row.Field names in the header row must be case-insensitive and unique.Field names in the header row must not be empty.No other rows can be used as the header row. The first row of the CSV request body will be parsed as a header row and will appear as field names in your synced table.The request body should be a plaintext CSV string delimited with commas.The HTTP header Content-Type: text/csv is required.Your request cannot contain more than 500 columns or the sync will fail. A maximum of 500 fields (columns) are supported.Your request can contain more than 10,000 rows, but only the first 10,000 will be synced. A maximum of 10,000 records (rows) can be synced.If you do need to make any changes now or in the future, then click the drop-down menu next to the name of your synced table and then choose the Update sync configuration option. Once the table has been created, it's a good idea to look through the table and make sure everything looks correct. Depending upon the size of the initial CSV sent to Airtable, this may take a moment. For example, when an event gets scheduled. If you use a calendar app or data recording tools that aren’t natively supported yet with Airtable, the API allows you to write new records from those sources. Create new records from yet to be supported platforms. Once you are satisfied with the sync setup, click the Create table button. Let’s explore three examples of how you could use the Airtable API in your work: 1. Otherwise, if you are familiar with our CSV guidelines, then feel free to start setting things up! If you are wondering about best practices for CSV formatting, then hop below before proceeding. It's important to note that this sync is intended for workflows that involve utilizing CSVs to sync information into Airtable via an API endpoint. Great for when you only need to import CSV data to create the initial structure of a table in Airtable.īelow, we'll walk you through the general setup process for API syncs. Importing CSV data into an existing base - Manually import CSV data into a base.Airtable Sync integration: Emailed data - An alternative way of bringing CSV data into Airtable.Airtable Sync FAQs - Answers to common questions that might help unblock you if you are encountering issues.Sync - Basic setup - If you haven’t set up a sync before, we recommend first reading this article to become familiarized with how the Airtable Sync feature generally works.Additionally, you'll need creator permissions in the base to set up a PAT for use during the setup process. Owners/ Creators - In order to create or update synced tables, you'll need to have creator permissions in the base where you are setting up the sync. īusiness and Enterprise Scale access only This article covers how to sync CSV formatted data into Airtable via API calls authorized by utilizing Personal Access Tokens. Learn how to use the Airtable Sync integration feature to bring information from external applications into a single, centralized table within Airtable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |