People
Retrieve People on Basecamp 3.
View Specific Information
Select
Retrieve all People visible to the current user, list people by Project, or specify an Id to get more information. Id and ProjectId are the columns supported by Basecamp as search criteria.
SELECT * FROM People WHERE Id = '123456789' SELECT * FROM People WHERE ProjectId = '5168618'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | The unique identifier for the person. | |
| Name | String | The name of the person. | |
| Owner | Boolean | Boolean value to show if the current person is the account owner. | |
| Admin | Boolean | Boolean value to show if the current person is an admin or not. | |
| Title | String | The title of the person. | |
| Bio | String | Bio description of the person. | |
| CreatedAt | Datetime | The date and time when the record was created. | |
| UpdatedAt | Datetime | The date and time when the record was last updated. | |
| EmailAddress | String | The email address of the person. | |
| AttachableSgid | String | The attachable Set Group ID. | |
| PersonableType | String | Type of the person. | |
| TimeZone | String | Human readable timezone for the user. | |
| CompanyId | Long | Id of users company. | |
| CompanyName | String | Name of users company. |
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 | Long | Use filter to retrieve active people on the project with the given ID. |