DownloadFile
Downloads a File. Requires the files.content.read scope.
Execute
Refer to the query examples below for using the procedure:
query = "EXEC DownloadFile Id = 'id:LAvTtXjyNEYAAAAAAAAADg', DownloadTo = 'C:/Users/User/Downloads'"; query = "EXEC DownloadFile Revision = 'rev:60fc8c685aace89083943', DownloadTo = 'C:/Users/User/Downloads'"; query = "EXEC DownloadFile Path = '/Test Folder/Test File.txt', DownloadTo = 'C:/Users/User/Downloads'";
Input
Name | Type | Required | Description |
Id | String | False | The ID of the document to download. |
Revision | String | False | The revision of the document to download, for example 'rev:a1c10ce0dd78'. |
Path | String | False | The path of the file or folder to download. |
AsZip | Boolean | False | Download a folder in a zip format. Must be set to true to download a folder. |
DownloadTo | String | False | The folder path to download the file to. |
Result Set Columns
Name | Type | Description |
Success | String | Whether or not the file was successfully downloaded. |
Id | String | A unique identifier for the file. |
Name | String | The name of the file (including extension). |
Revision | String | A unique identifier for the current revision of a file. |
DisplayPath | String | The cased path to be used for display purposes only. |
LowerCasePath | String | The lowercased full path in the user's Dropbox. |
ClientModified | String | The modification time set by the desktop client when the file was added to Dropbox. |
ServerModified | String | The last time the file was modified on Dropbox. |
Size | String | The file size in bytes. |
ContentHash | String | A hash of the file content. |
PreviewURL | String | The preview URL of the file. |
IsDownloadable | String | If true, file can be downloaded directly; else the file must be exported. |
HasExplicitSharedMembers | String | If true, the results will include a flag for each file indicating whether or not that file has any explicit members. |
FileData | String | The file's data encoded in Base64 will be outputted if DownloadTo and FileStream inputs are not set. |