このページでは、CData Cloud でのMicrosoft OneDrive への接続の確立 のガイド、利用可能なリソースに関する情報、および使用可能な接続プロパティのリファレンスについて説明します。

Microsoft OneDrive への接続

接続の確立 は、CData Cloud にデータベースを作成するためのMicrosoft OneDrive への認証方法と必要な接続プロパティの設定方法について示します。

CData Cloud サービスからデータにアクセス

利用可能な標準サービスを経由してMicrosoft OneDrive からデータにアクセスする方法と、CData Cloud の管理については、CData Cloud ドキュメント で詳しく説明します。

Database タブで対応するアイコンを選択して、Microsoft OneDrive に接続します。必須プロパティはSettings にリストされています。Advanced タブには、通常は必要ない接続プロパティが表示されます。

Authenticating to Microsoft OneDrive

Microsoft OneDrive uses the OAuth authentication standard. To authenticate using OAuth, you will need to create an app to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL connection properties.

Entra ID（Azure AD）

Note：Microsoft はAzure AD をEntra ID にリブランドしました。ユーザーがEntra ID 管理サイトを操作する必要があるトピックでは、Microsoft が使用している名称と同じものを使用します。ただし、名前または値が"Azure AD" を参照しているCData 接続プロパティは、依然として存在します。

Microsoft Entra ID は、マルチテナント型のクラウドベースのID およびアクセス管理プラットフォームです。 OAuth ベースの認証フローに対応しており、ドライバーによるMicrosoft OneDrive エンドポイントへのセキュアなアクセスを実現します。

Web アプリケーションを介したEntra ID への認証には、必ずはじめにカスタムOAuth アプリケーションを作成して登録する必要があります。 これにより、アプリケーションは独自のリダイレクトURI を定義し、クレデンシャルのスコープを管理し、組織固有のセキュリティポリシーに準拠することができるようになります。

カスタムOAuth アプリケーションの作成および登録方法の詳細については、Entra ID（Azure AD）アプリケーションの作成 を参照してください。

AuthScheme をAzureAD に設定した後の認証手順は、環境によって異なります。 デスクトップアプリケーション、Web ベースのワークフロー、またはヘッドレスシステムから接続する方法の詳細については、以下のセクションを参照してください。

Azure サービスプリンシパル

Azure サービスプリンシパルとしての認証は、OAuth クライアントクレデンシャルフローを介して処理されます。直接のユーザー認証は行われません。代わりに、クレデンシャルはアプリケーション自体のためだけに作成されます。アプリケーションで実行されるすべてのタスクは、デフォルトユーザーコンテキストなしで実行されます。リソースへのアプリケーションのアクセスは、割り当てられたロールの権限によって制御されます。

AzureAD アプリとAzure サービスプリンシパルの作成

Azure サービスプリンシパルを使用して認証する場合、Azure AD テナントにAzure AD アプリケーションを作成して登録する必要があります。詳しくは、Entra ID（Azure AD）アプリケーションの作成 を参照してください。

portal.azure.com の［アプリの登録］で［API のアクセス許可］に移動し、Microsoft Graph アクセス許可を選択します。アクセス許可には2つの異なるアクセス許可セットがあります。委任されたアクセス許可とアプリケーションの許可です。クライアントの資格情報認証時に使用されるアクセス許可は、［アプリケーションの許可］の下にあります。

アプリケーションへのロールの割り当て

サブスクリプションのリソースにアクセスするには、アプリケーションにロールを割り当てる必要があります。

1. 検索バーでサブスクリプションサービスを検索・選択して、サブスクリプションページを開きます。
2. アプリケーションを割り当てるサブスクリプションを選択します。
3. アクセス制御 (IAM)を開き、追加 -> ロール割り当ての追加 を選択してロール割り当ての追加ページを開きます。
4. 作成したAzure AD アプリに割り当てるロールとして、所有者を選択します。

認証の完了 クライアントシークレットと証明書のどちらを使用するかを選択し、以下の該当する手順に従ってください。

クライアントシークレット

次の接続プロパティを設定します。

• AuthScheme：クライアントシークレットを使用する場合はAzureServicePrincipal。
• InitiateOAuth： GETANDREFRESH。InitiateOAuth を使えば、繰り返しOAuth の交換を行ったり、手動でOAuthAccessToken を設定する必要はなくなります。
• AzureTenant：接続するテナント。
• OAuthClientId：アプリケーション設定のクライアントId。
• OAuthClientSecret：アプリケーション設定のクライアントシークレット。

証明書

次の接続プロパティを設定します。

• AuthScheme：証明書を使用する場合はAzureServicePrincipalCert。
• InitiateOAuth： GETANDREFRESH。InitiateOAuth を使えば、繰り返しOAuth 交換を行ったり、手動でOAuthAccessToken を設定する必要はなくなります。
• AzureTenant：接続するテナント。
• OAuthJWTCert：JWT 証明書のストア。
• OAuthJWTCertType：OAuthJWTCert で指定された証明書ストアの種類。

これで接続する準備が整いました。クライアント資格情報での認証は、他の接続同様に自動的に行われますが、ユーザーにプロンプトするウィンドウは表示されません。ユーザーコンテキストがないため、ブラウザのポップアップは必要ないからです。接続が行われ、内部的に処理されます。

Managed Service Identity (MSI)

Azure VM 上でMicrosoft OneDrive を実行しており、マネージドID（MSI）認証情報を自動的に取得して接続したい場合は、AuthScheme を AzureMSI に設定します。

User-Managed Identities

マネージドID のトークンを取得するには、OAuthClientId プロパティを使用してマネージドID のclient_id を指定します。

VM に複数のユーザーが割り当てられたマネージドID がある場合は、OAuthClientId も指定する必要があります。

Fine Tuning Data Access

• DirectoryRetrievalDepth: How many folders deep you want to get results for Folders, Files, SharedResources and Permissions tables.
• DriveId: The ID of the Drive that you want to use when getting data for tables Files, Folders, SharedResources and Permissions.
• ListGroupDrives: Indicates if you would like to list your group drives or not when querying the Drives table. Useful if you're using a OneDrive for Business account.

SSL 設定のカスタマイズ

デフォルトでは、Cloud はサーバーとのTLS のネゴシエーションを試みます。サーバー証明書は、デフォルトのシステム信頼済み証明書ストアで検証されます。SSLServerCert 接続プロパティを使用して、証明書の検証方法をオーバーライドできます。

別の証明書を指定するには、SSLServerCert 接続プロパティを参照してください。

Firewall またはProxy 経由の接続

HTTP プロキシ

HTTP プロキシへの認証には、以下のように設定します。

• ProxyServer：HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
• ProxyPort：プロキシサーバーが起動しているTCP ポート。
• ProxyAuthScheme：プロキシサーバーに対して認証する際にCloud が使用する認証方法。
• ProxyUser：プロキシサーバーに登録されているユーザーアカウントのユーザー名。
• ProxyPassword：ProxyUser に紐付けられたパスワード。

その他のプロキシ

次のプロパティを設定します。

• プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
• 接続をトンネルするには、FirewallType をTUNNEL に設定します。
• 認証するには、FirewallUser とFirewallPassword を設定します。
• SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

The CData Cloud models Microsoft OneDrive objects as an easy-to-use SQL database, using views and stored procedures. These are defined in schema files, which are simple, easy-to-read text files that define the structure and organization of data. Because the table definitions are dynamically retrieved, any changes to the remote data are immediately reflected in your queries.

Views

The ビュー section, which lists read-only SQL tables, contains samples from an example OneDrive site. Your data model is obtained dynamically based on your user credentials and OneDrive site.

The sample site includes the following views:

View	Description
Drives	Displays all OneDrive drives accessible to the current user, including personal and shared drives
Files	Provides detailed information about individual files stored in OneDrive drives, including name, size, and metadata.
FileVersions	Tracks the version history of each file in OneDrive, allowing review or rollback of previous file states.
Folders	Lists all folders within a OneDrive drive, useful for navigation and hierarchical organization analysis.
GroupMembers	Displays a list of users assigned to each group, helping manage team or access group memberships.
Groups	Shows all security and distribution groups within the connected Microsoft 365 tenant, enabling administrative oversight.
Permissions	Details sharing and access permissions for files and folders within a OneDrive drive, identifying owners and collaborators.
SharedResources	Identifies all files and folders that have been shared from OneDrive, along with recipients and access levels.
SharedWithMeResources	Lists files and folders that have been shared with the signed-in user by others, including metadata such as the owner, sharing permissions, and access details.
Users	Lists users with OneDrive accounts in the organization, including user identifiers and profile details.

Stored Procedures

ストアドプロシージャ are SQL scripts that extend beyond standard CRUD operations. They can be used to search, update, and modify information in OneDrive.

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData Cloud - Microsoft OneDrive ビュー

Name	Description
Drives	Displays all OneDrive drives accessible to the current user, including personal and shared drives.
Files	Provides detailed information about individual files stored in OneDrive drives, including name, size, and metadata.
FileVersions	Tracks the version history of each file in OneDrive, allowing review or rollback of previous file states.
Folders	Lists all folders within a OneDrive drive, useful for navigation and hierarchical organization analysis.
GroupMembers	Lists the members of the group.
Groups	Shows all security and distribution groups within the connected Microsoft 365 tenant, enabling administrative oversight.
Permissions	Details sharing and access permissions for files and folders within a OneDrive drive, identifying owners and collaborators.
SharedResources	Identifies all files and folders that have been shared from OneDrive, along with recipients and access levels.
SharedWithMeResources	Lists files and folders that have been shared with the signed-in user by others, including metadata such as the owner, sharing permissions, and access details.
Users	Lists users with OneDrive accounts in the organization, including user identifiers and profile details.

Displays all OneDrive drives accessible to the current user, including personal and shared drives.

Table Specific Information

UserId and GroupId connection properties can also be used to filter records. If both are included in the connection string, UserId will take precedence over GroupId.

Due to API limitations, all operators on this view are executed client-side.

Columns

Name	Type	References	Description
driveType	String		Specifies the classification of the OneDrive drive, such as personal, business, or documentLibrary.
owner_application_displayName	String		The human-readable name of the application that owns or created the drive.
owner_application_id	String		The unique ID assigned to the application that owns or manages the drive.
quota_deleted	Long		The total number of bytes used by deleted items that are still retained in the recycle bin or recovery folder.
quota_remaining	Long		The total number of bytes still available for use in the drive's allocated storage limit.
quota_state	String		The current status of the drive's storage capacity, such as normal, nearing, or exceeded.
quota_storagePlanInformation_upgradeAvailable	Bool		Specifies whether the user is eligible to upgrade their current storage plan based on available tiers.
quota_total	Long		The maximum number of bytes allocated to the drive under the user's current storage plan.
quota_used	Long		The total number of bytes currently used in the drive, including active and deleted content.
sharePointIds_listId	String		The identifier of the SharePoint list associated with the current item, if applicable.
sharePointIds_listItemId	String		The unique numeric identifier of a specific item within a SharePoint list.
sharePointIds_listItemUniqueId	String		The globally unique identifier assigned to the list item within the SharePoint environment.
sharePointIds_siteId	String		The identifier of the SharePoint site that contains the list or library associated with the current item.
sharePointIds_siteUrl	String		The full URL of the SharePoint site that hosts the associated list or document library.
sharePointIds_tenantId	String		The Microsoft 365 tenant identifier that owns the SharePoint site where the list or item is stored.
sharePointIds_webId	String		The identifier of the SharePoint web (subsite) that contains the associated list or item.
Linkedfollowing	String		A hyperlink to items or folders in OneDrive that the user is actively following for updates or collaboration.
Linkeditems	String		A hyperlink to the child items contained within a folder or parent item in OneDrive.
Linkedlist	String		A hyperlink that navigates to the SharePoint list which contains the current item.
Linkedroot	String		A hyperlink to the root directory of the drive, representing the top-level folder or entry point.
Linkedspecial	String		A hyperlink to system-defined special folders including Documents, Photos, Camera Roll, or similar.
ParentReference	String		A reference object containing metadata about the immediate parent item or folder of the current item.
Id [KEY]	String		A system-generated unique string that identifies the item within the drive.
Name	String		The file or folder name as it appears in OneDrive, including its original casing and formatting.
Description	String		A user-defined or system-generated description that provides context about the item's contents or purpose.
owner_user_id	String		The unique identifier of the OneDrive user who owns or created the drive instance.

Provides detailed information about individual files stored in OneDrive drives, including name, size, and metadata.

Table Specific Information

Select

Projection is performed server-side. In addition, queries that use the primary key Id with an IN filter are also executed server-side. For example:

SELECT Id, Name, audio_album, audio_title FROM Files WHERE Id IN ('B1E6BJ084A9133KB1!101', 'APF9D2K6WFA524Y') 

Include ParentReference_DriveId and ParentReference_Id in the WHERE clause to get the result for a particular folder. For example:

 SELECT * FROM Files WHERE  ParentReference_DriveId = 'b!3Yqza-5FJ0usfhyH-2QafkQpf0OC0jlNh8LAETWPK6dNROPDScevTKbV-drnCFHV' And ParentReference_id = '01QFG2V52Z62HOXS5F6RHIHVT36T3Q5GKH' 

Server-side filtering using ParentReference_Id is supported on the root drive when the AuthScheme property is set to AzureAD. However, it is not available for client-credential authentication. For example:

 SELECT * FROM Files WHERE  ParentReference_id = '01QFG2V52Z62HOXS5F6RHIHVT36T3Q5GKH' 

For server-side filtering using ParentReference_Id with client-credential authentication, such as AzureServicePrincipal or AzureServicePrincipalCert, the createdBy_user_id column is required. For example:

 SELECT * FROM Files WHERE  ParentReference_id = '01QFG2V52Z62HOXS5F6RHIHVT36T3Q5GKH' AND createdBy_user_id = '1c67f23f-8681-4c67-9c19-253e628442d5' 

UserId and GroupId connection properties can also be used to filter records. If both are included in the connection string, UserId will take precedence over GroupId.

File listing is performed recursively based on the DirectoryRetrievalDepth property. By default, this property is set to 5, which means the driver retrieves data only for the first six levels of the selected drive. This is because level 1 corresponds to DirectoryRetrievalDepth=0.

