ODBC guide

List files in a folder ID (non-recursive)

Lists files under a specific Folder ID (non-recursive mode only).

SELECT * FROM list_files
WITH(
     Filter='$.value[*]' --list both files and folders
   --Filter='$.value[?(@.file.mimeType != null)]' --list only files
   --Filter='$.value[?(@.folder.childCount != null)]' --list only folders
   -- Drive (SharePoint Document Library)   
	 ,DriveId='b!GtLN726LE0eY5F2BBNi14wMKmwdpCDFMn1d71ra11GuQ4DORpHy-Sa5UzSpkaY9E'
	 ,SearchType='children' --must use this type if you like to list items by FolderId
	
    --Folder which you like to list (If not supplied then Default=root)
	--,SearchPath='/root:/folder/subfolder:'
	--OR--
    --,SearchPath='/items/01SUOJPKBVT5ZC2KVSXJAYSTTMA4I3GMHX'
	
)		
--You can get DriveId by selecting from 'Drives' table.