Power BI Connector for Basecamp

Build 20.0.7587

Calendars

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

Table Specific Information

Select

Select all from Calendars or specify an Id to retrieve more detail on a certain Calendar (Id is the only column supported as search criteria by Basecamp).

SELECT * FROM Calendars WHERE Id = '123456789'

Insert

Specify (at least) the Name property to create a new Calendar under the organization.

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

Update and Delete

Specify a Calendar Id to update or delete Calendars. Set the Name property again if you are updating.

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