ADO.NET Provider for Basecamp

Build 24.0.8963

People

Retrieve People on Basecamp 3.

ビュー固有の情報

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ProjectId Long Use filter to retrieve active people on the project with the given ID.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963