ADO.NET Provider for Basecamp

Build 24.0.8963

Events

Retrieve activity Events on Basecamp.

テーブル固有の情報

Select

Events のすべてのアクティビティの取得、もしくは作成日でデータをフィルタできます。Basecamp において検索条件としてサポートされているカラムおよび演算子は以下のとおりです。

カラム演算子
ProjectId=
PersonId=
CreatedAt>, >=

例えば、次のクエリは、特定の日にち以降に特定の人に発生したアクティビティを取得します。

SELECT * FROM Events WHERE CreatedAt >= '2016-01-01' AND PersonId = '1111111'

Columns

Name Type References Description
Id [KEY] String The unique identifier of the event.
Action String The action description for the event.
BucketAppUrl String The calendar events app URL.
BucketColor String The bucket event color.
BucketId String The bucket event Id.
BucketName String The bucket event name.
BucketType String The bucket event type.
BucketUrl String The bucket event URL.
CreatedAt Datetime The date and time when the event was created.
CreatorAvatarUrl String Creator Avatar URL.
CreatorFullsizeAvatarUrl String Creator full-size avatar URL.
CreatorId String The Id of the event creator.
CreatorName String The name of the event creator.
EventableAppUrl String Eventable App URL.
EventableId String Eventable Id.
EventableType String Eventable type.
EventableUrl String Eventable URL.
Excerpt String The type of excerpt for this event.
HtmlUrl String The HTML URL of the event.
Private Boolean Whether the event is private.
RawExcerpt String The raw excerpt type for this event.
Summary String The summary for the event.
Target String The target project of this event.
UpdatedAt Datetime The date and time when the event was last updated.
URL String The URL of the event.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ProjectId String The Id of the Project associated with this event.
PersonId String The Id of the Person associated with this event.

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