BizTalk Adapter for OneDrive

Build 20.0.7654

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654