Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Box.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Box, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Box Stored Procedures
| Name | Description |
| AddMetadataTemplatestoFile | Applies a predefined metadata template to a file, creating a structured set of metadata fields for that file. |
| CopyFile | Creates a copy of an existing file in Box within the same folder or a different destination folder. |
| CopyFolder | Creates a duplicate of an entire folder, including its subfolders and files, in another location in Box. |
| CreateSchema | Generates a schema file that defines the structure of a specified Box table or view for integration or analysis. |
| CreateSignRequest | Creates a new electronic signature request for documents stored in Box using Box Sign. |
| DeleteFile | Permanently deletes a specified file from Box. |
| DownloadFile | Downloads the contents of a file from Box to a local system or application. |
| EmptyTrash | Permanently deletes all items currently in the trash for the authenticated user or enterprise. |
| GetOAuthAccessToken | Retrieves an OAuth access token from Box to authenticate API requests. |
| GetOAuthAuthorizationURL | Generates the authorization URL that a user must visit to grant application access during the OAuth authentication process. |
| LockFile | Locks a file in Box to prevent other users from editing or uploading new versions while the lock is active. |
| RefreshOAuthAccessToken | Refreshes an existing OAuth access token to maintain authentication without requiring user reauthorization. |
| RestoreItem | Restores a previously deleted file or folder from the trash back to its original location. |
| Search | Performs a global search across Box to find files, folders, and other items matching a search term. |
| ShareAnItem | Creates or updates a shared link for a file, folder, or bookmark, enabling controlled external access. |
| UnlockFile | Releases a file lock so that other users can edit or upload a new version. |
| UpdateFile | Updates the content or metadata of an existing file in Box. |
| UploadFile | Uploads a new file into a specified Box folder. |
| UploadFileVersion | Uploads a new version of an existing file, maintaining version history in Box. |