Cmdlets for Basecamp

Build 20.0.7587

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587