Excel Add-In for OneDrive

Build 20.0.7695

SharedResources

The OneDrive table SharedResources, which shows all the shared resources on a drive.

Table Specific Information

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, Shared_Scope FROM SharedResources WHERE Id IN ('B1E6BJ084A9133KB1!122', 'APF9D2K6WFAAPX9') 

SharedResources 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 shared resources in the 'Drive' no matter the depth they're located in.

Columns

Name Type References Description
id [KEY] String The id column for the table SharedResources.
audio_album String The audio_album column for the table SharedResources.
audio_albumArtist String The audio_albumArtist column for the table SharedResources.
audio_artist String The audio_artist column for the table SharedResources.
audio_bitrate Int64 The audio_bitrate column for the table SharedResources.
audio_composers String The audio_composers column for the table SharedResources.
audio_copyright String The audio_copyright column for the table SharedResources.
audio_disc Int32 The audio_disc column for the table SharedResources.
audio_discCount Int32 The audio_discCount column for the table SharedResources.
audio_duration Int64 The audio_duration column for the table SharedResources.
audio_genre String The audio_genre column for the table SharedResources.
audio_hasDrm Boolean The audio_hasDrm column for the table SharedResources.
audio_isVariableBitrate Boolean The audio_isVariableBitrate column for the table SharedResources.
audio_title String The audio_title column for the table SharedResources.
audio_track Int32 The audio_track column for the table SharedResources.
audio_trackCount Int32 The audio_trackCount column for the table SharedResources.
audio_year Int32 The audio_year column for the table SharedResources.
content String The content column for the table SharedResources.
createdDateTime Datetime The createdDateTime column for the table SharedResources.
createdBy_user_id String

Users.Id

The createdBy_user_id column for the table SharedResources.
cTag String The cTag column for the table SharedResources.
deleted_state String The deleted_state column for the table SharedResources.
description String The description column for the table SharedResources.
eTag String The eTag column for the table SharedResources.
file_mimeType String The file_mimeType column for the table SharedResources.
file_processingMetadata Boolean The file_processingMetadata column for the table SharedResources.
fileSystemInfo_createdDateTime Datetime The fileSystemInfo_createdDateTime column for the table SharedResources.
fileSystemInfo_lastModifiedDateTime Datetime The fileSystemInfo_lastModifiedDateTime column for the table SharedResources.
folder_childCount Int32 The folder_childCount column for the table SharedResources.
image_height Int32 The image_height column for the table SharedResources.
image_width Int32 The image_width column for the table SharedResources.
lastModifiedDateTime Datetime The lastModifiedDateTime column for the table SharedResources.
location_altitude Double The location_altitude column for the table SharedResources.
location_latitude Double The location_latitude column for the table SharedResources.
location_longitude Double The location_longitude column for the table SharedResources.
name String The name column for the table SharedResources.
package_type String The package_type column for the table SharedResources.
parentReference_driveId String The parentReference_driveId column for the table SharedResources.
parentReference_id String The parentReference_id column for the table SharedResources.
parentReference_name String The parentReference_name column for the table SharedResources.
parentReference_path String The parentReference_path column for the table SharedResources.
parentReference_shareId String The parentReference_shareId column for the table SharedResources.
photo_cameraMake String The photo_cameraMake column for the table SharedResources.
photo_cameraModel String The photo_cameraModel column for the table SharedResources.
photo_exposureDenominator Double The photo_exposureDenominator column for the table SharedResources.
photo_exposureNumerator Double The photo_exposureNumerator column for the table SharedResources.
photo_fNumber Double The photo_fNumber column for the table SharedResources.
photo_focalLength Double The photo_focalLength column for the table SharedResources.
photo_iso Int32 The photo_iso column for the table SharedResources.
photo_takenDateTime Datetime The photo_takenDateTime column for the table SharedResources.
remoteItem_createdDateTime Datetime The remoteItem_createdDateTime column for the table SharedResources.
remoteItem_id String The remoteItem_id column for the table SharedResources.
remoteItem_lastModifiedDateTime Datetime The remoteItem_lastModifiedDateTime column for the table SharedResources.
remoteItem_name String The remoteItem_name column for the table SharedResources.
remoteItem_size Int64 The remoteItem_size column for the table SharedResources.
remoteItem_webDavUrl String The remoteItem_webDavUrl column for the table SharedResources.
remoteItem_webUrl String The remoteItem_webUrl column for the table SharedResources.
searchResult_onClickTelemetryUrl String The searchResult_onClickTelemetryUrl column for the table SharedResources.
shared_scope String The shared_scope column for the table SharedResources.
sharepointIds_listId String The sharepointIds_listId column for the table SharedResources.
sharepointIds_listItemId String The sharepointIds_listItemId column for the table SharedResources.
sharepointIds_listItemUniqueId String The sharepointIds_listItemUniqueId column for the table SharedResources.
sharepointIds_siteId String The sharepointIds_siteId column for the table SharedResources.
sharepointIds_webId String The sharepointIds_webId column for the table SharedResources.
size Int64 The size column for the table SharedResources.
specialFolder_name String The specialFolder_name column for the table SharedResources.
video_bitrate Int32 The video_bitrate column for the table SharedResources.
video_duration Int64 The video_duration column for the table SharedResources.
video_height Int32 The video_height column for the table SharedResources.
video_width Int32 The video_width column for the table SharedResources.
webDavUrl String The webDavUrl column for the table SharedResources.
webUrl String The webUrl column for the table SharedResources.
UserId String The UserId column for the table SharedResources.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695