List / search files from my drive
Lists or searches files in the user's My Drive. Use the Query parameter to filter by name or other criteria (e.g. name contains "ZappySys*.*").
SELECT * FROM Files
WITH(
--Query='name contains "ZappySys*.*"',
)