Activities
Query data on activities performed in your files, folders, and drives.
Select
The https://www.googleapis.com/auth/drive.activity.readonly scope is required to use this view. CData's embedded OAuth application does not support this scope. You must create a custom OAuth application and enable the Google Drive Activity API from the Library page (see カスタムOAuth アプリの作成).To read activity data with this view, either the ItemId column or the ParentFolderId column must be specified in the criteria of the statement. Both columns can't be specified at the same time. Refer to the following query examples:
SELECT * FROM Activities WHERE ItemId = 'items/1eCy_Fks57HytPuam-OiaHGY4_15Py16eVM5bNDCHYXQ';
SELECT * FROM Activities WHERE ParentFolderId = 'items/1eCy_Fks57HytPuam-OiaHGY4_15Py16eVM5bNDCHYXQ';
- When ItemId is used, the connector will read activity data only for a specific drive item.
- When ParentFolderId is used, the connector will read activity data for all drive items (and sub-items recursively) in the specified folder.
The Activities view supports only a subset of columns for filtering. Below is a table containing those columns with their supported operations.
| Column | Supported Operators |
| ItemId | =, IN |
| ParentFolderId | =, IN |
| ActionType | =, IN, !=, NOT IN |
| Time | >, >=, <, <= |
The ActionType and Time pseudo-columns can only be used one time each (even if the same operator is used) in the criteria. Additionally, only the supported operators mentioned above can be used. If these conditions are not met, the query will fail. Refer to the following query examples below:
-- Valid
SELECT * FROM Activities WHERE ItemId = 'items/1eCy_Fks57HytPuam-OiaHGY4_15Py16eVM5bNDCHYXQ' AND Time > '2025-09-01T00:00:00.000' AND ActionType IN ('CREATE', 'EDIT');
-- Invalid, will fail.
SELECT * FROM Activities WHERE ItemId = 'items/1eCy_Fks57HytPuam-OiaHGY4_15Py16eVM5bNDCHYXQ' AND Time > '2025-09-01T00:00:00.000' AND Time > '2025-09-30T00:00:00.000' AND ActionType IN ('CREATE', 'EDIT'); -- Time pseudo-column is used 2 times.
SELECT * FROM Activities WHERE ItemId = 'items/1eCy_Fks57HytPuam-OiaHGY4_15Py16eVM5bNDCHYXQ' AND Time > '2025-09-01T00:00:00.000' AND ActionType IN ('CREATE', 'EDIT') AND ActionType NOT IN ('DELETE', 'RESTORE'); -- ActionType pseudo-column is used 2 times.
SELECT * FROM Activities WHERE ItemId = 'items/1eCy_Fks57HytPuam-OiaHGY4_15Py16eVM5bNDCHYXQ' AND Time != '2025-09-01T00:00:00.000' AND ActionType > 'CREATE'; -- Unsupported operators are used on both pseudo-columns.
Columns
| Name | Type | Description |
| ItemId | String | The identifier of the item related to the target in the activity. |
| ItemType | String | The type of the item.
使用できる値は次のとおりです。FILE, FOLDER |
| ItemName | String | The name of the item. |
| ItemMimeType | String | The MIME type of the item. |
| ItemOwner | String | The owner of the item. |
| ItemFolderType | String | The folder's type if the item is a folder.
使用できる値は次のとおりです。TYPE_UNSPECIFIED, MY_DRIVE_ROOT, SHARED_DRIVE_ROOT, STANDARD_FOLDER |
| TargetType | String | The type of object that was updated in the activity.
使用できる値は次のとおりです。DRIVE_ITEM, DRIVE, FILE_COMMENT |
| DriveId | String | The identifier of the drive, if the target in the activity is a drive. |
| DriveName | String | The name of the drive. |
| CommentId | String | The identifier of the comment, if the target in the activity is a file's comment. |
| DiscussionId | String | The identifier of the discussion related to the file comment. |
| DiscussionLink | String | The link to the discussion related to the file comment. |
| PrimaryActionType | String | The type of primary action that occurred in the activity.
使用できる値は次のとおりです。CREATE, EDIT, MOVE, RENAME, DELETE, RESTORE, PERMISSION_CHANGE, COMMENT, DATA_LEAK_PREVENTION_CHANGE, APPLICATION_REFERENCE, SETTINGS_CHANGE, LABEL_CHANGE |
| Actions | String | The actions that occurred in the activity. |
| ActorType | String | The type of actor responsible for the activity.
使用できる値は次のとおりです。IMPERSONATED_USER, USER, ADMINISTRATOR, ANONYMOUS, SYSTEM_EVENT |
| UserType | String | The type of user if the actor is a user.
使用できる値は次のとおりです。KNOWN_USER, DELETED_USER, UNKNOWN_USER |
| Username | String | The username of the user. |
| IsAuthenticatedUser | Boolean | Boolean value indicating whether the user is the connected user. |
| SystemEventType | String | The type of event if the actor is a system event.
使用できる値は次のとおりです。TYPE_UNSPECIFIED, USER_DELETION, TRASH_AUTO_PURGE |
| OccurredAt | Datetime | The exact time when the activity took place. |
| StartedAt | Datetime | The time when the activity started, if it took place during a time range instead of a specific time. |
| EndedAt | Datetime | The time when the activity ended, if it took place during a time range instead of a specific time. |
| ParentFolderId | String | The identifier of the folder whose activities you want to query including the activities in the children. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ActionType | String | Filter the activities by the type of actions that occurred in them.
使用できる値は次のとおりです。CREATE, EDIT, MOVE, RENAME, DELETE, RESTORE, PERMISSION_CHANGE, COMMENT, DATA_LEAK_PREVENTION_CHANGE, APPLICATION_REFERENCE, SETTINGS_CHANGE, LABEL_CHANGE |
| Time | Datetime | Filter the activities by the time when they occurred. |