Power BI Connector for Basecamp

Build 20.0.7587

People

Retrieve and delete People on Basecamp.

Table Specific Information

Select

Retrieve all People from the organization, specify an Id to get more info, or see who has been deleted (admin access is required). Id and Trashed are the columns supported by Basecamp as search criteria.

SELECT * FROM People WHERE Id = '123456789'

SELECT * FROM People WHERE Trashed = true

Insert

New People can be invited directly to Projects via the Accesses table.

Update

Update is not a supported operation for the table People.

Delete

Specify the Person's Id to delete the record from the organization.

DELETE FROM People WHERE Id = '123456789'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The unique identifier for the person.

AccountOwner Boolean True

Boolean value to show if the current person is the account owner.

Admin Boolean True

Boolean value to show if the current person is an admin or not.

AssignedTodosCount Integer True

Number of assigned to-dos.

AssignedTodosUpdatedAt Datetime True

The date and time when the record was updated.

AssignedTodosUrl String True

The URL of the assigned to-do.

AppUrl String True

The app URL.

AvatarUrl String True

The avatar URL of the person.

CalendarEventsTodayCount Integer True

Number of events for today.

CanCreateProjects Boolean True

Whether the person can create projects or not.

CreatedAt Datetime True

The date and time when the record was created.

EmailAddress String True

The email address of the person.

EventsAppUrl String True

The events app URL.

EventsCount Integer True

Number of events.

EventsUpdatedAt Datetime True

The date and time when the event was updated.

EventsUrl String True

The URL of the assigned to-do.

FullsizeAvatarUrl String True

The full-size avatar URL of the person.

HasBasecampSiblings Boolean False

Boolean value for Basecamp siblings.

IdentityId String True

The identity Id of the person.

Name String True

The name of the person.

OutstandingTodosCount Integer True

Number of outstanding to-dos.

Trashed Boolean False

Boolean value for deleted people.

UpdatedAt Datetime True

The date and time when the record was last updated.

Url String True

The URL of the person.

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