You can set the value to -1 to retrieve all the files in the drive, regardless of their depth.

Files can be listed in this view, and their contents can be accessed 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.
• DownloadFile - Download an existing file from your drive.
• MoveResource - Move a file/folder from one directory in your drive to another.
• UploadFile - Upload a new file or update content to an existing file.

Columns

Name	Type	References	Description
id [KEY]	String		Unique identifier of the file item within the OneDrive drive.
Etag	String		Entity tag for tracking changes to the file; used for concurrency control.
createdBy_user_id	String		Identifier of the user who originally created the file.
createdBy_user_displayName	String		Display name of the user who created the file.
lastModifiedBy_user_id	String		Identifier of the user who last modified the file.
lastModifiedBy_user_displayName	String		Display name of the user who last modified the file.
ResourceType	String		Specifies the type of resource represented, such as file or folder.
createdBy_user_email	String		Email of the user who created the file.
lastModifiedBy_user_email	String		Email of the user who last modified the file.
createdBy_application_displayName	String		Name of the application that created the file.
createdBy_application_id	String		Unique ID of the application that created the file.
createdDateTime	Datetime		Timestamp when the file was initially created.
description	String		User-defined or system-generated description of the file's purpose or contents.
lastModifiedBy_application_displayName	String		Name of the application that last modified the file.
lastModifiedBy_application_id	String		Unique ID of the application that last modified the file.
lastModifiedDateTime	Datetime		Timestamp of the most recent modification to the file.
name	String		The file's name as it appears in OneDrive.
parentReference_driveId	String		ID of the parent drive containing the file.
parentReference_driveType	String		Type of the parent drive, such as personal or documentLibrary.
parentReference_id	String		Unique ID of the parent folder or item.
parentReference_name	String		Name of the parent folder or item.
parentReference_path	String		File system path of the parent item within OneDrive.
webUrl	String		Direct URL to access the file via a web browser.
audio_album	String		Name of the album the audio file belongs to.
audio_albumArtist	String		Name of the album artist associated with the audio file.
audio_artist	String		Primary artist of the audio file.
audio_bitrate	Long		Bitrate of the audio file in bits per second.
audio_composers	String		Comma-separated list of composers (for example, John Williams, Hans Zimmer, or Ennio Morricone).
audio_copyright	String		Copyright information associated with the audio file.
audio_disc	Int		Disc number the track is from, if part of a multi-disc album.
audio_discCount	Int		Total number of discs in the audio collection.
audio_duration	Long		Duration of the audio file in milliseconds.
audio_genre	String		Genre of the audio file content, such as Rock, Jazz, or Classical.
audio_hasDrm	Bool		Indicates whether the audio file is protected by digital rights management.
audio_isVariableBitrate	Bool		Specifies whether the audio file uses variable bitrate encoding.
audio_title	String		Title of the audio track.
audio_track	Int		Track number of the audio file on the disc.
audio_trackCount	Int		Total number of tracks in the audio collection or album.
audio_year	Int		Year the audio file was published or recorded.
cTag	String		Change tag used to detect updates to the file or folder.
file_hashes_crc32Hash	String		CRC32 checksum used for data validation of the file.
file_hashes_quickXorHash	String		QuickXor hash for efficient change detection in Office files.
file_hashes_sha1Hash	String		SHA-1 cryptographic hash of the file.
file_hashes_sha256Hash	String		SHA-256 cryptographic hash of the file.
file_mimeType	String		MIME type of the file.
fileSystemInfo_createdDateTime	Datetime		Filesystem timestamp indicating when the file was created.
fileSystemInfo_lastModifiedDateTime	Datetime		Filesystem timestamp of the last time the file was modified.
folder_childCount	Int		Number of items directly within the folder, if the item is a folder.
image_height	Int		Height of the image in pixels.
image_width	Int		Width of the image in pixels.
location_altitude	Double		Altitude at which the photo or file was captured, in meters.
location_latitude	Double		Latitude coordinate of where the photo or file was captured.
location_longitude	Double		Longitude coordinate of where the photo or file was captured.
photo_cameraMake	String		Manufacturer of the camera used to take the photo.
photo_cameraModel	String		Model of the camera used to capture the photo.
photo_exposureDenominator	Double		Denominator of the exposure time ratio used to capture the photo.
photo_exposureNumerator	Double		Numerator of the exposure time ratio used to capture the photo.
photo_fNumber	Double		Aperture setting (f-number) used when the photo was taken.
photo_focalLength	Double		Focal length of the lens in millimeters.
photo_iso	Int		ISO sensitivity setting used when the photo was taken.
photo_orientation	Int		Numeric value representing the photo's orientation (for example, 1 for normal, 3 for rotated 180).
photo_takenDateTime	Datetime		Date and time when the photo was captured.
publication_checkedOutBy_application_displayName	String		Display name of the user who checked out the file.
publication_checkedOutBy_application_id	String		Identifier of the user who checked out the file.
publication_level	String		The publication visibility level, such as checkout or published.
publication_versionId	String		Identifier for the published version of the file.
size	Long		Total size of the item in bytes, including metadata and content.
video_audioBitsPerSample	Int		Bits per audio sample in the video file.
video_audioChannels	Int		Number of audio channels in the video, typically 1 for mono or 2 for stereo.
video_audioFormat	String		Encoding format used for the audio stream in the video file.
video_audioSamplesPerSecond	Int		Sample rate for the video's audio stream, in hertz.
video_bitrate	Int		Total data rate of the video stream, measured in bits per second.
video_duration	Long		Playback duration of the video in milliseconds.
video_fourCC	String		Four-character code (FourCC) identifying the video codec (such as H264 or XVID).
video_frameRate	Double		Number of frames displayed per second in the video.
video_height	Int		Height of the video in pixels.
video_width	Int		Width of the video in pixels.

Tracks the version history of each file in OneDrive, allowing review or rollback of previous file states.

Table Specific Information

SELECT

The Cloud will use the Microsoft OneDrive API to process WHERE clause conditions built with the following column and operator. The filter labeled 'createdBy_user_id' is required to execute the query successfully.

• FileId supports the '='.
• DriveId supports the '='.
• UserId supports the '='.
• createdBy_user_id supports the '='.

For example:

SELECT * FROM FileVersions WHERE FileId = '01CYQN2MFPR6NIWVZNMNFL3SL4E3KF7IHY' AND DriveId = 'b!GrEGWax2VE-ssnJNr1E8llqoLptvK-BGjFRpceFzFg5Nwp9Bw2xbR62J0NAouP6z' AND createdBy_user_id = '472df319-2978-49d4-9445-9e7019def16f'

SELECT * FROM FileVersions WHERE FileId = '01CYQN2MFPR6NIWVZNMNFL3SL4E3KF7IHY' AND createdBy_user_id = '472df319-2978-49d4-9445-9e7019def16f'

SELECT * FROM FileVersions WHERE createdBy_user_id = '472df319-2978-49d4-9445-9e7019def16f'

Columns

Name	Type	References	Description
FileId [KEY]	String		Identifier of the original file to which this version belongs.
lastModifiedBy_user_displayName	String		Display name of the user who made the most recent modification to this file version.
lastModifiedBy_user_id	String		Unique identifier of the user who last modified this file version.
lastModifiedDateTime	Datetime		Timestamp indicating when this file version was last modified.
size	Long		Size of the file version in bytes.
id	String		Unique identifier assigned to this specific version of the file.
lastModifiedBy_user_email	String		Email address of the user who last modified this file version.
DriveId	String		Identifier of the OneDrive or SharePoint drive where the file version is stored.
publication_level	String		The publication state of the version, such as draft or published.
createdBy_user_id	String		Unique identifier of the user who originally created this version of the file.

Lists all folders within a OneDrive drive, useful for navigation and hierarchical organization analysis.

Table Specific Information

Select

Note: Use the CreateFolder stored procedure to create a new folder.

Projection is performed server-side. In addition, queries that use the primary key Id with an IN filter are also executed server-side. For example:

SELECT Id, Name, Size, Description FROM Folders WHERE Id IN ('B1E6BJ084A9133KB1!122', 'APF9D2K6WFAAPX9') 

Include ParentReference_DriveId and ParentReference_Id in the WHERE clause to get the result for a particular folder. For example:

 SELECT * FROM Folders WHERE  ParentReference_DriveId = 'b!3Yqza-5FJ0usfhyH-2QafkQpf0OC0jlNh8LAETWPK6dNROPDScevTKbV-drnCFHV' And ParentReference_id = '01QFG2V52Z62HOXS5F6RHIHVT36T3Q5GKH' 

Server-side filtering using ParentReference_Id is supported on the root drive when the AuthScheme property is set to AzureAD. However, it is not available for client-credential authentication. For example:

 SELECT * FROM Folders WHERE  ParentReference_id = '01QFG2V52Z62HOXS5F6RHIHVT36T3Q5GKH' 

For server-side filtering using ParentReference_Id with client-credential authentication (such as AzureServicePrincipal or AzureServicePrincipalCert), the createdBy_user_id column is required. For example:

 SELECT * FROM Folders WHERE  ParentReference_id = '01QFG2V52Z62HOXS5F6RHIHVT36T3Q5GKH' AND createdBy_user_id = '1c67f23f-8681-4c67-9c19-253e628442d5' 

UserId and GroupId connection properties can also be used to filter records. If both are included in the connection string, UserId will take precedence over GroupId.

Folder listing is performed recursively using the DirectoryRetrievalDepth property. By default, this property is set to 5, which means it retrieves data for the first six levels of the selected drive. This is because the first level corresponds to DirectoryRetrievalDepth=0.

You can set the value to -1 to retrieve all the folders in the drive, regardless of their depth.

