Events
Retrieve activity Events on Basecamp.
Table Specific Information
Select
You can retrieve all activity Events or filter data by the created date. The columns and operators supported by Basecamp as search criteria are shown below.
| Column | Operators |
| ProjectId | = |
| PersonId | = |
| CreatedAt | >, >= |
For example, the following query retrieves activity occurring after the specified date for the specified person:
SELECT * FROM Events WHERE CreatedAt >= '2016-01-01' AND PersonId = '1111111'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the event. | |
| Action | String | The action description for the event. | |
| BucketAppUrl | String | The calendar events app URL. | |
| BucketColor | String | The bucket event color. | |
| BucketId | String | The bucket event Id. | |
| BucketName | String | The bucket event name. | |
| BucketType | String | The bucket event type. | |
| BucketUrl | String | The bucket event URL. | |
| CreatedAt | Datetime | The date and time when the event was created. | |
| CreatorAvatarUrl | String | Creator Avatar URL. | |
| CreatorFullsizeAvatarUrl | String | Creator full-size avatar URL. | |
| CreatorId | String | The Id of the event creator. | |
| CreatorName | String | The name of the event creator. | |
| EventableAppUrl | String | Eventable App URL. | |
| EventableId | String | Eventable Id. | |
| EventableType | String | Eventable type. | |
| EventableUrl | String | Eventable URL. | |
| Excerpt | String | The type of excerpt for this event. | |
| HtmlUrl | String | The HTML URL of the event. | |
| Private | Boolean | Whether the event is private. | |
| RawExcerpt | String | The raw excerpt type for this event. | |
| Summary | String | The summary for the event. | |
| Target | String | The target project of this event. | |
| UpdatedAt | Datetime | The date and time when the event was last updated. | |
| URL | String | The URL of the event. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| ProjectId | String | The Id of the Project associated with this event. | |
| PersonId | String | The Id of the Person associated with this event. |