Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector 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 Python Connector 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. |