Folders can be listed in this view, and their contents can be accessed 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		Unique identifier for the item.
Etag	String		Entity tag for the item used for concurrency control.
createdBy_user_id	String		ID of the user who created the item.
createdBy_user_displayName	String		Display name of the user who created the item.
lastModifiedBy_user_id	String		ID of the user who last modified the item.
lastModifiedBy_user_displayName	String		Display name of the user who last modified the item.
createdBy_application_displayName	String		Name of the application that created the item.
createdBy_application_id	String		ID of the application that created the item.
createdDateTime	Datetime		Timestamp when the item was created.
description	String		User-provided description of the item.
lastModifiedBy_application_displayName	String		Name of the application that last modified the item.
lastModifiedBy_application_id	String		ID of the application that last modified the item.
lastModifiedDateTime	Datetime		Timestamp of the last modification to the item.
name	String		Name of the item (file or folder).
parentReference_driveId	String		ID of the drive containing the parent item.
parentReference_driveType	String		Type of the drive (for example, personal, or business).
parentReference_id	String		ID of the parent item.
parentReference_name	String		Name of the parent item.
parentReference_path	String		Path to the parent item.
parentReference_shareId	String		Sharing ID associated with the parent item.
parentReference_sharepointIds_listId	String		SharePoint list ID associated with the parent item.
parentReference_sharepointIds_listItemId	String		SharePoint list item ID for the parent item.
parentReference_sharepointIds_listItemUniqueId	String		Unique SharePoint list item ID.
parentReference_sharepointIds_siteId	String		ID of the SharePoint site.
parentReference_sharepointIds_siteUrl	String		URL of the SharePoint site.
parentReference_sharepointIds_tenantId	String		Tenant ID for the SharePoint organization.
parentReference_sharepointIds_webId	String		Web ID of the SharePoint site.
parentReference_siteId	String		ID of the parent site (OneDrive/SharePoint).
webUrl	String		URL to access the item in a web browser.
LinkedcreatedByUser	String		Link to the user entity that created the item.
LinkedlastModifiedByUser	String		Link to the user entity that last modified the item.
audio_album	String		Album title of the audio file.
audio_albumArtist	String		Primary artist of the album.
audio_artist	String		Performer of the audio content.
audio_bitrate	Long		Bitrate of the audio in bits per second.
audio_composers	String		Composer(s) of the audio content.
audio_copyright	String		Copyright statement for the audio file.
audio_disc	Int		Disc number of the audio track.
audio_discCount	Int		Total number of discs in the album.
audio_duration	Long		Duration of the audio file in milliseconds.
audio_genre	String		Genre of the audio content.
audio_hasDrm	Bool		Indicates whether the audio file has digital rights management (DRM).
audio_isVariableBitrate	Bool		Indicates whether the audio uses variable bitrate encoding.
audio_title	String		Title of the audio track.
audio_track	Int		Track number on the album.
audio_trackCount	Int		Total number of tracks in the album.
audio_year	Int		Year the audio was released.
content	String		Base64 or encoded content of the item.
cTag	String		Change tag used for item versioning and sync detection.
deleted_state	String		The deletion status (for example, 'deleted', 'restored').
file_hashes_crc32Hash	String		CRC32 hash of the file content.
file_hashes_quickXorHash	String		QuickXor hash of the file content used by OneDrive.
file_hashes_sha1Hash	String		SHA-1 hash of the file content.
file_hashes_sha256Hash	String		SHA-256 hash of the file content.
file_mimeType	String		MIME type of the file (for example, 'application/pdf').
file_processingMetadata	Bool		Indicates whether the file has additional processing metadata (for example, indexing).
fileSystemInfo_createdDateTime	Datetime		Timestamp when the file was created in the file system.
fileSystemInfo_lastAccessedDateTime	Datetime		Timestamp of the last access to the file.
fileSystemInfo_lastModifiedDateTime	Datetime		Timestamp when the file was last modified.
folder_childCount	Int		Number of items (files/folders) in the folder.
folder_view_sortBy	String		Default sort field for viewing folder contents.
folder_view_sortOrder	String		Default sort order (ascending/descending) for folder contents.
folder_view_viewType	String		Type of view used to display the folder contents (for example, thumbnails).
image_height	Int		Height of the image in pixels.
image_width	Int		Width of the image in pixels.
location_altitude	Double		Altitude (in meters) where the file (typically a photo) was created.
location_latitude	Double		Latitude coordinate for the file's location.
location_longitude	Double		Longitude coordinate for the file's location.
package_type	String		Type of package (for example, OneNote, ZIP).
pendingOperations_pendingContentUpdate_queuedDateTime	Datetime		Timestamp when a pending update was queued.
photo_cameraMake	String		Camera manufacturer used to take the photo.
photo_cameraModel	String		Camera model used to take the photo.
photo_exposureDenominator	Double		Denominator of the exposure time (for example, 1/60s = 60).
photo_exposureNumerator	Double		Numerator of the exposure time.
photo_fNumber	Double		F-number (aperture) used to take the photo.
photo_focalLength	Double		Focal length of the lens used in millimeters.
photo_iso	Int		ISO sensitivity used when taking the photo.
photo_orientation	Int		Orientation of the photo (for example, 1 = normal, 3 = upside down).
photo_takenDateTime	Datetime		Timestamp when the photo was taken.
publication_level	String		The publication level for the folder, which can define sharing or access visibility.
publication_versionId	String		Identifier representing the specific publication version of the folder.
remoteItem_createdBy_application_displayName	String		Display name of the application that created the remote item.
remoteItem_createdBy_application_id	String		Unique identifier of the application that created the remote item.
remoteItem_createdDateTime	Datetime		Timestamp when the remote item was initially created.
remoteItem_file_hashes_crc32Hash	String		CRC32 checksum used for file integrity verification.
remoteItem_file_hashes_quickXorHash	String		QuickXor hash used by OneDrive to track file content changes.
remoteItem_file_hashes_sha1Hash	String		SHA-1 hash of the file used for content validation.
remoteItem_file_hashes_sha256Hash	String		SHA-256 hash of the file used for secure integrity checking.
remoteItem_file_mimeType	String		MIME type of the file, such as application/pdf or image/jpeg.
remoteItem_file_processingMetadata	Bool		Indicates whether the file contains processing metadata such as indexing or tagging.
remoteItem_fileSystemInfo_createdDateTime	Datetime		Date and time when the file was created in the filesystem.
remoteItem_fileSystemInfo_lastAccessedDateTime	Datetime		Date and time the file was last accessed in the filesystem.
remoteItem_fileSystemInfo_lastModifiedDateTime	Datetime		Last modification timestamp of the file within the filesystem.
remoteItem_folder_childCount	Int		Number of child items contained in the folder.
remoteItem_folder_view_sortBy	String		Default attribute used to sort items in the folder view.
remoteItem_folder_view_sortOrder	String		Sorting order (ascending or descending) used in the folder view.
remoteItem_folder_view_viewType	String		Type of view used for displaying the folder, such as list or thumbnails.
remoteItem_id	String		Unique identifier of the remote item.
remoteItem_image_height	Int		Height of the image in pixels.
remoteItem_image_width	Int		Width of the image in pixels.
remoteItem_lastModifiedDateTime	Datetime		Timestamp of the last change made to the remote item.
remoteItem_name	String		Name of the remote item (file or folder).
remoteItem_package_type	String		Type of package the item belongs to, such as OneNote or ZIP.
remoteItem_parentReference_driveId	String		Drive ID of the item's parent directory.
remoteItem_parentReference_driveType	String		Type of drive hosting the item, such as personal or business.
remoteItem_parentReference_id	String		Identifier of the parent folder or item.
remoteItem_parentReference_name	String		Name of the parent folder or item.
remoteItem_parentReference_path	String		Full path to the parent item in the drive.
remoteItem_parentReference_shareId	String		ID associated with shared access to the parent item.
remoteItem_parentReference_sharepointIds_listId	String		SharePoint list ID related to the parent item.
remoteItem_parentReference_sharepointIds_listItemId	String		Item ID within a SharePoint list.
remoteItem_parentReference_sharepointIds_listItemUniqueId	String		Globally unique identifier (GUID) for the SharePoint list item.
remoteItem_parentReference_sharepointIds_siteId	String		SharePoint site ID where the item is located.
remoteItem_parentReference_sharepointIds_siteUrl	String		URL of the SharePoint site hosting the item.
remoteItem_parentReference_sharepointIds_tenantId	String		Tenant ID of the SharePoint organization.
remoteItem_parentReference_sharepointIds_webId	String		Web ID for the SharePoint subsite.
remoteItem_parentReference_siteId	String		Site ID associated with the parent folder or item.
remoteItem_shared_scope	String		The scope of the shared item, such as organization or anonymous.
remoteItem_shared_sharedDateTime	Datetime		Date and time when the item was shared.
remoteItem_size	Long		Size of the item in bytes.
remoteItem_specialFolder_name	String		Indicates whether the folder is special, such as Documents or Photos.
remoteItem_video_audioBitsPerSample	Int		Number of audio bits per sample in the video file.
remoteItem_video_audioChannels	Int		Number of audio channels (for example, mono, stereo) in the video.
remoteItem_video_audioFormat	String		Format of the audio encoding in the video.
remoteItem_video_audioSamplesPerSecond	Int		Sample rate of audio in the video, measured in Hz.
remoteItem_video_bitrate	Int		Bitrate of the video file in bits per second.
remoteItem_video_duration	Long		Duration of the video in milliseconds.
remoteItem_video_fourCC	String		Four-character code (FourCC) identifying the video codec.
remoteItem_video_frameRate	Double		Frame rate of the video in frames per second.
remoteItem_video_height	Int		Video height in pixels.
remoteItem_video_width	Int		Video width in pixels.
remoteItem_webDavUrl	String		WebDAV-compliant URL to access the remote item programmatically.
remoteItem_webUrl	String		Web URL to view the remote item in a browser.
searchResult_onClickTelemetryUrl	String		URL used for telemetry tracking when a search result is clicked.
shared_owner_application_displayName	String		Display name of the application that owns the shared item.
shared_owner_application_id	String		ID of the application that owns the shared item.
shared_scope	String		Scope of sharing for the item, such as users, organization, or anonymous.
shared_sharedDateTime	Datetime		Date and time when the item was shared by the owner.
sharepointIds_listId	String		Identifier for the SharePoint list.
sharepointIds_listItemId	String		Item ID in the associated SharePoint list.
sharepointIds_listItemUniqueId	String		GUID for the SharePoint list item.
sharepointIds_siteId	String		SharePoint site ID where the item resides.
sharepointIds_siteUrl	String		URL of the SharePoint site.
sharepointIds_tenantId	String		ID of the SharePoint tenant.
sharepointIds_webId	String		Identifier of the SharePoint web object.
size	Long		Size of the item in bytes.
specialFolder_name	String		Type of special folder, such as Documents, Music, or Photos.
video_audioBitsPerSample	Int		Audio depth per sample in the video file.
video_audioChannels	Int		Number of audio channels in the video (for example, 2 for stereo).
video_audioFormat	String		Audio codec format used in the video.
video_audioSamplesPerSecond	Int		Audio sample rate in Hz.
video_bitrate	Int		Total bitrate of the video file.
video_duration	Long		Length of the video in milliseconds.
video_fourCC	String		Codec identifier (FourCC) used for the video stream.
video_frameRate	Double		Video frame rate in frames per second.
video_height	Int		Height resolution of the video.
video_width	Int		Width resolution of the video.
webDavUrl	String		WebDAV URL for accessing the item via file system protocols.
Linkedanalytics	String		Link to analytics data related to the folder or item.
Linkedchildren	String		Link to the child items contained within the folder.
LinkedlistItem	String		Link to the associated SharePoint list item.
Linkedpermissions	String		Link to the permissions set on the item.
Linkedsubscriptions	String		Link to any active subscriptions (for example, webhooks) on the item.
Linkedthumbnails	String		Link to thumbnail previews for the item.
Linkedversions	String		Link to version history for the file.
Linkedworkbook	String		Link to the Excel workbook interface if the file is an Excel document.

Lists the members of the group.

Columns

Name	Type	References	Description
GroupId [KEY]	String	Groups.Id	Id of the Group.
MemberId [KEY]	String	Users.Id	Id of the Member
DisplayName	String		Display Name of the member.
UserPrincipalName	String		Principal Name of the member.

Shows all security and distribution groups within the connected Microsoft 365 tenant, enabling administrative oversight.

Columns

Name	Type	References	Description
Id [KEY]	String		Unique identifier for the group object within the directory.
assignedLabels	String		List of sensitivity labels assigned to the group, used for compliance or classification.
assignedLicenses	String		Details of licenses that have been assigned to the group members, including service plans.
classification	String		Custom string used to classify the group, such as Confidential or Internal.
createdDateTime	Datetime		Date and time when the group was created in the directory.
description	String		Free-form description of the group, typically used for administrative context.
displayName	String		Display name of the group as it appears in the address book or directory listings.
expirationDateTime	Datetime		The date and time when the group is scheduled to expire, if applicable.
groupTypes	String		List of types associated with the group, such as Unified or DynamicMembership.
hasMembersWithLicenseErrors	Bool		Indicates whether any group members have license assignment errors.
isAssignableToRole	Bool		Specifies if the group can be assigned to Azure AD roles for role-based access control.
isManagementRestricted	Bool		Indicates whether group management is restricted to designated owners or admins.
licenseProcessingState_state	String		Current state of license processing for the group (for example, 'Enabled', 'Error').
mail	String		Email address of the group if mail-enabled, used for communication or notifications.
mailEnabled	Bool		Indicates whether the group is enabled to send or receive email messages.
mailNickname	String		Mail alias (nickname) for the group, used in email addresses and directory services.
membershipRule	String		Rule used to dynamically assign members to the group based on directory attributes.
membershipRuleProcessingState	String		Current processing state of the dynamic membership rule (for example, 'InProgress', 'UpdateComplete').
onPremisesDomainName	String		Domain name from the on-premises directory if synced from Active Directory.
onPremisesLastSyncDateTime	Datetime		Last date and time the group was synced from the on-premises directory.
onPremisesNetBiosName	String		NetBIOS name of the domain from which the group was synced.
onPremisesProvisioningErrors	String		List of any provisioning errors that occurred during on-premises sync.
onPremisesSamAccountName	String		Security Accounts Manager (SAM) account name for the group, if synced from on-premises.
onPremisesSecurityIdentifier	String		Security identifier (SID) for the group, used in access control for Windows systems.
onPremisesSyncEnabled	Bool		Indicates whether directory sync is enabled for the group from the on-premises environment.
preferredDataLocation	String		Preferred geographic location for storing data related to the group, such as 'North America'.
preferredLanguage	String		Preferred language for the group interface, emails, and other localized experiences.
proxyAddresses	String		List of email addresses associated with the group, including primary and aliases. Each address is separated by a comma and can include smtp, SMTP, or x500.
renewedDateTime	Datetime		The last time the group was renewed or updated in the directory.
securityEnabled	Bool		Indicates whether the group is security-enabled and can be used for access control.
securityIdentifier	String		SID for the group, used for security and identity operations.
serviceProvisioningErrors	String		Any errors encountered while provisioning services for the group, such as SharePoint or Teams.
theme	String		Custom UI theme assigned to the group for services like Microsoft Teams.
uniqueName	String		Globally unique name for the group, used for internal referencing and identification.
unseenCount	Int		Number of unseen items or notifications associated with the group (for example, in Teams or Outlook).
visibility	String		Defines group visibility level, such as Public, Private, or HiddenMembership.

Details sharing and access permissions for files and folders within a OneDrive drive, identifying owners and collaborators.

Table Specific Information

UserId and GroupId connection properties can also be used to filter records. If both are included in the connection string, UserId will take precedence over GroupId.

Due to API limitations, all operators on this view are executed client-side.

Columns

Name	Type	References	Description
id [KEY]	String		Unique identifier for the permission record.
Etag	String		Entity tag used for concurrency control to track updates to the permission.
ResourceId [KEY]	String		Identifier of the resource (file or folder) the permission applies to.
grantedTo_user_displayName	String		Display name of the user who has been granted access to the resource.
grantedTo_user_email	String		Email address of the user who has been granted access.
grantedTo_user_id	String		Unique identifier of the user granted access.
expirationDateTime	Datetime		Timestamp indicating when the permission will expire, if set.
grantedTo_application_displayName	String		Name of the application granted access to the resource.
grantedTo_application_id	String		Unique identifier of the application granted access.
grantedToIdentities	String		List of user or group identities that the permission has been granted to, separated by commas.
hasPassword	Bool		Indicates whether the shared link is protected by a password.
inheritedFrom_driveId	String		ID of the drive where the original permission was inherited from.
inheritedFrom_driveType	String		Type of the originating drive, such as personal or business.
inheritedFrom_id	String		ID of the resource from which the permission is inherited.
inheritedFrom_name	String		Name of the resource from which the permission is inherited.
inheritedFrom_path	String		Path to the source resource from which the permission is inherited.
inheritedFrom_shareId	String		ID of the sharing link associated with the inherited permission.
inheritedFrom_sharepointIds_listId	String		SharePoint list ID from which the permission is inherited.
inheritedFrom_sharepointIds_listItemId	String		ID of the SharePoint list item the permission is derived from.
inheritedFrom_sharepointIds_listItemUniqueId	String		Globally unique identifier (GUID) of the SharePoint list item.
inheritedFrom_sharepointIds_siteId	String		SharePoint site ID from which the permission originates.
inheritedFrom_sharepointIds_siteUrl	String		URL of the SharePoint site associated with the inherited permission.
inheritedFrom_sharepointIds_tenantId	String		Tenant ID associated with the originating SharePoint environment.
inheritedFrom_sharepointIds_webId	String		Web ID for the SharePoint subsite containing the original resource.
inheritedFrom_siteId	String		Site ID of the location from which the permission is inherited.
invitation_email	String		Email address of the person invited to access the resource.
invitation_invitedBy_application_displayName	String		Display name of the application that sent the sharing invitation.
invitation_invitedBy_application_id	String		ID of the application that issued the sharing invitation.
invitation_redeemedBy	String		Email or identifier of the person who accepted and redeemed the sharing invitation.
invitation_signInRequired	Bool		Indicates whether the recipient must sign in to access the resource.
link_application_displayName	String		Display name of the application that created the sharing link.
link_application_id	String		Unique identifier of the application that created the sharing link.
link_preventsDownload	Bool		Indicates whether downloading the shared content is restricted for viewers.
link_scope	String		Defines the access scope of the sharing link, such as anonymous, organization, or specific people.
link_type	String		Type of sharing link created (for example, view, edit, embed).
link_webHtml	String		HTML-formatted snippet that renders the sharing link for embedding in web pages.
link_webUrl	String		Direct web URL to access the shared item.
roles	String		Comma-separated list of roles granted by the permission, such as read, write, owner.
shareId	String		Unique identifier for the sharing instance, used to reference and manage shared access.

