Retrieve recordings on Basecamp 3 folders.
View Specific Information
Retrieve most of the data structures in the Basecamp 3, which are represented as "Recordings."
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'
|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.|
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.
|Bucket||String||Single or comma separated list of project IDs. Default: All active projects visible to the current user|