Power BI Connector for Basecamp

Build 20.0.7587

Events

Retrieve activity Events on Basecamp.

Table Specific Information

Select

You can retrieve all activity Events or filter data by the created date. The columns and operators supported by Basecamp as search criteria are shown below.

ColumnOperators
ProjectId=
PersonId=
CreatedAt>, >=

For example, the following query retrieves activity occurring after the specified date for the specified person:

SELECT * FROM Events WHERE CreatedAt >= '2016-01-01' AND PersonId = '1111111'

Columns

Name Type References Description
Id [KEY] String The unique identifier of the event.
Action String The action description for the event.
BucketAppUrl String The calendar events app URL.
BucketColor String The bucket event color.
BucketId String The bucket event Id.
BucketName String The bucket event name.
BucketType String The bucket event type.
BucketUrl String The bucket event URL.
CreatedAt Datetime The date and time when the event was created.
CreatorAvatarUrl String Creator Avatar URL.
CreatorFullsizeAvatarUrl String Creator full-size avatar URL.
CreatorId String The Id of the event creator.
CreatorName String The name of the event creator.
EventableAppUrl String Eventable App URL.
EventableId String Eventable Id.
EventableType String Eventable type.
EventableUrl String Eventable URL.
Excerpt String The type of excerpt for this event.
HtmlUrl String The HTML URL of the event.
Private Boolean Whether the event is private.
RawExcerpt String The raw excerpt type for this event.
Summary String The summary for the event.
Target String The target project of this event.
UpdatedAt Datetime The date and time when the event was last updated.
URL String The URL of the 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 this event.
PersonId String The Id of the Person associated with this event.

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