Calendars
Retrieve calendars on Basecamp 3.
Table Specific Information
There is only one Calendar (Schedule) in each Basecamp project.
Select
Retrieve more detail on a specific Calendar (ProjectId and Id are the only columns supported as search criteria by Basecamp). If ProjectId is not specified in the query, the default ProjectId will be used.
SELECT * FROM Calendars WHERE ProjectId = '111111111' AND Id = '123456789'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long |
Projects.CalendarId | The unique identifier of the calendar. |
| ProjectId | Long |
Projects.Id | The Project Id associated with the calendar. |
| Status | String | The status of the calendar. | |
| Type | String | The type of the returned record. | |
| CreatedAt | Datetime | The date and time when the calendar was created. | |
| UpdatedAt | Datetime | The date and time when the calendar was last updated. | |
| Title | String | Title of the calendar. | |
| EntriesCount | Integer | Number of calendar events. | |
| BucketId | Long | Id of the containing bucket. | |
| BucketName | String | Name of the containing bucket. | |
| BucketType | String | Type of the containing bucket. | |
| CreatorId | Long |
People.Id | The Id of the creator. |
| CreatorName | String | The name of the creator. |