Airtable data to SharePoint by COZYROC

This integration seamlessly connects Airtable and Sharepoint, 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 location in Sharepoint.

Setup Guide

This integration will establish a connection between Airtable and Microsoft Graph and pull the data from each Airtable table specified in the List Table parameter. The integration will then generate a CSV file for each table and send all files to your SharePoint instance. If the parameter Compression is set to true, all CSV files will be compressed and loaded as zip files to the SharePoint instance.

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

Airtable

• Server Host Required. Specify the correct base identifier in 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 to the destination.
• Query Parameter Optional. Multiple query parameters are separated by a new line.

Microsoft Graph

• Server Host Required. The default host URL is set to https://graph.microsoft.com/v1.0/sites/root to connect to the SharePoint instance at the root level. To connect to a specific SharePoint instance, set the host URL to https://graph.microsoft.com/v1.0/sites/<site-id>.
• Token File Required. Select the Microsoft Graph Rest Token file from the drop-down list. Review the KB-Article mentioned here on how to generate the token file.
• Destination Folder Required. Specify the path to the destination folder, ending with a trailing slash.