ODBC guide

Read Excel files

Gets Excel files in a specified drive. Supply DriveId and optional FolderId or SearchPath.

SELECT * FROM list_excel_files
WITH (
         DriveId='me'
      --OR-- Use Shared Drive Id or other User's Drive Id
      -- DriveId='b!GtLN726LE0eXXXXXXXXXXXX'
	  --,SearchPath='/root:/MyFolder:' 	--Path must end with colon
)
--You can get DriveId by selecting from 'list_drives' endpoint.