Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Airtable.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Airtable, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Airtable Stored Procedures
| Name | Description |
| CreateSchema | Creates a schema file for a specified Airtable table or view, allowing its structure and metadata to be saved for use in integrations or development workflows. |
| DownloadAttachment | Download an attachment from a table by providing the table name or ID (depending on the DisplayObjectIds connection property) and attachment ID. |
| GetOAuthAccessToken | Retrieve the OAuth access token to be used for authentication with Airtable using OAuth. |
| GetOAuthAuthorizationURL | Generate the OAuth authorization URL used for authentication with Airtable using OAuth. |
| RefreshOAuthAccessToken | Exchanges a refresh token for a new access token. |
| SyncCSV | Synchronizes raw CSV data into a designated Sync API table in Airtable, allowing bulk data import through a specified file path, input stream, or Base64-encoded content. |
| UploadAttachment | Uploads a file to an attachment field in Airtable by specifying the target record’s identifier and the attachment field’s name or unique identifier. The file can be provided from a local path, an input stream, or as Base64-encoded data. |