Cmdlets for Basecamp

Build 20.0.7587

Calendars

Retrieve calendars on Basecamp 3.

Table Specific Information

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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587