ADO.NET Provider for Basecamp

Build 24.0.8963

Calendars

Retrieve calendars on Basecamp 3.

テーブル固有の情報

There is only one Calendar (Schedule) in each Basecamp project.

Select

Retrieve more detail on a specific Calendar (ProjectId and Id are the only columns supported as search criteria by Basecamp).If ProjectId is not specified in the query, the default ProjectId will be used.

SELECT * FROM Calendars WHERE ProjectId = '111111111' AND Id = '123456789'

Columns

Name Type References Description
Id [KEY] Long

Projects.CalendarId

The unique identifier of the calendar.
ProjectId Long

Projects.Id

The Project Id associated with the calendar.
Status String The status of the calendar.
Type String The type of the returned record.
CreatedAt Datetime The date and time when the calendar was created.
UpdatedAt Datetime The date and time when the calendar was last updated.
Title String Title of the calendar.
EntriesCount Integer Number of calendar events.
BucketId Long Id of the containing bucket.
BucketName String Name of the containing bucket.
BucketType String Type of the containing bucket.
CreatorId Long

People.Id

The Id of the creator.
CreatorName String The name of the creator.

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