Read files in a folder path (recursive)
Gets files in a folder and its subfolders. Use list_files with DriveId, SearchPath (e.g. /root:/myfolder/subfolder:), and optional Filter and OrderBy. New or non-indexed files may not appear immediately.
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
,DriveId='me'
--OR-- Use Shared Drive Id or other User's Drive Id
--,DriveId='b!GtLN726LE0eXXXXXXXXXXXX'
--,SearchPath='/root' --folder path
--,SearchPath='/root:/myfolder:' --folder path (make sure to start with slash and end with colon)
,SearchPath='/root:/myfolder/subfolder:' --folder path nested (make sure to start with slash and end with colon)
,OrderBy='lastModifiedDateTime desc'
)
--You can get DriveId by selecting from 'Drives' table.
--You can get SearchPath by selecting from 'list_root' table OR selection from 'list_folder'.