ADO.NET Provider for Basecamp

Build 24.0.8963

Calendars

Retrieve, create, update, and delete Calendars on Basecamp.

テーブル固有の情報

Select

特定のCalendar からより多くの情報を取得するには、Calendars からSelect all するかId を指定します(Basecamp で検索条件としてサポートされるカラムはId のみです)。

SELECT * FROM Calendars WHERE Id = '123456789'

Insert

組織下に新しいCalendar を作成するには、(少なくとも)Name プロパティを指定します。

INSERT INTO Calendars (Name) VALUES ('New Test Calendar')

Update およびDelete

Calendar の更新および削除には、Calendar Id を指定します。更新の場合には、Name プロパティを指定する必要があります。

UPDATE Calendars SET Name = 'This is a new name for the Test Calendar.' WHERE Id = '123456789'

DELETE FROM Calendars WHERE Id = '123456789'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The unique identifier for the calendar.

AccessesAppUrl String True

The accesses app URL.

AccessesCount Integer True

The accesses count.

AccessesUpdatedAt Datetime True

The time when accesses were updated.

AccessesUrl String True

The accesses URL.

AppUrl String True

The app URL.

CalendarEventsCount Integer True

Number of calendar events.

CalendarEventsUpdatedAt Datetime True

The date and time when the calendar event was last updated.

CalendarEventsUrlsPast String True

URL of the past calendar event.

CalendarEventsUrlsUpcoming String True

The date and time when the calendar was last updated.

Color String True

The color of the calendar.

CreatedAt Datetime True

The date and time when the document was created.

CreatorAvatarUrl String False

Creator Avatar URL.

CreatorFullsizeAvatarUrl String False

Creator full-size avatar Url.

CreatorId String False

The Id of the creator of the calendar.

CreatorName String False

The name of the creator of the calendar.

Name String False

The name of the calendar.

UpdatedAt Datetime True

The date and time when the calendar was last updated.

Url String True

The URL of the calendar.

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