如何使用Google Drive API通过服务帐户访问域中的共享文件？

Question

我一直在尝试从Python 3.7脚本访问有关Google共享驱动器文件的一些简单信息：

The last time a Google Sheets file on a shared drive was modified.

我已经在GCP Drive API菜单中创建了一个服务帐户，它可以通过Sheets API访问/编辑/etc Google Sheets，没有任何问题

但是，当我对驱动器API使用相同的服务帐户时，它不会返回其自己文件夹（其中仅包含一个文件：“Getting Started”）之外的文件的任何信息。该帐户可以访问所有云API，具有与GSuite中API控制菜单中包含的驱动器API相关的所有作用域的全域授权

服务帐户的电子邮件地址已正确添加到共享驱动器中的所有文件夹中

有什么想法吗？基本上，我所需要的是知道任何给定用户最后一次修改工作表是什么时候

secret_cred_file = ...
SCOPES = ['https://www.googleapis.com/auth/drive']
credentials = service_account.Credentials.from_service_account_file(secret_cred_file, scopes=SCOPES)
service = discovery.build('drive', 'v3', credentials=credentials)
results = service.files().list(pageSize=10, fields="nextPageToken, files(id, name,modifiedTime)").execute()
items = results.get('files', [])

PS：我已经看到了：Getting files from shared folder但它没有帮助

Answer 1

通过向列表方法添加一些参数，我可以列出共享驱动器文件，而无需模拟用户，如google documentation所述：

Implement shared drive support

Shared drives follow different organization, sharing, and ownership models from My Drive. If your app is going to create and manage files on shared drives, you must implement shared drive support in your app. To begin, you need to include the supportsAllDrives=true query parameter in your requests when your app performs these operations:

files.get, files.list, files.create, files.update, files.copy, files.delete, changes.list, changes.getStartPageToken, permissions.list, permissions.get, permissions.create, permissions.update, permissions.delete

Search for content on a shared drive

Use the files.list method to search for shared drives. This section covers shared drive-specific fields in the files.list method. To search for shared drive, refer to Search for files and folders.

The files.list method contains the following shared drive-specific fields and query modes:

driveId — ID of shared drive to search.

includeItemsFromAllDrives — Whether shared drive items should be included in results. If not present or set to false, then shared drive items are not returned.

corpora — Bodies of items (files/documents) to which the query applies. Supported bodies are user, domain, drive, and allDrives. Prefer user or drive to allDrives for efficiency.

supportsAllDrives — Whether the requesting application supports both My Drives and shared drives. If false, then shared drive items are not included in the response.

示例

service.files().list(includeItemsFromAllDrives=True, supportsAllDrives=True, pageSize=10, fields="nextPageToken, files(id, name,modifiedTime)").execute()

请记住，文件夹或文件需要与服务帐户共享