FireDAC Components for Basecamp

Build 20.0.7587

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

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.

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