Recordings
Retrieve recordings on Basecamp 3 folders.
ビュー固有の情報
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.
使用できる値は次のとおりです。active, archived, trashed | |
| Type | String | The type of the vault.
使用できる値は次のとおりです。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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| Bucket | String | Single or comma separated list of project IDs. Default: All active projects visible to the current user |