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 URL for the calendar event's bucket app. | |
| 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 | The Eventable App URL. | |
| EventableId | String | The Eventable Id. | |
| EventableType | String | The Eventable type. | |
| EventableUrl | String | The Eventable URL. | |
| Excerpt | String | An excerpt of the text description for this event. | |
| HtmlUrl | String | The HTML URL of the event. | |
| Private | Boolean | Whether the event is private. | |
| RawExcerpt | String | An excerpt of raw text associated with 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 more granular control over the data 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. |