ODBC guide

Get items list using query


Returns items matching a search query (e.g. by name or MIME type). Supply the Query parameter in WITH.

SELECT Id, Kind, Name, MimeType
FROM list_items
WITH(Query='name contains ''.txt''')