Identifies all files and folders that have been shared from OneDrive, along with recipients and access levels.

Table Specific Information

Select

Projection is performed server-side. In addition, queries that use the primary key Id with an IN filter are also executed server-side. For example:

SELECT Id, Name, Size, Shared_Scope FROM SharedResources WHERE Id IN ('B1E6BJ084A9133KB1!122', 'APF9D2K6WFAAPX9') 

Server-side filtering using ParentReference_Id is supported on the root drive when the AuthScheme property is set to AzureAD. However, it is not available for client-credential authentication. For example:

 SELECT * FROM SharedResources WHERE  ParentReference_id = '01QFG2V52Z62HOXS5F6RHIHVT36T3Q5GKH' 

For server-side filtering using ParentReference_Id with client-credential authentication (such as AzureServicePrincipal or AzureServicePrincipalCert), the createdBy_user_id column is required. For example:

 SELECT * FROM SharedResources WHERE  ParentReference_id = '01QFG2V52Z62HOXS5F6RHIHVT36T3Q5GKH' AND createdBy_user_id = '1c67f23f-8681-4c67-9c19-253e628442d5' 

UserId and GroupId connection properties can also be used to filter records. If both are included in the connection string, UserId will take precedence over GroupId.

The listing of SharedResources is done recursively using the DirectoryRetrievalDepth property. By default, this property is set to 5, which allows data retrieval for a total of six levels within the selected drive. This is because the first level corresponds to DirectoryRetrievalDepth=0.

You can set the value to -1 to retrieve all the shared resources in the drive, regardless of their depth.

Columns

Name	Type	References	Description
id [KEY]	String		Unique identifier for the item in the system.
Etag	String		Entity tag used for version control and detecting changes to the item.
createdBy_user_id	String		Identifier of the user who originally created the item.
createdBy_user_displayName	String		Display name of the user who created the item.
lastModifiedBy_user_id	String		Identifier of the user who most recently modified the item.
lastModifiedBy_user_displayName	String		Display name of the user who last modified the item.
createdBy_application_displayName	String		Display name of the application that created the item.
createdBy_application_id	String		Unique ID of the application that created the item.
createdDateTime	Datetime		Timestamp indicating when the item was created.
description	String		User-defined description or notes about the item.
lastModifiedBy_application_displayName	String		Display name of the application that last modified the item.
lastModifiedBy_application_id	String		Unique ID of the application that last modified the item.
lastModifiedDateTime	Datetime		Timestamp of the most recent modification to the item.
name	String		Name of the item (file or folder).
parentReference_driveId	String		ID of the drive where the item's parent is located.
parentReference_driveType	String		Type of drive hosting the item, such as personal or business.
parentReference_id	String		ID of the parent folder or item.
parentReference_name	String		Name of the parent folder or item.
parentReference_path	String		Full path to the parent folder or item.
parentReference_shareId	String		Sharing ID associated with the parent item for link-based sharing.
parentReference_sharepointIds_listId	String		SharePoint list ID where the item resides.
parentReference_sharepointIds_listItemId	String		Item ID in the SharePoint list for the parent item.
parentReference_sharepointIds_listItemUniqueId	String		Globally unique ID for the SharePoint list item.
parentReference_sharepointIds_siteId	String		SharePoint site ID that contains the parent item.
parentReference_sharepointIds_siteUrl	String		URL of the SharePoint site hosting the item.
parentReference_sharepointIds_tenantId	String		Tenant ID of the SharePoint organization.
parentReference_sharepointIds_webId	String		Web ID of the SharePoint subsite containing the item.
parentReference_siteId	String		ID of the parent site where the item is located.
webUrl	String		Web-accessible URL to view or access the item.
LinkedcreatedByUser	String		Link to metadata about the user who created the item.
LinkedlastModifiedByUser	String		Link to metadata about the user who last modified the item.
audio_album	String		Album title associated with the audio file.
audio_albumArtist	String		Primary artist of the album.
audio_artist	String		Performer or artist of the audio content.
audio_bitrate	Long		Bitrate of the audio file in bits per second.
audio_composers	String		Name of the composers for the audio content.
audio_copyright	String		Copyright information associated with the audio file.
audio_disc	Int		Disc number if the audio file is part of a multi-disc album.
audio_discCount	Int		Total number of discs in the audio album.
audio_duration	Long		Duration of the audio in milliseconds.
audio_genre	String		Genre or category of the audio content.
audio_hasDrm	Bool		Indicates whether the audio file is protected by DRM.
audio_isVariableBitrate	Bool		Indicates whether the audio file uses variable bitrate encoding.
audio_title	String		Title of the track within the audio file.
audio_track	Int		Track number in the album or playlist.
audio_trackCount	Int		Total number of tracks in the album.
audio_year	Int		Year the audio content was released or created.
content	String		Raw content of the item, usually encoded.
cTag	String		Change tag used for sync operations to detect item changes.
deleted_state	String		Status indicating if the item has been deleted (for example, deleted, notDeleted).
file_hashes_crc32Hash	String		CRC32 hash for integrity verification of the file content.
file_hashes_quickXorHash	String		QuickXor hash used by Microsoft to detect file content changes.
file_hashes_sha1Hash	String		SHA-1 hash for validating file integrity.
file_hashes_sha256Hash	String		SHA-256 hash for strong integrity verification of the file.
file_mimeType	String		MIME type of the file.
file_processingMetadata	Bool		Indicates whether additional processing metadata is present (such as for indexing).
fileSystemInfo_createdDateTime	Datetime		Timestamp when the file was created in the file system.
fileSystemInfo_lastAccessedDateTime	Datetime		Timestamp of the last time the file was accessed.
fileSystemInfo_lastModifiedDateTime	Datetime		Timestamp when the file was last modified in the file system.
folder_childCount	Int		Number of items contained in the folder.
folder_view_sortBy	String		Default attribute used to sort items in the folder view.
folder_view_sortOrder	String		Default sort order (ascending or descending) for the folder view.
folder_view_viewType	String		Type of view for the folder, such as list, grid, or thumbnails.
image_height	Int		Height of the image in pixels.
image_width	Int		Width of the image in pixels.
location_altitude	Double		Altitude, in meters, where the item was created (for media files).
location_latitude	Double		Latitude coordinate where the item was created.
location_longitude	Double		Longitude coordinate where the item was created.
package_type	String		Type of package or container, such as OneNote or ZIP.
pendingOperations_pendingContentUpdate_queuedDateTime	Datetime		Timestamp indicating when a pending update was queued for processing.
photo_cameraMake	String		Manufacturer of the camera used to take the photo.
photo_cameraModel	String		Model name or number of the camera used.
photo_exposureDenominator	Double		Denominator of the exposure time (for example, 1/125 ? 125).
photo_exposureNumerator	Double		Numerator of the exposure time.
photo_fNumber	Double		Aperture value (f-number) used to take the photo.
photo_focalLength	Double		Focal length of the lens, in millimeters.
photo_iso	Int		ISO sensitivity setting used when the photo was taken.
photo_orientation	Int		Orientation of the photo (for example, upright, rotated).
photo_takenDateTime	Datetime		Date and time when the photo was taken, from metadata.
publication_level	String		Level of publication assigned to the shared resource, used to define distribution or access tier.
publication_versionId	String		Identifier representing the version of the published shared resource.
remoteItem_createdBy_application_displayName	String		Display name of the application that created the shared remote item.
remoteItem_createdBy_application_id	String		Application ID of the app that created the shared remote item.
remoteItem_createdDateTime	Datetime		Timestamp indicating when the remote item was created.
remoteItem_file_hashes_crc32Hash	String		CRC32 hash value of the file content, used for integrity checks.
remoteItem_file_hashes_quickXorHash	String		QuickXor hash used by Microsoft services to detect changes in file content.
remoteItem_file_hashes_sha1Hash	String		SHA-1 hash of the file for verifying content integrity.
remoteItem_file_hashes_sha256Hash	String		SHA-256 hash of the file for secure content validation.
remoteItem_file_mimeType	String		MIME type of the file, such as application/pdf, image/png, text/plain.
remoteItem_file_processingMetadata	Bool		Indicates whether the file includes metadata for processing tasks such as indexing.
remoteItem_fileSystemInfo_createdDateTime	Datetime		Filesystem timestamp showing when the file was initially created.
remoteItem_fileSystemInfo_lastAccessedDateTime	Datetime		Timestamp showing the last time the file was accessed.
remoteItem_fileSystemInfo_lastModifiedDateTime	Datetime		Timestamp showing the last modification to the file in the filesystem.
remoteItem_folder_childCount	Int		Total number of child items contained within the shared folder.
remoteItem_folder_view_sortBy	String		Default field used to sort items in the folder view, such as name or dateModified.
remoteItem_folder_view_sortOrder	String		Sort direction used in the folder view, such as ascending or descending.
remoteItem_folder_view_viewType	String		Type of folder view, such as list, grid, or thumbnails.
remoteItem_id	String		Unique identifier of the shared remote item.
remoteItem_image_height	Int		Image height in pixels for the shared item, if it is an image file.
remoteItem_image_width	Int		Image width in pixels for the shared item, if it is an image file.
remoteItem_lastModifiedDateTime	Datetime		Timestamp indicating the last time the remote item was modified.
remoteItem_name	String		Name of the remote item that has been shared.
remoteItem_package_type	String		Type of package, such as OneNote or ZIP, associated with the shared item.
remoteItem_parentReference_driveId	String		Drive ID where the parent folder or item resides.
remoteItem_parentReference_driveType	String		Drive type where the parent is located, such as personal, business, or documentLibrary.
remoteItem_parentReference_id	String		ID of the parent item from which the remote item inherits.
remoteItem_parentReference_name	String		Name of the parent item containing the remote item.
remoteItem_parentReference_path	String		Path to the parent folder or item in the OneDrive hierarchy.
remoteItem_parentReference_shareId	String		Sharing ID used to identify the parent folder in shared contexts.
remoteItem_parentReference_sharepointIds_listId	String		ID of the SharePoint list containing the parent item.
remoteItem_parentReference_sharepointIds_listItemId	String		ID of the SharePoint list item corresponding to the parent item.
remoteItem_parentReference_sharepointIds_listItemUniqueId	String		Globally unique ID of the SharePoint list item for the parent.
remoteItem_parentReference_sharepointIds_siteId	String		Site ID in SharePoint where the parent item is located.
remoteItem_parentReference_sharepointIds_siteUrl	String		URL of the SharePoint site containing the parent item.
remoteItem_parentReference_sharepointIds_tenantId	String		Tenant ID associated with the SharePoint site.
remoteItem_parentReference_sharepointIds_webId	String		Web ID of the SharePoint site or subsite where the item exists.
remoteItem_parentReference_siteId	String		Site ID of the location where the shared resource resides.
remoteItem_shared_scope	String		Defines the access scope of the shared item, such as anonymous, organization, or users.
remoteItem_shared_sharedDateTime	Datetime		Timestamp indicating when the item was shared.
remoteItem_size	Long		Size of the shared resource in bytes.
remoteItem_specialFolder_name	String		Indicates whether the folder is a special system folder, such as Documents or Photos.
remoteItem_video_audioBitsPerSample	Int		Bit depth per audio sample in the video file.
remoteItem_video_audioChannels	Int		Number of audio channels in the video, such as 1 for mono or 2 for stereo.
remoteItem_video_audioFormat	String		Format or codec used for the audio track in the video.
remoteItem_video_audioSamplesPerSecond	Int		Audio sampling rate in Hertz for the video file.
remoteItem_video_bitrate	Int		Total bitrate of the video in bits per second.
remoteItem_video_duration	Long		Total duration of the video in milliseconds.
remoteItem_video_fourCC	String		Four-character code (FourCC) that identifies the video codec.
remoteItem_video_frameRate	Double		Frame rate of the video, expressed as frames per second.
remoteItem_video_height	Int		Height of the video frame in pixels.
remoteItem_video_width	Int		Width of the video frame in pixels.
remoteItem_webDavUrl	String		WebDAV-compatible URL for programmatic access to the remote item.
remoteItem_webUrl	String		Public-facing web URL for accessing the shared item.
searchResult_onClickTelemetryUrl	String		URL used for collecting telemetry when a shared item is clicked in search results.
shared_owner_application_displayName	String		Name of the application that owns the shared item.
shared_owner_application_id	String		Application ID of the application that owns the shared item.
shared_scope	String		Scope of sharing defined for the resource, such as anonymous, organization, or specific users.
shared_sharedDateTime	Datetime		Timestamp indicating when the sharing action took place.
sharepointIds_listId	String		Identifier for the SharePoint list containing the shared item.
sharepointIds_listItemId	String		Item ID within the SharePoint list.
sharepointIds_listItemUniqueId	String		Globally unique identifier for the SharePoint list item.
sharepointIds_siteId	String		ID of the SharePoint site hosting the shared resource.
sharepointIds_siteUrl	String		URL of the SharePoint site where the item resides.
sharepointIds_tenantId	String		Identifier of the Microsoft 365 tenant for the SharePoint environment.
sharepointIds_webId	String		ID of the web component in the SharePoint site structure.
size	Long		Size of the shared resource in bytes.
specialFolder_name	String		Name of the special folder if applicable, such as Music, Photos, or Videos.
video_audioBitsPerSample	Int		Bit depth for audio samples in standalone video metadata.
video_audioChannels	Int		Audio channel count in the video (standalone representation).
video_audioFormat	String		Audio codec or format used in standalone video metadata.
video_audioSamplesPerSecond	Int		Sampling rate of audio in standalone video metadata.
video_bitrate	Int		Bitrate of the standalone video in bits per second.
video_duration	Long		Duration of the standalone video in milliseconds.
video_fourCC	String		FourCC used in standalone video metadata to represent the codec.
video_frameRate	Double		Frame rate of the standalone video in frames per second.
video_height	Int		Video height in pixels (standalone metadata).
video_width	Int		Video width in pixels (standalone metadata).
webDavUrl	String		WebDAV endpoint URL for accessing the shared item using WebDAV clients.
Linkedanalytics	String		Link to analytics data related to the shared item, such as views or edits.
Linkedchildren	String		Link to the list of child items within a shared folder.
LinkedlistItem	String		Link to the corresponding SharePoint list item for the shared content.
Linkedpermissions	String		Link to permission settings associated with the shared resource.
Linkedsubscriptions	String		Link to any active subscriptions (such as webhooks) related to the shared item.
Linkedthumbnails	String		Link to thumbnail images associated with the shared item.
Linkedversions	String		Link to the version history of the shared item.
Linkedworkbook	String		Link to the Excel workbook interface if the shared item is an Excel file.

