Calendars
Retrieve, create, update, and delete Calendars on Basecamp.
Table Specific Information
Select
Select all from Calendars or specify an Id to retrieve more detail on a certain Calendar (Id is the only column supported as search criteria by Basecamp).
SELECT * FROM Calendars WHERE Id = '123456789'
Insert
Specify (at least) the Name property to create a new Calendar under the organization.
INSERT INTO Calendars (Name) VALUES ('New Test Calendar')
Update and Delete
Specify a Calendar Id to update or delete Calendars. Set the Name property again if you are updating.
UPDATE Calendars SET Name = 'This is a new name for the Test Calendar.' WHERE Id = '123456789' DELETE FROM Calendars WHERE Id = '123456789'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
The unique identifier for the calendar. | |
AccessesAppUrl | String | True |
The accesses app URL. | |
AccessesCount | Integer | True |
The accesses count. | |
AccessesUpdatedAt | Datetime | True |
The time when accesses were updated. | |
AccessesUrl | String | True |
The accesses URL. | |
AppUrl | String | True |
The app URL. | |
CalendarEventsCount | Integer | True |
Number of calendar events. | |
CalendarEventsUpdatedAt | Datetime | True |
The date and time when the calendar event was last updated. | |
CalendarEventsUrlsPast | String | True |
URL of the past calendar event. | |
CalendarEventsUrlsUpcoming | String | True |
The date and time when the calendar was last updated. | |
Color | String | True |
The color of the calendar. | |
CreatedAt | Datetime | True |
The date and time when the document was created. | |
CreatorAvatarUrl | String | False |
Creator Avatar URL. | |
CreatorFullsizeAvatarUrl | String | False |
Creator full-size avatar Url. | |
CreatorId | String | False |
The Id of the creator of the calendar. | |
CreatorName | String | False |
The name of the creator of the calendar. | |
Name | String | False |
The name of the calendar. | |
UpdatedAt | Datetime | True |
The date and time when the calendar was last updated. | |
Url | String | True |
The URL of the calendar. |