Topics
Retrieve Topics on Basecamp.
Table Specific Information
Select
You can retrieve all active Topics, sort Topics that belong to a Project, or only list archived Topics (ProjectId and Archived are the only columns supported as search criteria by Basecamp).
SELECT * FROM Topics WHERE ProjectId = '1111111' ORDER BY UpdatedAt ASC SELECT * FROM Topics WHERE ProjectId = '1111111' AND Archived = True
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the topic. | |
| Archived | Boolean | Boolean value for archived topics. | |
| Attachments | Integer | The number of attachments to the topic. | |
| BucketAppUrl | String | The topic bucket app URL. | |
| BucketColor | String | The bucket topic color. | |
| BucketId | String | The bucket topic Id. | |
| BucketName | String | The bucket topic name. | |
| BucketType | String | The bucket topic type. | |
| BucketUrl | String | The bucket topic URL. | |
| CreatedAt | Datetime | The date and time when the record was created. | |
| Excerpt | String | The excerpt from the latest comment on the topic. | |
| LastUpdaterId | String | The Id of the person who made the last comment. | |
| LastUpdaterName | String | The name of the person who last updated the topic. | |
| Private | Boolean | Whether the topic is private. | |
| Title | String | The title of the topic. | |
| TopicableAppUrl | String | The URL of the topicable Basecamp entity. | |
| TopicableId | String | The Id of the topicable Basecamp entity. | |
| TopicableType | String | The type of the topicable Basecamp entity. | |
| TopicableUrl | String | The URL of the topicable Basecamp entity. | |
| Trashed | Boolean | Boolean value for deleted topics. | |
| UpdatedAt | Datetime | The date and time when the record was last updated. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| ProjectId | String | The Project Id. |