Power BI Connector for Basecamp

Build 20.0.7587

CalendarEvents

Retrieve, create, update, and delete Calendar Events on Basecamp.

Table Specific Information

Select

Basecamp supports only a limited subset of columns to be used as filter criteria in the WHERE clause. All Boolean columns for this table can be used with the '=' operator. ProjectId, CalendarId, StartsAt, and EndsAt can also be used with the "=" operator. Additionally, the StartsAt column can be used with the '>=' operator.

The following query filters on a particular time range.

SELECT * FROM CalendarEvents WHERE StartsAt = '2016-01-01' AND EndsAt = '2016-02-01'
The following queries get CalendarEvents for a certain Project or Calendar.
SELECT * FROM CalendarEvents WHERE ProjectId= '123456768'
SELECT * FROM CalendarEvents WHERE CalendarId = '123456768'

Insert

Specify the ProjectId or CalendarId and StartsAt when creating a new CalendarEvent.

INSERT INTO CalendarEvents (ProjectId, Summary, Description, AllDay, StartsAt) VALUES ('12345678', 'My single, all-day Project event', 'Details to follow', 'true', 2016-02-01)

Update and Delete

Specify the ProjectId or CalendarId and the CalendarEvent Id when updating or deleting CalendarEvents.

UPDATE CalendarEvents SET Summary = 'Updated, two-day Project event', Description = 'Details to follow', AllDay = 'true', StartsAt = '2016-01-01', EndsAt = '2016-01-03' WHERE ProjectId = '12345678' AND Id = '12345678'

DELETE FROM CalendarEvents WHERE ProjectId = '12345678' AND Id = '12345678'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The unique identifier for the calendar event.

AllDay Boolean False

Whether the calendar event is an all-day event.

AppUrl String True

The app URL.

BucketAppUrl String True

The calendar event bucket app url.

BucketColor String True

The calendar event bucket color.

BucketId String True

The calendar event bucket Id.

BucketName String True

The calendar event bucket name.

BucketType String True

The calendar event bucket type.

BucketUrl String True

The calendar event bucket URL.

CommentsCount Integer True

The number of comments on this calendar event.

CreatedAt Datetime True

The date and time when the calendar event 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 event.

CreatorName String False

The name of the creator of the calendar event.

Description String False

The description for the calendar event.

EndsAt Datetime False

The end date and time for the calendar event.

Past Boolean False

Boolean value for past calendar events.

Private Boolean False

Whether this calendar event is private.

RemindAt Datetime False

The date and time for the calendar event reminder.

StartsAt Datetime False

The start date and time for the calendar event.

SubscribersId String False

The Id of the subscriber to the calendar event.

SubscribersName String False

The name of the subscriber to the calendar event.

Summary String False

The summary for the calendar event.

Trashed Boolean False

Boolean value for deleted calendar events.

UpdatedAt Datetime True

The date and time when the calendar event was updated.

Url String True

The URL of the calendar event.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ProjectId String

The Id of the Project associated with the calendar event.

CalendarId String

The calendar Id associated with the calendar event.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587