Comments
Retrieve, create, update, and delete Calendars on Basecamp.
テーブル固有の情報
Select
プラットフォーム上のすべてのアクティブなComments を取得できます。テーブルの任意のフィールドで結果をフィルタリングできます。
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. |