ODBC guide

List folders in a parent folder

Gets folders within a specific parent folder in a document library. You can filter by path or ID.

SELECT * FROM list_folders
WITH (
  -- Drive (SharePoint Document Library)
  DriveId='b!GtLN726LE0eY5F2BBNi14wMKmwdpCDFMn1d71ra11GuQ4DORpHy-XXXXXXXXXXXXX'
, SearchPath='/items/01SUOJPKA3E3JKEBRLFRBYGIPBARUP3A2R' --enter parent folder id in search path
--OR--
--, SearchPath='/root:/myfolder/subfolder:' --You may also use parent folder path rather than id like this under which you like to search 

--exclude self: enter parent folder id to exclude from the list
, Filter='$.value[?(@.folder.childCount !=null && @id!=''01SUOJPKA3E3JKEBRLFRBYGIPBARUP3A2R'')]' 

)
--You can get DriveId by selecting from 'Drives' table.