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 file from a local or cloud storage. |
| CreateSchema | Creates a schema file for the resource. |
| DeleteFile | Delete file from a local or cloud storage. |
| 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 | List all CSV files stored in a local or cloud-based directory. |
| MoveFile | Moves file from a local or cloud storage. |
| RefreshOAuthAccessToken | Exchanges a refresh token for a new access token. |