Folders
The OneDrive table Folders, which shows all the folders on a drive.
Table Specific Information
Note: See CreateFolder to create a folder.
Projection is done server-side. Also, queries that include the primary key Id and IN are executed server-side, e.g.:
SELECT Id, Name, Size, Description FROM Folders WHERE Id IN ('B1E6BJ084A9133KB1!122', 'APF9D2K6WFAAPX9')
Folder listing is done recursively via the DirectoryRetrievalDepth property. This property's default value is 5, which means it will get data only for the first 6 levels of the 'Drive' you've chosen (because the first level is located in DirectoryRetrievalDepth=0).
You can specify the value -1 to get all the folders in the 'Drive' no matter the depth they're located in.
While folders may be listed in this view, the contents of the folders may be worked with by using stored procedures such as:
- CopyResource - Copy a file/folder from one directory in your drive to another.
- DeleteResource - Delete a file/folder from your drive.
- MoveResource - Move a file/folder from one directory in your drive to another.
Columns
| Name | Type | References | Description |
| id [KEY] | String | The id column for the table Folders. | |
| audio_album | String | The audio_album column for the table Folders. | |
| audio_albumArtist | String | The audio_albumArtist column for the table Folders. | |
| audio_artist | String | The audio_artist column for the table Folders. | |
| audio_bitrate | Int64 | The audio_bitrate column for the table Folders. | |
| audio_composers | String | The audio_composers column for the table Folders. | |
| audio_copyright | String | The audio_copyright column for the table Folders. | |
| audio_disc | Int32 | The audio_disc column for the table Folders. | |
| audio_discCount | Int32 | The audio_discCount column for the table Folders. | |
| audio_duration | Int64 | The audio_duration column for the table Folders. | |
| audio_genre | String | The audio_genre column for the table Folders. | |
| audio_hasDrm | Boolean | The audio_hasDrm column for the table Folders. | |
| audio_isVariableBitrate | Boolean | The audio_isVariableBitrate column for the table Folders. | |
| audio_title | String | The audio_title column for the table Folders. | |
| audio_track | Int32 | The audio_track column for the table Folders. | |
| audio_trackCount | Int32 | The audio_trackCount column for the table Folders. | |
| audio_year | Int32 | The audio_year column for the table Folders. | |
| content | String | The content column for the table Folders. | |
| createdDateTime | Datetime | The createdDateTime column for the table Folders. | |
| createdBy_user_id | String |
Users.Id | The createdBy_user_id column for the table Folders. |
| cTag | String | The cTag column for the table Folders. | |
| deleted_state | String | The deleted_state column for the table Folders. | |
| description | String | The description column for the table Folders. | |
| eTag | String | The eTag column for the table Folders. | |
| file_mimeType | String | The file_mimeType column for the table Folders. | |
| file_processingMetadata | Boolean | The file_processingMetadata column for the table Folders. | |
| fileSystemInfo_createdDateTime | Datetime | The fileSystemInfo_createdDateTime column for the table Folders. | |
| fileSystemInfo_lastModifiedDateTime | Datetime | The fileSystemInfo_lastModifiedDateTime column for the table Folders. | |
| folder_childCount | Int32 | The folder_childCount column for the table Folders. | |
| image_height | Int32 | The image_height column for the table Folders. | |
| image_width | Int32 | The image_width column for the table Folders. | |
| lastModifiedDateTime | Datetime | The lastModifiedDateTime column for the table Folders. | |
| location_altitude | Double | The location_altitude column for the table Folders. | |
| location_latitude | Double | The location_latitude column for the table Folders. | |
| location_longitude | Double | The location_longitude column for the table Folders. | |
| name | String | The name column for the table Folders. | |
| package_type | String | The package_type column for the table Folders. | |
| parentReference_driveId | String | The parentReference_driveId column for the table Folders. | |
| parentReference_id | String | The parentReference_id column for the table Folders. | |
| parentReference_name | String | The parentReference_name column for the table Folders. | |
| parentReference_path | String | The parentReference_path column for the table Folders. | |
| parentReference_shareId | String | The parentReference_shareId column for the table Folders. | |
| photo_cameraMake | String | The photo_cameraMake column for the table Folders. | |
| photo_cameraModel | String | The photo_cameraModel column for the table Folders. | |
| photo_exposureDenominator | Double | The photo_exposureDenominator column for the table Folders. | |
| photo_exposureNumerator | Double | The photo_exposureNumerator column for the table Folders. | |
| photo_fNumber | Double | The photo_fNumber column for the table Folders. | |
| photo_focalLength | Double | The photo_focalLength column for the table Folders. | |
| photo_iso | Int32 | The photo_iso column for the table Folders. | |
| photo_takenDateTime | Datetime | The photo_takenDateTime column for the table Folders. | |
| remoteItem_createdDateTime | Datetime | The remoteItem_createdDateTime column for the table Folders. | |
| remoteItem_id | String | The remoteItem_id column for the table Folders. | |
| remoteItem_lastModifiedDateTime | Datetime | The remoteItem_lastModifiedDateTime column for the table Folders. | |
| remoteItem_name | String | The remoteItem_name column for the table Folders. | |
| remoteItem_size | Int64 | The remoteItem_size column for the table Folders. | |
| remoteItem_webDavUrl | String | The remoteItem_webDavUrl column for the table Folders. | |
| remoteItem_webUrl | String | The remoteItem_webUrl column for the table Folders. | |
| searchResult_onClickTelemetryUrl | String | The searchResult_onClickTelemetryUrl column for the table Folders. | |
| shared_scope | String | The shared_scope column for the table Folders. | |
| sharepointIds_listId | String | The sharepointIds_listId column for the table Folders. | |
| sharepointIds_listItemId | String | The sharepointIds_listItemId column for the table Folders. | |
| sharepointIds_listItemUniqueId | String | The sharepointIds_listItemUniqueId column for the table Folders. | |
| sharepointIds_siteId | String | The sharepointIds_siteId column for the table Folders. | |
| sharepointIds_webId | String | The sharepointIds_webId column for the table Folders. | |
| size | Int64 | The size column for the table Folders. | |
| specialFolder_name | String | The specialFolder_name column for the table Folders. | |
| video_bitrate | Int32 | The video_bitrate column for the table Folders. | |
| video_duration | Int64 | The video_duration column for the table Folders. | |
| video_height | Int32 | The video_height column for the table Folders. | |
| video_width | Int32 | The video_width column for the table Folders. | |
| webDavUrl | String | The webDavUrl column for the table Folders. | |
| webUrl | String | The webUrl column for the table Folders. | |
| UserId | String | The UserId column for the table Folders. |