ODBC guide

Read items in a folder (non-recursive)

Gets items in a folder. Use Filter to list both files and folders, only files, or only folders. Supply DriveId and optionally FolderId (exact ID, root, or path like root:/Documents/My Projects:).

SELECT *
FROM list_folder
WITH(
	  Filter='$.value[*]' --list both files and folders
	--Filter='$.value[?(@.file.mimeType != null)]' --list only files
	--Filter='$.value[?(@.folder.childCount != null)]' --list only folders
	--,DriveId='me'
    --OR-- Use Shared Drive Id or other User's Drive Id
    --,DriveId='b!GtLN726LE0eXXXXXXXXXXXX'
	--,FolderId='01R65QTTUIVFJ6HVJ2WBC37KCAOQRKX7PP' --exact Id of Folder
	--,FolderId='root' --default is root if FolderId is not passed
	--,FolderId='root:/Documents/My Projects:'
	--,FolderId='root:/Documents/My Projects/Sample Project:'
)		
--You can get DriveId by selecting from 'Drives' table.
--You can get FolderId by selecting from 'list_root' table OR selection from 'list_folder'.