Lists files and folders that have been shared with the signed-in user by others, including metadata such as the owner, sharing permissions, and access details.

Table Specific Information

Due to API limitations, all operators on this view are executed client-side.

SharedWithMeResources 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		Unique identifier of the shared file or folder.
Etag	String		Entity tag used to detect changes to the shared item.
createdBy_user_id	String		ID of the user who originally created the shared item.
createdBy_user_displayName	String		Display name of the user who created the shared item.
lastModifiedBy_user_id	String		ID of the user who last modified the item.
lastModifiedBy_user_displayName	String		Display name of the user who last modified the item.
createdBy_application_displayName	String		Display name of the user who created the shared item.
createdBy_application_id	String		ID of the application that created the item.
createdDateTime	Datetime		Date and time when the item was created.
description	String		Optional description provided by the item owner.
lastModifiedBy_application_displayName	String		Name of the application that last modified the item.
lastModifiedBy_application_id	String		ID of the application that last modified the item.
lastModifiedDateTime	Datetime		Date and time of the last modification.
name	String		Name of the shared file or folder.
parentReference_driveId	String		ID of the drive where the shared item resides.
parentReference_driveType	String		Type of drive the item is shared from (for example, business or personal).
parentReference_id	String		ID of the parent folder that contains the shared item.
parentReference_name	String		Name of the parent folder containing the item.
parentReference_path	String		Path of the shared item within its source drive.
parentReference_shareId	String		Identifier used to access the shared resource.
parentReference_sharepointIds_listId	String		SharePoint list ID if the item is part of a list.
parentReference_sharepointIds_listItemId	String		SharePoint list item ID for the shared item.
parentReference_sharepointIds_listItemUniqueId	String		Unique SharePoint list item ID across the site.
parentReference_sharepointIds_siteId	String		ID of the SharePoint site that owns the item.
parentReference_sharepointIds_siteUrl	String		URL of the SharePoint site where the item is hosted.
parentReference_sharepointIds_tenantId	String		Tenant ID of the organization that shared the item.
parentReference_sharepointIds_webId	String		Web ID of the SharePoint subsite.
parentReference_siteId	String		ID of the overall site the item was shared from.
webUrl	String		Direct link to open the shared item in OneDrive.
LinkedcreatedByUser	String		Indicates whether the item is linked to its original creator.
LinkedlastModifiedByUser	String		Indicates whether the item is linked to the user who last modified it.
audio_album	String		Title of the album the audio file belongs to.
audio_albumArtist	String		Name of the album's primary artist.
audio_artist	String		Artist credited with the audio track.
audio_bitrate	Long		Bitrate of the audio file, measured in kilobits per second.
audio_composers	String		List of composers credited for the track.
audio_copyright	String		Copyright notice associated with the audio file.
audio_disc	Int		Disc number of the audio album, if part of a multi-disc set.
audio_discCount	Int		Total number of discs in the audio album.
audio_duration	Long		Duration of the audio file in milliseconds.
audio_genre	String		Genre classification of the audio content.
audio_hasDrm	Bool		Indicates whether the audio file is protected by Digital Rights Management (DRM).
audio_isVariableBitrate	Bool		Indicates whether the audio file uses variable bitrate encoding.
audio_title	String		Title of the audio track.
audio_track	Int		Track number of the audio file within its album.
audio_trackCount	Int		Total number of tracks in the album.
audio_year	Int		Year the audio track was released.
bundle_album_coverImageItemId	String		ID of the item used as the album's cover image.
bundle_childCount	Int		Number of child items (files or folders) in a bundled collection.
content	String		Binary content stream of the shared file. This field cannot be updated directly.
cTag	String		Tag used to represent the current state of the item's content.
deleted_state	String		Indicates whether the item is in a deleted or recycled state.
file_hashes_crc32Hash	String		CRC32 checksum of the file for basic integrity verification.
file_hashes_quickXorHash	String		QuickXor hash used for efficient file integrity checks.
file_hashes_sha1Hash	String		SHA-1 hash of the file used for content validation.
file_hashes_sha256Hash	String		SHA-256 hash of the file for secure content validation.
file_mimeType	String		MIME type describing the format of the file.
file_processingMetadata	Bool		Indicates whether the file includes metadata related to processing.
fileSystemInfo_createdDateTime	Datetime		Timestamp when the file was originally created.
fileSystemInfo_lastAccessedDateTime	Datetime		Timestamp of the most recent access to the file.
fileSystemInfo_lastModifiedDateTime	Datetime		Timestamp of the last modification to the file.
folder_childCount	Int		Number of items (files and subfolders) in the folder.
folder_view_sortBy	String		Field used to sort the folder's contents.
folder_view_sortOrder	String		Sort direction used (ascending or descending).
folder_view_viewType	String		Preferred display layout for the folder (for example, thumbnails or list).
image_height	Int		Height of the image in pixels.
image_width	Int		Width of the image in pixels.
location_altitude	Double		Altitude where the item, (such as a photo) was captured.
location_latitude	Double		Latitude where the item was captured.
location_longitude	Double		Longitude where the item was captured.
malware_description	String		Description of any malware detected in the file.
package_type	String		Type of package represented by the item (for example, notebook or folder).
pendingOperations_pendingContentUpdate_queuedDateTime	Datetime		Timestamp when a pending content update was queued.
photo_cameraMake	String		Camera manufacturer used to capture the photo.
photo_cameraModel	String		Camera model used to capture the photo.
photo_exposureDenominator	Double		Denominator of the exposure setting used (for example, 60 for 1/60 sec).
photo_exposureNumerator	Double		Numerator of the exposure setting used.
photo_fNumber	Double		F-number (aperture value) used to capture the photo.
photo_focalLength	Double		Focal length of the camera lens in millimeters.
photo_iso	Int		ISO sensitivity setting used when the photo was taken.
photo_orientation	Int		Orientation flag indicating how the image should be rotated or displayed.
photo_takenDateTime	Datetime		Timestamp when the photo was taken.
publication_checkedOutBy_application_displayName	String		Display name of the application that checked out the item.
publication_checkedOutBy_application_id	String		ID of the application that checked out the item.
publication_level	String		Publication level of the item (for example, draft or published).
publication_versionId	String		Version identifier of the published item.
remoteItem_createdBy_application_displayName	String		Name of the app that created the original file on a different drive.
remoteItem_createdBy_application_id	String		ID of the app that created the original file on a different drive.
remoteItem_createdDateTime	Datetime		Timestamp when the remote item was created.
remoteItem_file_hashes_crc32Hash	String		CRC32 checksum of the remote file for integrity validation.
remoteItem_file_hashes_quickXorHash	String		QuickXor hash used for fast integrity checks on the remote file.
remoteItem_file_hashes_sha1Hash	String		SHA-1 hash of the remote file content for validation.
remoteItem_file_hashes_sha256Hash	String		SHA-256 hash of the remote file content for secure verification.
remoteItem_file_mimeType	String		MIME type indicating the content format of the remote file.
remoteItem_file_processingMetadata	Bool		Indicates whether the remote file includes metadata used during processing.
remoteItem_fileSystemInfo_createdDateTime	Datetime		Timestamp indicating when the remote file was originally created.
remoteItem_fileSystemInfo_lastAccessedDateTime	Datetime		Timestamp of the most recent access to the remote file.
remoteItem_fileSystemInfo_lastModifiedDateTime	Datetime		Timestamp of the last modification made to the remote file.
remoteItem_folder_childCount	Int		Number of child items (files or subfolders) contained in the remote folder
remoteItem_folder_view_sortBy	String		Field used to sort the remote folder's contents (for example, name or date).
remoteItem_folder_view_sortOrder	String		Direction in which the remote folder�s contents are sorted (ascending or descending).
remoteItem_folder_view_viewType	String		Preferred display layout for viewing the contents of the remote folder (for example, list or thumbnails).
remoteItem_id	String		Unique identifier of the remote item that was shared.
remoteItem_image_height	Int		Height of the remote image file in pixels.
remoteItem_image_width	Int		Width of the remote image file in pixels.
remoteItem_lastModifiedDateTime	Datetime		Timestamp when the remote item was last modified.
remoteItem_name	String		Name of the remote file or folder.
remoteItem_package_type	String		Type of package the item represents (for example, notebook or folder).
remoteItem_parentReference_driveId	String		ID of the drive that hosts the shared remote item.
remoteItem_parentReference_driveType	String		Type of drive the remote item resides in (for example, personal or business).
remoteItem_parentReference_id	String		ID of the parent item or folder containing the remote item.
remoteItem_parentReference_name	String		Name of the parent item or folder.
remoteItem_parentReference_path	String		Full path to the remote item within the drive.
remoteItem_parentReference_shareId	String		Share ID that identifies the shared reference for the remote item.
remoteItem_parentReference_sharepointIds_listId	String		SharePoint list ID associated with the remote item.
remoteItem_parentReference_sharepointIds_listItemId	String		ID of the item within a SharePoint list.
remoteItem_parentReference_sharepointIds_listItemUniqueId	String		Globally Unique ID (GUID) of the SharePoint list item.
remoteItem_parentReference_sharepointIds_siteId	String		ID of the SharePoint site that contains the item.
remoteItem_parentReference_sharepointIds_siteUrl	String		URL of the SharePoint site hosting the remote item.
remoteItem_parentReference_sharepointIds_tenantId	String		ID of the Microsoft 365 tenant that owns the SharePoint content.
remoteItem_parentReference_sharepointIds_webId	String		Web ID of the SharePoint site collection.
remoteItem_parentReference_siteId	String		ID of the overall site associated with the remote item.
remoteItem_shared_scope	String		Scope of the remote item's sharing (for example, organization or users).
remoteItem_shared_sharedDateTime	Datetime		Timestamp of when the remote item was shared.
remoteItem_size	Long		Size of the remote item in bytes.
remoteItem_specialFolder_name	String		Name of the special folder type (for example, Documents or Photos) the remote item belongs to.
remoteItem_video_audioBitsPerSample	Int		Bit depth of the audio track, indicating the number of bits used to represent each audio sample.
remoteItem_video_audioChannels	Int		Number of audio channels in the video file, such as 2 for stereo or 6 for surround sound.
remoteItem_video_audioFormat	String		Format of the audio track in the video. For example, AAC or MP3.
remoteItem_video_audioSamplesPerSecond	Int		Audio sample rate, showing how many audio samples are captured per second (measured in hertz).
remoteItem_video_bitrate	Int		Bitrate of the video file, representing how much data is processed per second.
remoteItem_video_duration	Long		Length of the video in milliseconds.
remoteItem_video_fourCC	String		Four-character code (FourCC) identifying the video codec used.
remoteItem_video_frameRate	Double		Frame rate of the video, indicating how many frames are displayed per second.
remoteItem_video_height	Int		Height of the video resolution in pixels.
remoteItem_video_width	Int		Width of the video resolution in pixels.
remoteItem_webDavUrl	String		URL used to access the remote item via Web Distributed Authoring and Versioning (WebDAV).
remoteItem_webUrl	String		Web link to view the remote item in a browser.
searchResult_onClickTelemetryUrl	String		URL used for tracking clicks on search results, primarily for telemetry purposes.
shared_owner_application_displayName	String		Display name of the application that originally shared the item.
shared_owner_application_id	String		Unique ID of the application that originally shared the item.
shared_scope	String		Scope of sharing, such as whether the item is shared with specific users or more broadly across an organization.
shared_sharedDateTime	Datetime		Date and time the item was shared with the signed-in user.
sharepointIds_listId	String		ID of the SharePoint list containing the item.
sharepointIds_listItemId	String		ID of the specific item within the SharePoint list.
sharepointIds_listItemUniqueId	String		GUID for the list item across the SharePoint environment.
sharepointIds_siteId	String		ID of the SharePoint site that owns the item.
sharepointIds_siteUrl	String		URL of the SharePoint site where the item resides.
sharepointIds_tenantId	String		ID of the Microsoft 365 tenant associated with the SharePoint content.
sharepointIds_webId	String		ID of the web within the SharePoint site collection.
size	Long		Size of the shared item in bytes.
specialFolder_name	String		Name of the special folder category the item belongs to, such as Documents or Photos.
video_audioBitsPerSample	Int		Bit depth of the video's audio track.
video_audioChannels	Int		Number of audio channels in the video (for example, mono or stereo).
video_audioFormat	String		Audio codec used in the video file.
video_audioSamplesPerSecond	Int		Audio sampling rate of the video, measured in hertz.
video_bitrate	Int		Total bitrate of the video file.
video_duration	Long		Total duration of the video in milliseconds.
video_fourCC	String		FourCC identifying the video codec.
video_frameRate	Double		Number of frames per second in the video.
video_height	Int		Height of the video resolution in pixels.
video_width	Int		Width of the video resolution in pixels.
webDavUrl	String		WebDAV URL for accessing the item.
Linkedanalytics	String		Provides access to usage analytics for the shared item, such as views and interactions.
Linkedchildren	String		Lists child items contained within a folder.
LinkedlistItem	String		References the list item associated with the file if it is part of a SharePoint list.
Linkedpermissions	String		Lists the permissions granted on the shared item.
LinkedretentionLabel	String		Provides information about the retention label applied to the item for compliance.
Linkedsubscriptions	String		References any subscriptions related to the item, such as webhook notifications.
Linkedthumbnails	String		Provides access to image thumbnails associated with the item.
Linkedversions	String		Lists previous versions of the file for version history tracking.
Linkedworkbook	String		Reference to the Excel workbook object if the file is an Excel document.

