Open
Description
When retrieving files from Google Drive using a service account JSON, the API does not return trashed files that actually are in the parents
folder(s). This problem does not occur when using default authentication.
The service account has Content Manager rights in the concerned folder. The folder is in a shared drive.
See the below code example for reproduction.
Note: There is a workaround -> ('folder_id' in parents or 'folder_id' in parents)
Environment details
- OS type and version: MacOS Sequoia 15.1.1
- Python version: Python 3.11.9
- pip version: pip 24.3.1
google-api-python-client
version:2.154.02.157.0
Steps to reproduce
from google.oauth2 import service_account
from googleapiclient.discovery import build
import google
# ID of folder to test this with; make sure it contains a trashed item
TEST_FOLDER_ID = 'folder_id'
# Path to your service account key file
SERVICE_ACCOUNT_FILE = 'path_to_sa_json'
def default_credentials():
credentials, project = google.auth.default()
return credentials
def service_account_credentials():
credentials = service_account.Credentials.from_service_account_file(SERVICE_ACCOUNT_FILE)
return credentials
auth_type_credentials = {
"default": default_credentials(),
"service_account": service_account_credentials(),
}
queries = [
f"'{TEST_FOLDER_ID}' in parents",
f"('{TEST_FOLDER_ID}' in parents)",
f"('{TEST_FOLDER_ID}' in parents or '{TEST_FOLDER_ID}' in parents)",
]
for auth_type, credentials in auth_type_credentials.items():
drive_service = build('drive', 'v3', credentials=credentials)
print(f"{auth_type=}")
for query in queries:
fields = "incompleteSearch, nextPageToken, files(id, name, driveId, mimeType, parents, trashed)"
results = drive_service.files().list(
q=query,
fields=fields,
supportsAllDrives=True,
includeItemsFromAllDrives=True,
).execute()
print(f"\t{query=}")
print(f"\t\t- Cnt results: {len(results['files'])}")
print(f"\t\t- Of which trashed: {len([f for f in results['files'] if f.get('trashed', False)])}")
print("\n")
This prints:
auth_type='default'
query="'folder_id' in parents"
- Cnt results: 8
- Of which trashed: 3
query="('folder_id' in parents)"
- Cnt results: 8
- Of which trashed: 3
query="('folder_id' in parents or 'folder_id' in parents)"
- Cnt results: 8
- Of which trashed: 3
auth_type='service_account'
query="'folder_id' in parents"
- Cnt results: 5
- Of which trashed: 0
query="('folder_id' in parents)"
- Cnt results: 5
- Of which trashed: 0
query="('folder_id' in parents or 'folder_id' in parents)"
- Cnt results: 8
- Of which trashed: 3