ODBC guide

Read folders in a folder

Gets only folders in a folder. Set Filter to @.folder to list folders only. Supply DriveId and FolderId.

SELECT * 
FROM list_folder
WITH (
	  DriveId='me'
	  --OR-- Use Shared Drive Id or other User's Drive Id
	  --DriveId='b!GtLN726LE0eXXXXXXXXXXXX'
	  
	  --Path must end with colon
	  ,FolderId='/root:'	
	  
	  --OR-- (Folder Path)
      --,FolderId='/root:/my-subfolder:'
	  
	  --OR-- (Folder ID)
	  --,FolderId='atLNaXXXXXXXXXXXXxx'
	  
      ,Filter='$.value[?(@.folder)]'
	  )
--You can get DriveId by selecting from 'Drives' table.
--You can get FolderId by selecting from 'list_root' table OR selection from 'list_folder'.