ODBC guide

Read root

Gets items at the root level of a drive. Supply DriveId in the WITH clause (e.g. 'me' for the default drive, or a shared drive ID). Use this to discover top-level folders and files before drilling into a path.

SELECT * FROM list_root
WITH (
	DriveId='me'
  --OR-- Use Shared Drive Id or other User's Drive Id
  --DriveId='b!GtLN726LE0eXXXXXXXXXXXX'
)
--You can get DriveId by selecting from 'Drives' table.