Comments
Retrieve, create, update, and delete Calendars on Basecamp.
Table Specific Information
Select
You can retrieve all active Comments on the platform, and any field of the table can filter the result.
SELECT * FROM Comments WHERE ProjectId = '1111111' AND ItemType = 'Message'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the comment. | |
| ProjectId [KEY] | String | The unique identifier for the project where the comment is contained. | |
| ItemId | String | The unique identifier for the topic containing the comment. | |
| ItemType | String | Type of the object containing the comment. Valid values are: Message, Document, Forward, CalendarEvent, Upload, Todolist, Todo. | |
| AttachmentsAggregate | String | The attachments related to the comment. | |
| Content | String | The content of the comment. | |
| Private | Boolean | Privacy of the comment | |
| Trashed | Boolean | If the comment was trashed or not. | |
| CreatedAt | Datetime | The date and time when the document was created. | |
| CreatorAvatarUrl | String | Creator Avatar URL. | |
| CreatorFullsizeAvatarUrl | String | Creator full-size avatar Url. | |
| CreatorId | String | The Id of the creator of the comment. | |
| CreatorName | String | The name of the creator of the comment. | |
| UpdatedAt | Datetime | The date and time when the comment was last updated. |