JDBC Driver for Microsoft OneDrive

Build 22.0.8462

FileVersions

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

Table Specific Information

SELECT

The driver 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

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'

Columns

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462