In your query, I think that mimeType!='application/vnd.google-apps.folder' AND trashed=false AND 'me' in owners
is correct. But about modifiedTime>='2018-11-16T14:00:00' AND modifiedTime<='2018-11-11T5:59:59'
, in this case, the files "after 2018-11-16T14:00:00
" AND "before 2018-11-11T5:59:59
" are trying to be retrieved. So the result becomes {"files": []}
.
Pattern 1:
For modifiedTime
, if you want to retrieve files from 2018-11-11T5:59:59
to 2018-11-16T14:00:00
, how about this query?
mimeType!='application/vnd.google-apps.folder' AND trashed=false AND 'me' in owners AND modifiedTime<='2018-11-16T14:00:00' AND modifiedTime>='2018-11-11T5:59:59'
Pattern 2:
For modifiedTime
, if you want to retrieve files of "before 2018-11-11T5:59:59
" and "after 2018-11-16T14:00:00
", how about this query?
mimeType!='application/vnd.google-apps.folder' AND trashed=false AND 'me' in owners AND (modifiedTime>='2018-11-16T14:00:00' OR modifiedTime<='2018-11-11T5:59:59')
Note:
- In your query,
2018-11-115:59:59
of modifiedTime<='2018-11-115:59:59
is wrong. But if 2018-11-115:59:59
is used, the query error occurs. So I supposes that you are using the correct value in your actual script.
Reference:
If I misunderstand your question, I'm sorry.