Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT operations with Azure Data Lake Storage.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Azure Data Lake Storage, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Azure Data Lake Storage Stored Procedures
| Name | Description |
| CopyFile | Copy a file from a source to a destination. |
| CreateFile | Create a file. Path is required for a successful operation. |
| CreateFileSystem | Create a filesystem by specifying the name. |
| CreateFolder | Create a folder. Path is required for a successful operation. |
| DeleteFileSystem | Delete a filesystem. The name of the filesystem for a successful operation. |
| DeleteObject | Delete a file or a folder. Path is required for a successful operation. |
| DownloadFile | Download a file. Path and DownloadPath are required for a successful operation. |
| GetFileSystemProperties | Get the properties of a filesystem. The name of the filesystem is required for a successful operation. |
| GetOAuthAccessToken | Gets the OAuth access token from SharePoint. |
| GetOAuthAuthorizationURL | Gets the SharePoint authorization URL. Access the URL returned in the output in a Web browser. This requests the access token that can be used as part of the connection string to SharePoint. |
| LeaseBlob | The LeaseBlob operation creates and manages a lock on a blob for write and delete operations. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with SharePoint. |
| RenameObject | Rename a file or a directory. Path and RenameTo are required for a successful operation. |
| SetFileSystemProperties | Set the properties for a filesystem. The name of the filesystem is required for a successful operation. |
| UploadFile | Upload a File. Path and FilePath are required for a successful operation. |