Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the component 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 SSIS Components 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.