Lists users with OneDrive accounts in the organization, including user identifiers and profile details.

Users Information

Projection is done server-side. Basic select query is supported e.g.:

SELECT * FROM Users

Using this view an admin user can list all other users details.

Columns

Name	Type	References	Description
id [KEY]	String		Unique identifier for the user object in the directory.
deletedDateTime	Datetime		Timestamp indicating when the user was deleted, if applicable.
accountEnabled	Bool		Indicates whether the user's account is currently active and can sign in.
businessPhones	String		List of business phone numbers associated with the user, separated by commas.
city	String		City specified in the user's business or work address.
companyName	String		Name of the user's employer or organization.
country	String		Country or region specified in the user's address.
createdDateTime	Datetime		Timestamp when the user account was created in the directory.
department	String		Department the user belongs to within the organization.
displayName	String		Full display name of the user, shown in directories and address books.
employeeHireDate	Datetime		Date the user was hired, used in HR and compliance contexts.
employeeId	String		Internal employee identifier assigned by the organization.
employeeOrgData_costCenter	String		Cost center to which the user is assigned for accounting or budgeting purposes.
employeeOrgData_division	String		Organizational division the user belongs to, such as Engineering or Sales.
employeeType	String		Type of employment, such as FullTime, Contractor, or Temporary.
givenName	String		User's first name or given name.
identities	String		List of sign-in identities (such as email, user ID) associated with the user.
imAddresses	String		List of instant messaging addresses (such as Skype or Teams), separated by commas.
isResourceAccount	Bool		Indicates whether the account is used as a resource, such as a conference room or shared mailbox.
jobTitle	String		Job title or role of the user in the organization.
lastPasswordChangeDateTime	Datetime		Date and time the user last changed their password.
mail	String		Primary email address of the user.
mailNickname	String		Alias or mail nickname used in email routing and internal references.
mobilePhone	String		User's mobile or cell phone number.
officeLocation	String		User's office room number or location description.
onPremisesDistinguishedName	String		Distinguished Name (DN) of the user in the on-premises Active Directory.
onPremisesDomainName	String		Domain name of the on-premises environment where the user is managed.
onPremisesExtensionAttributes_extensionAttribute1	String		Custom extension attribute 1 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute10	String		Custom extension attribute 10 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute11	String		Custom extension attribute 11 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute12	String		Custom extension attribute 12 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute13	String		Custom extension attribute 13 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute14	String		Custom extension attribute 14 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute15	String		Custom extension attribute 15 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute2	String		Custom extension attribute 2 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute3	String		Custom extension attribute 3 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute4	String		Custom extension attribute 4 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute5	String		Custom extension attribute 5 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute6	String		Custom extension attribute 6 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute7	String		Custom extension attribute 7 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute8	String		Custom extension attribute 8 from on-premises Active Directory.
onPremisesExtensionAttributes_extensionAttribute9	String		Custom extension attribute 9 from on-premises Active Directory.
onPremisesImmutableId	String		Unique ID used to map the cloud user to the on-premises AD user object.
onPremisesLastSyncDateTime	Datetime		Timestamp of the last sync operation from on-premises Active Directory.
onPremisesProvisioningErrors	String		List of errors that occurred during provisioning or sync from on-premises AD.
onPremisesSamAccountName	String		Security Account Manager (SAM) name used in Windows logon scenarios.
onPremisesSecurityIdentifier	String		Security identifier (SID) for the user in the on-premises AD environment.
onPremisesSyncEnabled	Bool		Indicates whether the user object is synchronized from on-premises Active Directory.
onPremisesUserPrincipalName	String		User principal name (UPN) used in the on-premises environment.
otherMails	String		List of additional email addresses associated with the user, separated by commas.
postalCode	String		Postal or ZIP code of the user's business address.
preferredLanguage	String		Preferred language for communications and system interfaces.
state	String		State or province listed in the user's address.
streetAddress	String		Street portion of the user's business address.
surname	String		User's last name or family name.
userPrincipalName	String		UPN used to log in, typically in the format [email protected].
userType	String		Type of user account, such as Member, Guest, or External.

ストアドプロシージャはファンクションライクなインターフェースで、Microsoft OneDrive の単純なSELECT 処理にとどまらずCloud の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにMicrosoft OneDrive から関連するレスポンスデータを返します。

CData Cloud - Microsoft OneDrive ストアドプロシージャ

Name	Description
CopyResource	Copies a specified file or folder from one location in OneDrive to another, preserving content and structure.
CreateFolder	Creates a new folder at a specified path within OneDrive to organize content.
CreateSubscription	Registers a webhook subscription to receive notifications for changes to OneDrive content (for example, file updates).
DeleteResource	Permanently deletes a specified file or folder from OneDrive, removing it from all views and history.
DeleteSubscription	Removes an existing webhook subscription to stop receiving change notifications from OneDrive.
FetchAdditionalUserFields	Retrieves tiered metadata fields (T1, T2, T3) for a specific user, typically for profiling or auditing.
GetAdminConsentURL	Generates a URL that an admin must visit to grant tenant-wide OAuth permissions to your app; used when setting up enterprise integrations.
ModifySubscription	Creates or updates a webhook subscription to listen for changes in OneDrive files, folders, or other resources.
MoveResource	Relocates a file or folder within the OneDrive directory structure, maintaining metadata and permissions.
RenameResource	Changes the name of a specified file or folder in OneDrive without affecting its contents or location.

Copies a specified file or folder from one location in OneDrive to another, preserving content and structure.

Input

Name	Type	Required	Description
ParentID	String	True	ID of the destination folder where the resource should be copied. Required if the resource is being moved to a different location.
NewName	String	False	Optional new name for the copied resource. If not provided, the resource retains its original name and can be copied to its current location regardless of ParentID.
ResourcePath	String	False	Path to the resource being copied. Either ResourcePath or ResourceId must be provided to identify the source file or folder.
ResourceId	String	False	Unique ID of the resource to be copied. Either ResourceId or ResourcePath must be provided.
SourceDriveId	String	False	ID of the source drive where the resource currently resides. Only required when the resource is in a different drive than the user's default.
DestinationDriveId	String	False	ID of the target drive where the resource should be copied. Needed when the destination is in a different drive than the source.

Result Set Columns

Name	Type	Description
Success	String	Indicates whether the copy operation was successful. Returns success status or error details.

Creates a new folder at a specified path within OneDrive to organize content.

Input

Name	Type	Required	Description
FolderName	String	True	Name to assign to the new folder being created.
RenameIfExists	String	False	Set to 'true' to automatically rename the new folder if a folder with the same name already exists in the target location.
ParentId	String	False	ID of the parent folder where the new folder should be created.
DriveId	String	False	ID of the target drive where the new folder will be created. Use this when creating the folder in a drive other than the user's default drive.

Result Set Columns

Name	Type	Description
Id	String	Unique identifier assigned to the newly created folder.

Registers a webhook subscription to receive notifications for changes to OneDrive content (for example, file updates).

Input

Name	Type	Required	Description
ChangeType	String	True	Specifies the types of changes to monitor for the resource. Supported values are: created, updated, deleted. Multiple values can be provided as a comma-separated list, with a space after each comma.
NotificationUrl	String	True	HTTPS endpoint URL that will receive change notifications when the specified resource changes.
Resource	String	True	Path to the resource to monitor for changes. The path should not include the base URL such as https://graph.microsoft.com/v1.0/.
ExpirationDateTime	String	True	UTC timestamp indicating when the subscription should expire. The maximum allowed duration depends on the resource type being monitored.
ClientState	String	False	Custom string value, up to 128 characters, sent back with each notification to help validate that the notification came from the expected source.

Result Set Columns

Name	Type	Description
Id	String	Unique identifier assigned to the newly created subscription.

Permanently deletes a specified file or folder from OneDrive, removing it from all views and history.

Input

Name	Type	Required	Description
ResourcePath	String	False	Path to the resource that should be deleted. Either ResourcePath or ResourceId must be provided to identify the item.
ResourceId	String	False	Unique ID of the resource to be deleted. Either ResourceId or ResourcePath must be provided.
DriveId	String	False	ID of the drive that contains the resource. Specify this only if the resource is in a drive other than the current user's default drive.
Permanently	Boolean	False	Set to 'true' to permanently delete the resource. If not specified or set to 'false', the resource is moved to the recycle bin instead. デフォルト値はfalseです。

Result Set Columns

Name	Type	Description
Success	String	Indicates whether the delete operation was successful. Returns success status or error information.

Removes an existing webhook subscription to stop receiving change notifications from OneDrive.

Input

Name	Type	Required	Description
Id	String	True	Unique identifier of the subscription to be deleted.

Result Set Columns

Name	Type	Description
Success	String	Indicates the result of the delete operation. Returns success status or error details if the subscription could not be removed.

Retrieves tiered metadata fields (T1, T2, T3) for a specific user, typically for profiling or auditing.

Input

Name	Type	Required	Description
UserId	String	True	Unique identifier of the user whose additional fields are being retrieved.
IncludeFields	String	False	Comma-separated list of specific user fields to include in the results. Add 1 space after each comma in the list.
ExcludeFields	String	False	Comma-separated list of specific user fields to exclude from the results. Add 1 space after each comma in the list.

Result Set Columns

Name	Type	Description
*	String	Returns all user fields available in the schema, including any requested additional fields and excluding any specified in ExcludeFields.

Generates a URL that an admin must visit to grant tenant-wide OAuth permissions to your app; used when setting up enterprise integrations.

Input

Name	Type	Required	Description
CallbackUrl	String	False	The URL to which the user is redirected after authorizing the application. This must exactly match the reply URL configured in the Azure AD application settings.
State	String	False	Space-separated list of permissions the application is requesting from the administrator. Each scope defines a level of access.
Scope	String	False	Space-separated list of permissions the application is requesting from the administrator. Each scope defines a level of access. デフォルト値はhttps://graph.microsoft.com/files.readwrite.allです。

Result Set Columns

Name	Type	Description
URL	String	The full authorization URL that should be opened in a web browser to prompt the admin for consent and return an authorization code.

Creates or updates a webhook subscription to listen for changes in OneDrive files, folders, or other resources.

Input

Name	Type	Required	Description
ExpirationDateTime	String	True	UTC timestamp indicating the new expiration time for the subscription.
Id	String	True	Unique identifier of the subscription to be modified.

Result Set Columns

Name	Type	Description
Id	String	Unique identifier of the updated subscription.
ChangeType	String	Type of change that triggers the subscription. Possible values include created, updated, deleted.
NotificationUrl	String	Webhook URL that receives notifications when the subscribed resource changes.
Resource	String	Relative path of the resource the subscription applies to. Does not include the base Microsoft Graph URL.
ExpirationDateTime	String	Updated UTC expiration timestamp of the subscription.
ClientState	String	Custom string provided at subscription creation, returned in each change notification to verify source authenticity.

Relocates a file or folder within the OneDrive directory structure, maintaining metadata and permissions.

Stored Procedure Specific Information

Microsoft OneDrive allows only a small subset of columns to be used in the Exec query. DestinationID and either of ResourcePath or ResourceId is required to move the resource. These columns can typically be used with only = comparison.

If file is present in the root folder of a OneDrive account, then mention the file name directly for the value of ResourcePath. For example:

EXECUTE MoveResource ResourcePath = 'Book.xlsx', DestinationID = '01JSGDQ3MFCITWE4PQKFAY6KH5LHJKPYU5'

If file is present inside a child folder of a OneDrive account, then you need to specify the path of the file starting from child folder name for the value of ResourcePath. For example:

EXECUTE MoveResource ResourcePath = 'Notebooks/test.png', DestinationID = '01JSGDQ3MFCITWE4PQKFAY6KH5LHJKPYU5'

You can also move the resource by providing the ResourceId and DestinationID as well. For example:

EXECUTE MoveResource ResourceId = '01CYQN2MFPR6NIWVZNMNFL3SL4E3KF7IHY', DestinationID = '01JSGDQ3MFCITWE4PQKFAY6KH5LHJKPYU5'

Input

Name	Type	Required	Description
DestinationID	String	True	ID of the destination folder where the resource should be moved.
ResourcePath	String	False	Path to the resource to be moved. Either ResourcePath or ResourceId must be provided to identify the item.
ResourceId	String	False	Unique identifier of the resource to move. Either ResourceId or ResourcePath must be provided.
DriveId	String	False	ID of the drive containing the resource. Required only if the resource is located in a drive different from the user's default drive.

Result Set Columns

Name	Type	Description
Success	String	Indicates whether the move operation was successful. Returns success status or error details.

Changes the name of a specified file or folder in OneDrive without affecting its contents or location.

Input

Name	Type	Required	Description
ResourceId	String	True	Unique identifier of the resource to be renamed.
Name	String	True	New name to assign to the resource.
DriveId	String	False	ID of the drive where the resource is located. Specify this only if the resource is not in the current user's default drive.

Result Set Columns

Name	Type	Description
Success	String	Indicates whether the rename operation was successful. Returns success status or error details.

このセクションで説明されているシステムテーブルをクエリして、スキーマ情報、データソース機能に関する情報、およびバッチ操作の統計にアクセスできます。

スキーマテーブル

以下のテーブルは、Microsoft OneDrive のデータベースメタデータを返します。

• sys_catalogs：利用可能なデータベースをリスト。
• sys_schemas：利用可能なスキーマをリスト。
• sys_tables：利用可能なテーブルおよびビューをリスト。
• sys_tablecolumns：利用可能なテーブルおよびビューのカラムについて説明。
• sys_procedures：利用可能なストアドプロシージャについて説明。
• sys_procedureparameters：ストアドプロシージャパラメータについて説明。
• sys_keycolumns：主キーおよび外部キーについて説明。
• sys_indexes：利用可能なインデックスについて説明。

データソーステーブル

