Photos
Retrieves image files from Google Drive along with metadata such as resolution, format, and upload timestamps.
Select
It is also possible to get all the photos from a Drive.
Note: You must set the connection property SupportsAllDrives to 'true', in order to query from a specific Drive.
SELECT * FROM Photos WHERE DriveId = '0ACkq0ZiV0yJCUk9PVA'
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier assigned to the photo file in Google Drive. |
| Name | String | The display name of the photo file. This name is not necessarily unique within a folder. For fixed resources such as My Drive, Team Drive roots, or the Application Data folder, the name does not change. |
| DriveId | String | The identifier of the Drive (personal or shared) that contains the photo. |
| Description | String | A short user-defined summary describing the contents or purpose of the photo. |
| Extension | String | The file extension indicating the photo format, such as jpg or png. |
| CreatedTime | Datetime | The timestamp when the photo file was initially added to Google Drive. |
| ModifiedTime | Datetime | The timestamp of the most recent modification made to the photo file. |
| Size | Long | The size of the photo file in bytes. |
| OwnerName | String | The full name of the user who owns the photo file. |
| OwnerEmail | String | The email address associated with the owner of the photo file. |
| Starred | Boolean | If the value is 'true', the photo file is marked as starred for easier access. |
| Trashed | Boolean | If the value is 'true', the photo file has been moved to the trash. |
| Viewed | Boolean | If the value is 'true', the photo file has been opened or previewed by the authenticated user. |
| ParentIds | String | A comma-separated list of folder IDs, such as abc123, def456, ghi789, indicating the parent directories of the photo. |
| ChildIds | String | A semicolon-separated list of resource IDs, such as file001; file002; file003, representing child resources under this photo (used only if it's treated as a container or placeholder). |
| ChildLinks | String | A semicolon-separated list of URLs, such as https://drive.google.com/file1; https://drive.google.com/file2, linking to the child resources. |
| Query | String | A query string using the Google Drive Software Development Kit (SDK) syntax to override filtering defined in the WHERE clause. |