ODBC guide

List items from a parent folder (recursive or non-recursive)

Lists files and folders under a parent folder. Supply FolderId to limit to that folder, or leave it blank to scan all folders recursively. You can restrict by item type (e.g. files, folders, sheets, documents) and optionally include items from Trash.

SELECT * FROM list_parent_items
WITH(
	--Parent folder id (keep blank to scan all files in all folders - recursive)
	FolderId='1VK5NBhuOTaLEy1pBMsQtG672vrJNgxai',
	IncludeFromTrash='false'
	--, Query='or (name contains ''blog'') or (name contains ''test'')'
	--, ItemType='files'
	--, ItemType='folders'
	--, ItemType='sheets'
	--, ItemType='files_native'
)