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. |