以下のテーブルは、データソースへの接続方法およびクエリ方法についての情報を返します。

• sys_connection_props：利用可能な接続プロパティについての情報を返す。
• sys_sqlinfo：Cloud がデータソースにオフロードできるSELECT クエリについて説明。

クエリ情報テーブル

次のテーブルは、データ変更クエリのクエリ統計を返します。

• sys_identity：バッチ処理または単一の更新に関する情報を返す。

利用可能なデータベースをリストします。

次のクエリは、接続文字列で決定されるすべてのデータベースを取得します。

SELECT * FROM sys_catalogs

Columns

Name	Type	Description
CatalogName	String	データベース名。

利用可能なスキーマをリストします。

次のクエリは、すべての利用可能なスキーマを取得します。

          SELECT * FROM sys_schemas
          

Columns

Name	Type	Description
CatalogName	String	データベース名。
SchemaName	String	スキーマ名。

利用可能なテーブルをリストします。

次のクエリは、利用可能なテーブルおよびビューを取得します。

          SELECT * FROM sys_tables
          

Columns

Name	Type	Description
CatalogName	String	テーブルまたはビューを含むデータベース。
SchemaName	String	テーブルまたはビューを含むスキーマ。
TableName	String	テーブル名またはビュー名。
TableType	String	テーブルの種類（テーブルまたはビュー）。
Description	String	テーブルまたはビューの説明。
IsUpdateable	Boolean	テーブルが更新可能かどうか。

利用可能なテーブルおよびビューのカラムについて説明します。

次のクエリは、Files テーブルのカラムとデータ型を返します。

SELECT ColumnName, DataTypeName FROM sys_tablecolumns WHERE TableName='Files' 

Columns

Name	Type	Description
CatalogName	String	テーブルまたはビューを含むデータベースの名前。
SchemaName	String	テーブルまたはビューを含むスキーマ。
TableName	String	カラムを含むテーブルまたはビューの名前。
ColumnName	String	カラム名。
DataTypeName	String	データ型の名前。
DataType	Int32	データ型を示す整数値。この値は、実行時に環境に基づいて決定されます。
Length	Int32	カラムのストレージサイズ。
DisplaySize	Int32	指定されたカラムの通常の最大幅（文字数）。
NumericPrecision	Int32	数値データの最大桁数。文字データおよび日時データの場合は、カラムの長さ（文字数）。
NumericScale	Int32	カラムのスケール（小数点以下の桁数）。
IsNullable	Boolean	カラムがNull を含められるかどうか。
Description	String	カラムの簡単な説明。
Ordinal	Int32	カラムのシーケンスナンバー。
IsAutoIncrement	String	カラムに固定増分値が割り当てられるかどうか。
IsGeneratedColumn	String	生成されたカラムであるかどうか。
IsHidden	Boolean	カラムが非表示かどうか。
IsArray	Boolean	カラムが配列かどうか。
IsReadOnly	Boolean	カラムが読み取り専用かどうか。
IsKey	Boolean	sys_tablecolumns から返されたフィールドがテーブルの主キーであるかどうか。
ColumnType	String	スキーマ内のカラムの役割または分類。可能な値は、SYSTEM、LINKEDCOLUMN、NAVIGATIONKEY、REFERENCECOLUMN、およびNAVIGATIONPARENTCOLUMN が含まれます。

利用可能なストアドプロシージャをリストします。

次のクエリは、利用可能なストアドプロシージャを取得します。

          SELECT * FROM sys_procedures
          

Columns

Name	Type	Description
CatalogName	String	ストアドプロシージャを含むデータベース。
SchemaName	String	ストアドプロシージャを含むスキーマ。
ProcedureName	String	ストアドプロシージャの名前。
Description	String	ストアドプロシージャの説明。
ProcedureType	String	PROCEDURE やFUNCTION などのプロシージャのタイプ。

ストアドプロシージャパラメータについて説明します。

次のクエリは、DownloadResource ストアドプロシージャのすべての入力パラメータについての情報を返します。

SELECT * FROM sys_procedureparameters WHERE ProcedureName = 'DownloadResource' AND Direction = 1 OR Direction = 2

パラメータに加えて結果セットのカラムを含めるには、IncludeResultColumns 擬似カラムをTrue に設定します。

SELECT * FROM sys_procedureparameters WHERE ProcedureName = 'DownloadResource' AND IncludeResultColumns='True'

Columns

Name	Type	Description
CatalogName	String	ストアドプロシージャを含むデータベースの名前。
SchemaName	String	ストアドプロシージャを含むスキーマの名前。
ProcedureName	String	パラメータを含むストアドプロシージャの名前。
ColumnName	String	ストアドプロシージャパラメータの名前。
Direction	Int32	パラメータのタイプに対応する整数値：input (1)。input/output (2)、またはoutput(4)。input/output タイプパラメータは、入力パラメータと出力パラメータの両方になれます。
DataType	Int32	データ型を示す整数値。この値は、実行時に環境に基づいて決定されます。
DataTypeName	String	データ型の名前。
NumericPrecision	Int32	数値データの場合は最大精度。文字データおよび日時データの場合は、カラムの長さ（文字数）。
Length	Int32	文字データの場合は、許可される文字数。数値データの場合は、許可される桁数。
NumericScale	Int32	数値データの小数点以下の桁数。
IsNullable	Boolean	パラメータがNull を含められるかどうか。
IsRequired	Boolean	プロシージャの実行にパラメータが必要かどうか。
IsArray	Boolean	パラメータが配列かどうか。
Description	String	パラメータの説明。
Ordinal	Int32	パラメータのインデックス。
Values	String	このパラメータで設定できる値は、このカラムに表示されるものに限られます。指定できる値はカンマ区切りです。
SupportsStreams	Boolean	パラメータがファイルを表すかどうか。ファイルは、ファイルパスとして渡すことも、ストリームとして渡すこともできます。
IsPath	Boolean	パラメータがスキーマ作成操作のターゲットパスかどうか。
Default	String	何も値が指定されていない場合に、このパラメータで使用される値。
SpecificName	String	複数のストアドプロシージャが同じ名前を持つ場合、それぞれの同名のストアドプロシージャを一意に識別するラベル。特定の名前を持つプロシージャが1つだけの場合は、その名前がここに単純に反映されます。
IsCDataProvided	Boolean	プロシージャがネイティブのMicrosoft OneDrive プロシージャではなく、CData によって追加 / 実装されているかどうか。

Pseudo-Columns

Name	Type	Description
IncludeResultColumns	Boolean	出力にパラメータに加えて結果セットのカラムを含めるかどうか。デフォルトはFalse です。

主キーおよび外部キーについて説明します。

次のクエリは、Files テーブルの主キーを取得します。

         SELECT * FROM sys_keycolumns WHERE IsKey='True' AND TableName='Files' 
          

Columns

Name	Type	Description
CatalogName	String	キーを含むデータベースの名前。
SchemaName	String	キーを含むスキーマの名前。
TableName	String	キーを含むテーブルの名前。
ColumnName	String	キーカラムの名前
IsKey	Boolean	カラムがTableName フィールドで参照されるテーブル内の主キーかどうか。
IsForeignKey	Boolean	カラムがTableName フィールドで参照される外部キーかどうか。
PrimaryKeyName	String	主キーの名前。
ForeignKeyName	String	外部キーの名前。
ReferencedCatalogName	String	主キーを含むデータベース。
ReferencedSchemaName	String	主キーを含むスキーマ。
ReferencedTableName	String	主キーを含むテーブル。
ReferencedColumnName	String	主キーのカラム名。

外部キーについて説明します。

次のクエリは、他のテーブルを参照するすべての外部キーを取得します。

         SELECT * FROM sys_foreignkeys WHERE ForeignKeyType = 'FOREIGNKEY_TYPE_IMPORT'
          

カラム

名前	タイプ	説明
CatalogName	String	キーを含むデータベースの名前。
SchemaName	String	キーを含むスキーマの名前。
TableName	String	キーを含むテーブルの名前。
ColumnName	String	キーカラムの名前
PrimaryKeyName	String	主キーの名前。
ForeignKeyName	String	外部キーの名前。
ReferencedCatalogName	String	主キーを含むデータベース。
ReferencedSchemaName	String	主キーを含むスキーマ。
ReferencedTableName	String	主キーを含むテーブル。
ReferencedColumnName	String	主キーのカラム名。
ForeignKeyType	String	外部キーがインポート（他のテーブルを指す）キーかエクスポート（他のテーブルから参照される）キーかを指定します。

主キーについて説明します。

次のクエリは、すべてのテーブルとビューから主キーを取得します。

         SELECT * FROM sys_primarykeys
          

Columns

Name	Type	Description
CatalogName	String	キーを含むデータベースの名前。
SchemaName	String	キーを含むスキーマの名前。
TableName	String	キーを含むテーブルの名前。
ColumnName	String	キーカラムの名前。
KeySeq	String	主キーのシーケンス番号。
KeyName	String	主キーの名前。

利用可能なインデックスについて説明します。インデックスをフィルタリングすることで、より高速なクエリ応答時間でセレクティブクエリを記述できます。

次のクエリは、主キーでないすべてのインデックスを取得します。

          SELECT * FROM sys_indexes WHERE IsPrimary='false'
          

Columns

Name	Type	Description
CatalogName	String	インデックスを含むデータベースの名前。
SchemaName	String	インデックスを含むスキーマの名前。
TableName	String	インデックスを含むテーブルの名前。
IndexName	String	インデックス名。
ColumnName	String	インデックスに関連付けられたカラムの名前。
IsUnique	Boolean	インデックスが固有の場合はTrue。そうでない場合はFalse。
IsPrimary	Boolean	インデックスが主キーの場合はTrue。そうでない場合はFalse。
Type	Int16	インデックスタイプに対応する整数値：statistic (0)、clustered (1)、hashed (2)、またはother (3)。
SortOrder	String	並べ替え順序：A が昇順、D が降順。
OrdinalPosition	Int16	インデックスのカラムのシーケンスナンバー。

利用可能な接続プロパティと、接続文字列に設定されている接続プロパティに関する情報を返します。

次のクエリは、接続文字列に設定されている、あるいはデフォルト値で設定されているすべての接続プロパティを取得します。

SELECT * FROM sys_connection_props WHERE Value <> ''

Columns

Name	Type	Description
Name	String	接続プロパティ名。
ShortDescription	String	簡単な説明。
Type	String	接続プロパティのデータ型。
Default	String	明示的に設定されていない場合のデフォルト値。
Values	String	可能な値のカンマ区切りリスト。別な値が指定されていると、検証エラーがスローされます。
Value	String	設定した値またはあらかじめ設定されたデフォルト。
Required	Boolean	プロパティが接続に必要かどうか。
Category	String	接続プロパティのカテゴリ。
IsSessionProperty	String	プロパティが、現在の接続に関する情報を保存するために使用されるセッションプロパティかどうか。
Sensitivity	String	プロパティの機密度。これは、プロパティがロギングおよび認証フォームで難読化されているかどうかを通知します。
PropertyName	String	キャメルケースの短縮形の接続プロパティ名。
Ordinal	Int32	パラメータのインデックス。
CatOrdinal	Int32	パラメータカテゴリのインデックス。
Hierarchy	String	このプロパティと一緒に設定する必要がある、関連のある依存プロパティを表示します。
Visible	Boolean	プロパティが接続UI に表示されるかどうかを通知します。
ETC	String	プロパティに関するその他のさまざまな情報。

Cloud がデータソースにオフロードできるSELECT クエリ処理について説明します。

SQL 構文の詳細については、SQL 準拠 を参照してください。

データソースのSELECT 機能

以下はSQL 機能のサンプルデータセットです。 SELECT 機能のいくつかの側面がサポートされている場合には、カンマ区切りのリストで返されます。サポートされていない場合、カラムにはNO が入ります。

