Google Drive API filter trashed files

[Ivan Navarro]

hi,

I'm working on an extension that fetches Google Drive files from users, and I need to filter out the trashed files from the results. Based on the documentation, I believe I need the following approach to achieve this, but it isn't working, and trashed files are still being returned.

let url = "https://www.googleapis.com/drive/v3/files";

const query = `name = '${title}' and mimeType = 'application/vnd.google-apps.spreadsheet' and trashed = false`;

const searchUrl = `${url}?q=${encodeURIComponent(query)}`;

I've also read that I can check the trashed attribute in the returned files, but my results don't include this attribute.

Has anyone found an effective method to filter out trashed files?

Thanks for any help!

Iván

[Stephen S.]

Hi - Can you post a structure of what is returned? The `trashed` attribute should be returned. 

Also, possibly returning all fields `&fields=*` with the query or as a URL param may allow it to be included.

- Stephen

[Tony Confrey]

This syntax works for me:

"https://www.googleapis.com/drive/v3/files?pageSize=1&fields=files(id,name,modifiedTime)&q=name='BrainTool.org' and not trashed"

Tony

[Ivan Navarro]

Including the fields attribute resolved the issue effectively.

By default only id, kind, mimeType and name were returned.

Thank you!!

Iván