python - How to find Google Drive files neither owned by me nor shared with me using Drive API - Stack Overflow

admin管理员组

文章数量:1346063

I'm trying to write some Python code using the Google Drive API to find all files in my Google Drive created by accounts other than me (i.e., files created in subfolders which I have shared with others), but filter out those which were shared with me in another account's Drive. IOW, most files in the Drive associated with my account will be owned by me except for those in folders where I've given others permission to create files.

I'm using this code snippet to return the files where my Email address (in the variable ACCOUNTNAME) is not in the owners field:

         response = (
            service.files()
            .list(
               pageSize=100, 
               fields="nextPageToken, files(*)",
               includeItemsFromAllDrives=False,
               supportsAllDrives=False,
               q=f"not '{ACCOUNTNAME}' in owners",
               pageToken=page_token,
            )
            .execute()
         )

This is working except that it's also returning files shared with me from other drives for which I'm not the owner. I've been comparing the returned fields for the two scenarios, but I can't find a consistent pattern to determine which are the files from other Google accounts shared with me. From the API docs, it looks like the includeItemsFromAllDrives and supportsAllDrives parameters only distinguish between Google account Drives and anization "shared" drives; so it's not helping here.

I found this other thread which is sort of what I'm trying to do, but I don't think I can use it because it's limiting the search to the Drive "root" while I need to search the entire drive.

Any ideas on whether this is even possible? Thanks in advance.

I'm trying to write some Python code using the Google Drive API to find all files in my Google Drive created by accounts other than me (i.e., files created in subfolders which I have shared with others), but filter out those which were shared with me in another account's Drive. IOW, most files in the Drive associated with my account will be owned by me except for those in folders where I've given others permission to create files.

I'm using this code snippet to return the files where my Email address (in the variable ACCOUNTNAME) is not in the owners field:

         response = (
            service.files()
            .list(
               pageSize=100, 
               fields="nextPageToken, files(*)",
               includeItemsFromAllDrives=False,
               supportsAllDrives=False,
               q=f"not '{ACCOUNTNAME}' in owners",
               pageToken=page_token,
            )
            .execute()
         )

This is working except that it's also returning files shared with me from other drives for which I'm not the owner. I've been comparing the returned fields for the two scenarios, but I can't find a consistent pattern to determine which are the files from other Google accounts shared with me. From the API docs, it looks like the includeItemsFromAllDrives and supportsAllDrives parameters only distinguish between Google account Drives and anization "shared" drives; so it's not helping here.

I found this other thread which is sort of what I'm trying to do, but I don't think I can use it because it's limiting the search to the Drive "root" while I need to search the entire drive.

Any ideas on whether this is even possible? Thanks in advance.

• python
• google-drive-api

Share Improve this question Follow asked 2 days ago ShawnCShawnC 2122 bronze badges New contributor ShawnC is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 0

here's how I approached it:

I started by creating a separate function to filter all the folders that you own. Then, I iterated through these folders to look for files created by other accounts.

To test it, I created one folder and one file with the same account, and another file with a different account. The code successfully displayed only the file that was created by the other account.

Im gonna drop the whole code if you want to do a quick test using google colab:

from google.colab import auth
from googleapiclient.discovery import build

ACCOUNTNAME = '[email protected]'
SCOPES = ['https://www.googleapis/auth/drive.readonly']

def authenticate_google_drive():
    """Authenticate and return a Google Drive API client."""
    auth.authenticate_user()  # Log in in colab
    
    # Build the Google Drive client
    from google.auth import default
    creds, _ = default(scopes=SCOPES)
    return build('drive', 'v3', credentials=creds)

def list_folders(service):
    """List the folders that the user has created (which are owned by them)."""
    query = "mimeType='application/vnd.google-apps.folder' and 'me' in owners"
    response = service.files().list(
        q=query,
        fields="files(id, name)",
        pageSize=100
    ).execute()
    return response.get('files', [])

def list_files_in_folder(service, folder_id):
    """List the files inside a specific folder and check that they are not owned by you."""
    query = f"'{folder_id}' in parents and not '{ACCOUNTNAME}' in owners"
    response = service.files().list(
        q=query,
        fields="files(id, name, owners)",
        pageSize=100
    ).execute()
    return response.get('files', [])

def main():
    # Authenticate with the Google Drive API
    service = authenticate_google_drive()

    # Step 1: List the folders that the user has created
    folders = list_folders(service)
    
    # Step 2: Loop through the folders and get files created by other accounts
    for folder in folders:
        print(f"Searching for files in folder: {folder['name']} (ID: {folder['id']})")
        files_in_folder = list_files_in_folder(service, folder['id'])
        
        # Show the files that are not owned by you
        if files_in_folder:
            for file in files_in_folder:
                print(f"File found: {file['name']} (ID: {file['id']}) - Owners: {file['owners']}")

if __name__ == '__main__':
    main()

You may modify the query to filter out files where you are not an owner and the file has no parents in your My Drive.

q=f"not '{ACCOUNTNAME}' in owners and '{ACCOUNTNAME}' in writers and 'me' in owners"

and even more, you can check the parents field. This ensures the file has a parent folder in your Drive:

q=f"not '{ACCOUNTNAME}' in owners and '{ACCOUNTNAME}' in writers and 'me' in owners and parents != ''"

本文标签： pythonHow to find Google Drive files neither owned by me nor shared with me using Drive APIStack Overflow