Cmdlets for Basecamp

Build 20.0.7587

Recordings

Retrieve recordings on Basecamp 3 folders.

View Specific Information

Retrieve most of the data structures in the Basecamp 3, which are represented as "Recordings."

Select

The columns supported as search criteria by Basecamp are Type (required parameter), Bucket, and Status.

SELECT * FROM Recordings WHERE type = 'Upload' AND Bucket = '1111111, 22222222' AND Status = 'active'

Columns

Name Type References Description
Id [KEY] Long The unique identifier of the topic.
Status String The status of the vault.

The allowed values are active, archived, trashed.

Type String The type of the vault.

The allowed values are Comment, Document, Message, Question::Answer, Schedule::Entry, Todo, Todolist, Upload.

CreatedAt Datetime The date and time when the event was created.
UpdatedAt Datetime The date and time when the event was last modified.
CreatorId Long

People.Id

Event Creator.
CreatorName String Event Creator.

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
Bucket String Single or comma separated list of project IDs. Default: All active projects visible to the current user

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