Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with CSV.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from CSV, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for CSV Stored Procedures
| Name | Description |
| CopyFile | Copies a specified file from a local directory or supported cloud-storage provider to another location. This procedure is useful for automating data migration and replication tasks in workflows that rely on multiple storage environments. |
| CreateSchema | Generates a schema file for the current data source. This procedure defines the structure of tables, views, and columns to enable consistent mapping and metadata management for CSV-based integrations. |
| DeleteFile | Removes a file from a local folder or supported cloud-storage provider. This procedure helps maintain storage hygiene by programmatically deleting obsolete or temporary files from integrated systems. |
| DownloadFile | Retrieves and downloads a file from a cloud-storage location or remote source to a specified local directory. This procedure supports automation of data retrieval and backup operations. |
| GetOAuthAccessToken | Obtains the OAuth access token to be used for authentication with data sources using OAuth. |
| GetOAuthAuthorizationURL | Obtains the OAuth authorization URL used for authentication with data sources using OAuth. |
| ListFiles | Returns a list of available CSV or related data files within a designated local or cloud-based directory. This procedure enables browsing, validation, or synchronization of available files before data processing or import operations. |
| MoveFile | Transfers a file from one location to another within local or supported cloud storage. This procedure is useful for reorganizing file structures or moving processed files to archival or staging areas. |
| RefreshOAuthAccessToken | Exchanges a refresh token for a new access token. |
| UploadFile | Uploads a file from a local system to a designated destination, such as a cloud-storage service or remote data repository. This procedure supports data publishing, synchronization, and integration workflows. |