Airtable data to Amazon S3 by COZYROC

This integration seamlessly connects Airtable to Amazon S3, effortlessly transferring data between the two platforms. With just a few clicks, it converts Airtable data into a CSV file format and swiftly uploads it to your designated Amazon S3 bucket.

Setup Guide

This integration will establish a connection between Airtable and Amazon S3 and pull the data from Airtable tables specified in the List Table parameter. The integration will then generate a CSV file for each table and send all files to your Amazon S3 bucket. If parameter Compression is set to true, all csv files will be compressed and loaded as zip files to Amazon S3. The uploaded files will be named as tablename_currentdate.

To run this integration and connect Airtable to Amazon S3, configure the parameters that are mentioned below.

Airtable

• Server Host Required. Specify the correct base identifier for the server host.
• Token File Required. Select the Airtable Rest Token file from the drop-down list. Review the KB-Article mentioned here regarding how to generate the token file.
• Batch Size Required. The default batch size is set to 100.
• List Table Required. This parameter accepts comma-separated values if you want to pull data from multiple Airtable tables.
• Compression Optional. Set this parameter to false if you don't want to load the zip files at the destination.
• Query Parameter Optional. Multiple query parameters are separated by a new line.

Amazon S3

• Server Host Required. Provide the relevant [bucket] and [region] in the server URL.
• Access Key Required. Specify the access key for the Amazon S3 service.
• Secret Key Required. Specify a secret key for the Amazon S3 service.
• Destination Folder Required. Specify the path to the destination folder, ending with a trailing slash.