ADO.NET Provider for Basecamp

Build 24.0.8963

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963