ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Airtable の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにAirtable から関連するレスポンスデータを返します。
CData SSIS Components for Airtable ストアドプロシージャ
| 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. |