Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Dropbox.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Dropbox, along with an indication of whether the procedure succeeded or failed.
CData ODBC Driver for Dropbox Stored Procedures
| Name | Description |
| AddSharedFileMember | Grants a user access to a shared file by adding them as a member, assuming the caller has the appropriate permissions. |
| AddSharedFolderMember | Adds a user to a shared folder, allowing them to access its contents based on the specified permission level. |
| CheckJobStatus | Checks the progress of an asynchronous sharing or file operation, such as adding or removing users. |
| CopyResource | Creates a copy of a file or folder at a new Dropbox location; entire folder trees are duplicated if a folder is specified. |
| CreateFolder | Creates a new folder or multiple folders at specified Dropbox paths; supports batch folder creation via structured input. |
| DeletePermanently | Permanently deletes a file or folder from Dropbox with no recovery option; requires elevated deletion scope. |
| DeleteResource | Deletes a file or folder and its contents (if applicable) from Dropbox, moving it to the deleted state. |
| DownloadFile | Downloads the contents of a file from Dropbox to the local system; requires content read access. |
| GetOAuthAccessToken | Gets an authentication token from Dropbox. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL. |
| GetSpaceUsage | Returns current and total storage usage statistics for the Dropbox account, including shared and team-used space. |
| MoveResource | Moves a file or folder to a different path within the user's Dropbox. This operation supports moving entire folder contents. |
| RefreshOAuthAccessToken | Obtains an updated OAuthAccessToken if passed a token to refresh. |
| RemoveSharedFileMember | Revokes a user's access to a shared file, removing them from the file's member list. |
| RemoveSharedFolderMember | Removes a member from a shared folder, provided the caller has the appropriate role and permissions. |
| RenameResource | Renames a file or folder by specifying the current path and a new name; path casing changes are not supported. |
| SearchFilesAndFolders | Searches for files and folders in a Dropbox account based on specified criteria. |
| SetAccessInheritance | Modifies whether a shared folder inherits access permissions from its parent, applicable in team-based Dropbox setups. |
| ShareFolder | Initiates sharing for a folder, allowing others to be invited with specified access roles; requires write-sharing privileges. |
| UnshareFolder | Removes all sharing permissions from a folder, making it private again; applicable only with sharing permissions. |
| UpdateProperties | Updates custom properties on a file or folder, including adding, editing, or removing property templates and key-value pairs. |
| UpdateSharedFileMember | Changes a member's role or permissions for a shared file, such as read-only or edit access. |
| UpdateSharedFolderMember | Modifies the access level of a user in a shared folder, such as promoting them to editor or revoking edit rights. |
| UploadFile | Uploads a new file to Dropbox or replaces an existing one at the specified path; requires content write access. |