ODBC Driver for Microsoft OneDrive

Build 23.0.8839


The OneDrive table Files in which you can view all the files in a drive.

Table Specific Information


The 本製品 will use the Microsoft OneDrive API to process WHERE clause conditions built with the following column and operator.

  • FileId supports the '='.
  • DriveId supports the '='.
  • UserId supports the '='.
For example:
SELECT * FROM FileVersions WHERE FileId = '01CYQN2MFPR6NIWVZNMNFL3SL4E3KF7IHY' AND DriveId = 'b!GrEGWax2VE-ssnJNr1E8llqoLptvK-BGjFRpceFzFg5Nwp9Bw2xbR62J0NAouP6z'

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


Name Type References Description
FileId [KEY] String
lastModifiedBy_user_displayName String
lastModifiedBy_user_id String
lastModifiedDateTime Datetime
size Long
id String
lastModifiedBy_user_email String
DriveId String
publication_level String
createdBy_user_id String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839