名前	説明	有効な値
AGGREGATE_FUNCTIONS	サポートされている集計関数。	AVG, COUNT, MAX, MIN, SUM, DISTINCT
COUNT	COUNT 関数がサポートされているかどうか。	YES, NO
IDENTIFIER_QUOTE_OPEN_CHAR	識別子をエスケープするための開始文字。	[
IDENTIFIER_QUOTE_CLOSE_CHAR	識別子をエスケープするための終了文字。	]
SUPPORTED_OPERATORS	サポートされているSQL 演算子。	=, >, <, >=, <=, <>, !=, LIKE, NOT LIKE, IN, NOT IN, IS NULL, IS NOT NULL, AND, OR
GROUP_BY	GROUP BY がサポートされているかどうか。サポートされている場合、どのレベルでサポートされているか。	NO, NO_RELATION, EQUALS_SELECT, SQL_GB_COLLATE
OJ_CAPABILITIES	サポートされている外部結合の種類。	NO, LEFT, RIGHT, FULL, INNER, NOT_ORDERED, ALL_COMPARISON_OPS
OUTER_JOINS	外部結合がサポートされているかどうか。	YES, NO
SUBQUERIES	サブクエリがサポートされているかどうか。サポートされていれば、どのレベルでサポートされているか。	NO, COMPARISON, EXISTS, IN, CORRELATED_SUBQUERIES, QUANTIFIED
STRING_FUNCTIONS	サポートされている文字列関数。	LENGTH, CHAR, LOCATE, REPLACE, SUBSTRING, RTRIM, LTRIM, RIGHT, LEFT, UCASE, SPACE, SOUNDEX, LCASE, CONCAT, ASCII, REPEAT, OCTET, BIT, POSITION, INSERT, TRIM, UPPER, REGEXP, LOWER, DIFFERENCE, CHARACTER, SUBSTR, STR, REVERSE, PLAN, UUIDTOSTR, TRANSLATE, TRAILING, TO, STUFF, STRTOUUID, STRING, SPLIT, SORTKEY, SIMILAR, REPLICATE, PATINDEX, LPAD, LEN, LEADING, KEY, INSTR, INSERTSTR, HTML, GRAPHICAL, CONVERT, COLLATION, CHARINDEX, BYTE
NUMERIC_FUNCTIONS	サポートされている数値関数。	ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, COT, EXP, FLOOR, LOG, MOD, SIGN, SIN, SQRT, TAN, PI, RAND, DEGREES, LOG10, POWER, RADIANS, ROUND, TRUNCATE
TIMEDATE_FUNCTIONS	サポートされている日付および時刻関数。	NOW, CURDATE, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, MONTH, QUARTER, WEEK, YEAR, CURTIME, HOUR, MINUTE, SECOND, TIMESTAMPADD, TIMESTAMPDIFF, DAYNAME, MONTHNAME, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, EXTRACT
REPLICATION_SKIP_TABLES	レプリケーション中にスキップされたテーブルを示します。
REPLICATION_TIMECHECK_COLUMNS	レプリケーション中に更新判断のカラムとして使用するかどうかを、（指定された順に）チェックするカラムのリストを含む文字列の配列。
IDENTIFIER_PATTERN	識別子としてどの文字列が有効かを示す文字列値。
SUPPORT_TRANSACTION	プロバイダーが、コミットやロールバックなどのトランザクションをサポートしているかどうかを示します。	YES, NO
DIALECT	使用するSQL ダイアレクトを示します。
KEY_PROPERTIES	Uniform データベースを特定するプロパティを示します。
SUPPORTS_MULTIPLE_SCHEMAS	プロバイダー用に複数のスキームが存在するかどうかを示します。	YES, NO
SUPPORTS_MULTIPLE_CATALOGS	プロバイダー用に複数のカタログが存在するかどうかを示します。	YES, NO
DATASYNCVERSION	このドライバーにアクセスするために必要な、CData Sync のバージョン。	Standard, Starter, Professional, Enterprise
DATASYNCCATEGORY	このドライバーのCData Sync カテゴリ。	Source, Destination, Cloud Destination
SUPPORTSENHANCEDSQL	API で提供されている以上の、追加SQL 機能がサポートされているかどうか。	TRUE, FALSE
SUPPORTS_BATCH_OPERATIONS	バッチ操作がサポートされているかどうか。	YES, NO
SQL_CAP	このドライバーでサポートされているすべてのSQL 機能。	SELECT, INSERT, DELETE, UPDATE, TRANSACTIONS, ORDERBY, OAUTH, ASSIGNEDID, LIMIT, LIKE, BULKINSERT, COUNT, BULKDELETE, BULKUPDATE, GROUPBY, HAVING, AGGS, OFFSET, REPLICATE, COUNTDISTINCT, JOINS, DROP, CREATE, DISTINCT, INNERJOINS, SUBQUERIES, ALTER, MULTIPLESCHEMAS, GROUPBYNORELATION, OUTERJOINS, UNIONALL, UNION, UPSERT, GETDELETED, CROSSJOINS, GROUPBYCOLLATE, MULTIPLECATS, FULLOUTERJOIN, MERGE, JSONEXTRACT, BULKUPSERT, SUM, SUBQUERIESFULL, MIN, MAX, JOINSFULL, XMLEXTRACT, AVG, MULTISTATEMENTS, FOREIGNKEYS, CASE, LEFTJOINS, COMMAJOINS, WITH, LITERALS, RENAME, NESTEDTABLES, EXECUTE, BATCH, BASIC, INDEX
PREFERRED_CACHE_OPTIONS	使用したいcacheOptions を指定する文字列値。
ENABLE_EF_ADVANCED_QUERY	ドライバーがEntity Framework の高度なクエリをサポートしているかどうかを示します。サポートしていなければ、クエリはクライアントサイドで処理されます。	YES, NO
PSEUDO_COLUMNS	利用可能な疑似カラムを示す文字列の配列。
MERGE_ALWAYS	値がtrue であれば、CData Sync 内でMerge Model が強制的に実行されます。	TRUE, FALSE
REPLICATION_MIN_DATE_QUERY	レプリケート開始日時を返すSELECT クエリ。
REPLICATION_MIN_FUNCTION	サーバーサイドでmin を実行するために使用する式名を、プロバイダーが指定できるようになります。
REPLICATION_START_DATE	レプリケート開始日を、プロバイダーが指定できるようになります。
REPLICATION_MAX_DATE_QUERY	レプリケート終了日時を返すSELECT クエリ。
REPLICATION_MAX_FUNCTION	サーバーサイドでmax を実行するために使用する式名を、プロバイダーが指定できるようになります。
IGNORE_INTERVALS_ON_INITIAL_REPLICATE	初回のレプリケートで、レプリケートをチャンクに分割しないテーブルのリスト。
CHECKCACHE_USE_PARENTID	CheckCache 構文を親キーカラムに対して実行するかどうかを示します。	TRUE, FALSE
CREATE_SCHEMA_PROCEDURES	スキーマファイルの生成に使用できる、ストアドプロシージャを示します。

次のクエリは、WHERE 句で使用できる演算子を取得します。

SELECT * FROM sys_sqlinfo WHERE Name = 'SUPPORTED_OPERATORS'

WHERE 句では、個々のテーブルの制限や要件が異なる場合がありますので注意してください。詳しくは、データモデル セクションを参照してください。

Columns

Name	Type	Description
NAME	String	SQL 構文のコンポーネント、またはサーバー上で処理できる機能。
VALUE	String	サポートされるSQL またはSQL 構文の詳細。

試行された変更に関する情報を返します。

次のクエリは、バッチ処理で変更された行のId を取得します。

         SELECT * FROM sys_identity
          

Columns

Name	Type	Description
Id	String	データ変更処理から返された、データベース生成Id。
Batch	String	バッチの識別子。1 は単一処理。
Operation	String	バッチ内の処理の結果：INSERTED、UPDATED、またはDELETED。
Message	String	SUCCESS、またはバッチ内の更新が失敗した場合のエラーメッセージ。

利用可能なシステム情報を説明します。

次のクエリは、すべてのカラムを取得します。

SELECT * FROM sys_information

Columns

Name	Type	Description
Product	String	製品名。
Version	String	製品のバージョン番号。
Datasource	String	製品が接続するデータソースの名前。
NodeId	String	製品がインストールされているマシンの固有識別子。
HelpURL	String	製品のヘルプドキュメントのURL。
License	String	製品のライセンス情報。（この情報が利用できない場合、この項目は空白のままか「N/A」と表示されます。）
Location	String	製品のライブラリが格納されているファイルパスの場所。
Environment	String	製品が現在稼働している環境またはランタイムのバージョン。
DataSyncVersion	String	本コネクタを使用するために必要なCData Sync のティア。
DataSyncCategory	String	CData Sync 機能のカテゴリ（例：Source、Destination）。

Data Type Mappings

The Cloud maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.

Microsoft OneDrive (OData V4)	CData Schema
Edm.Binary	binary
Edm.Boolean	bool
Edm.Date	datetime
Edm.DateTimeOffset	datetime
Edm.Decimal	decimal
Edm.Double	double
Edm.Guid	guid
Edm.Int32	int
Edm.String	string
Edm.TimeOfDay	time

接続文字列プロパティは、接続を確立するために使用できるさまざまなオプションです。このセクションでは、本プロバイダーの接続文字列で設定できるオプションの一覧を示します。詳細については各リンクをクリックしてください。

Authentication

---

プロパティ	説明
AuthScheme	Microsoft OneDrive に接続する際に使用する認証の種類を指定します。このプロパティが空白の場合は、デフォルトの認証が使用されます。

Azure Authentication

---

プロパティ	説明
AzureTenant	データにアクセスするために使用されているMicrosoft OneDrive テナントを識別します。テナントのドメイン名（例： contoso.onmicrosoft.com ）またはディレクトリ（テナント）ID のいずれかを受け付けます。
AzureEnvironment	接続するAzure ネットワーク環境を指定します。Azure アカウントが追加されたネットワークと同じである必要があります。

OAuth

---

プロパティ	説明
OAuthClientId	カスタムOAuth アプリケーションに割り当てられたクライアントID（コンシューマーキーとも呼ばれます）を指定します。このID は、認証時にOAuth 認可サーバーにアプリケーションを識別させるために必要です。
OAuthClientSecret	カスタムOAuth アプリケーションに割り当てられたクライアントシークレットを指定します。この機密情報は、OAuth 認可サーバーに対してアプリケーションを認証するために使用されます。（カスタムOAuth アプリケーションのみ）
Scope	データへの適切なアクセスを確実にするために、認証ユーザーのアプリケーションへのアクセス範囲を指定します。 カスタムOAuth アプリケーションが必要な場合は、通常、アプリケーションの作成時に指定します。

JWT OAuth

---

プロパティ	説明
OAuthJWTCert	クライアント証明書のJWT 証明書ストアの名前を指定します。
OAuthJWTCertType	JWT 証明書を格納しているキーストアの種類を指定します。
OAuthJWTCertPassword	パスワードで保護された証明書ストアにアクセスするために使用されるOAuth JWT 証明書のパスワードを指定します。証明書ストアがパスワードを必要としない場合は、このプロパティを空白のままにします。
OAuthJWTCertSubject	ストアで一致する証明書を検索するために使用される、OAuth JWT 証明書のサブジェクトを指定します。部分一致と、先頭の証明書を選択するためのワイルドカード '*' をサポートします。

SSL

---

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

Logging

---

プロパティ	説明
Verbosity	ログファイルのVerbosity レベルを指定し、記録される情報の詳細度を制御します。サポートされる値の範囲は1から5までです。

Schema

---

プロパティ	説明
BrowsableSchemas	レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

Miscellaneous

---

プロパティ	説明
DefaultGroups	Determines whether to use the /me/memberOf or /groups endpoint for user authentication.
DefaultUser	Determines whether to use the /me or /users endpoint for user authentication.
DirectoryRetrievalDepth	This property specifies how many folder levels deep to retrieve results for the Folders, Files, SharedResources, and Permissions tables.
DriveId	Specifies the unique identifier (Id) of the Microsoft OneDrive drive to query or interact with. Use this property to target a specific drive when multiple drives are available for the authenticated user.
GroupId	Specify a default GroupId.
IncludeFoldersWithFiles	Specifies whether folders should be included in the results when retrieving files.
ListGroupDrives	Specifies whether to include group (shared) drives when querying the Drives table.
MaxRows	集計やGROUP BY を含まないクエリで返される最大行数を指定します。
Pagesize	The maximum number of results to return per page from Microsoft OneDrive.
PseudoColumns	テーブルカラムとして公開する擬似カラムを、'TableName=ColumnName;TableName=ColumnName' の形式の文字列で指定します。
ThrowsKeyNotFound	更新された行がない場合に例外をスローするかどうかを指定します。
Timeout	provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。
UserId	Specify a default UserId.

このセクションでは、本プロバイダーの接続文字列で設定可能なAuthentication プロパティの全リストを提供します。

---

プロパティ	説明
AuthScheme	Microsoft OneDrive に接続する際に使用する認証の種類を指定します。このプロパティが空白の場合は、デフォルトの認証が使用されます。

Microsoft OneDrive に接続する際に使用する認証の種類を指定します。このプロパティが空白の場合は、デフォルトの認証が使用されます。

Possible Values

AzureAD, AzureServicePrincipal, AzureServicePrincipalCert

データ型

string

デフォルト値

"AzureAD"

解説

AuthScheme には以下が含まれます。

• AzureAD（デフォルト）：Azure Active Directory（ユーザーベース）のOAuth 認証を実行します。
• AzureMSI：Azure VM で実行している際に、Azure AD マネージドサービスID の資格情報を自動的に取得します。
• AzureServicePrincipal：クライアントシークレットを使用してAzure サービスプリンシパル（ロールベース、アプリケーションベース）として認証します。
• AzureServicePrincipalCert：証明書を使用してAzure サービスプリンシパル（ロールベース、アプリケーションベース）として認証します。

Azure AD で認証するためのカスタムアプリケーションの作成方法については、Entra ID（Azure AD）アプリケーションの作成 を参照してください。

Azure AD サービスプリンシパルで認証するためのカスタムアプリケーションの作成方法については、Entra ID（Azure AD）でのサービスプリンシパルアプリの作成 を参照してください。

このセクションでは、本プロバイダーの接続文字列で設定可能なAzure Authentication プロパティの全リストを提供します。

---

プロパティ	説明
AzureTenant	データにアクセスするために使用されているMicrosoft OneDrive テナントを識別します。テナントのドメイン名（例： contoso.onmicrosoft.com ）またはディレクトリ（テナント）ID のいずれかを受け付けます。
AzureEnvironment	接続するAzure ネットワーク環境を指定します。Azure アカウントが追加されたネットワークと同じである必要があります。

データにアクセスするために使用されているMicrosoft OneDrive テナントを識別します。テナントのドメイン名（例： contoso.onmicrosoft.com ）またはディレクトリ（テナント）ID のいずれかを受け付けます。

データ型

string

デフォルト値

""

解説

テナントとは、Microsoft Entra ID（旧称：Azure AD）を通じて管理される、組織のユーザーやリソースのためのデジタルコンテナです。 各テナントには一意のディレクトリID が関連付けられており、多くの場合、カスタムドメイン（例：microsoft.com やcontoso.onmicrosoft.com）も関連付けられています。

Microsoft Entra 管理センターでディレクトリ（テナント）ID を確認するには、Microsoft Entra ID -> プロパティに移動し、「ディレクトリ（テナント）ID」と表示されている値をコピーします。

このプロパティは以下の場合に必要です。

• AuthScheme がAzureServicePrincipal またはAzureServicePrincipalCert に設定されている場合
• AuthScheme がAzureAD で、ユーザーアカウントが複数のテナントに属している場合

テナントの値は、2つの形式のいずれかで指定できます。

• ドメイン名（例：contoso.onmicrosoft.com）
• GUID 形式のディレクトリ（テナント）ID（例：c9d7b8e4-1234-4f90-bc1a-2a28e0f9e9e0）

テナントを明示的に指定することで、認証リクエストが正しいディレクトリにルーティングされるようになります。これは、ユーザーが複数のテナントに所属している場合や、サービスプリンシパルベースの認証を使用する場合に特に重要です。

この値が必要な場面で省略されると、認証に失敗したり、誤ったテナントに接続されたりする可能性があります。その結果、認可されていないまたはリソースが見つからないといったエラーが発生する可能性があります。