ADO.NET Provider for Basecamp

Build 24.0.8963

People

Retrieve and delete People on Basecamp.

テーブル固有の情報

Select

組織のすべての人を取得し、より多くの情報を取得するにはId を指定し、だれが削除されたかを確認できます(管理者アクセスが必要です)。Basecamp において検索条件としてサポートされているカラムはId およびTrashed です。

SELECT * FROM People WHERE Id = '123456789'

SELECT * FROM People WHERE Trashed = true

INSERT

Accesses テーブルを通じてProjects に新しい人を直接招待することができます。

Update

UUPDATE 処理はPeople テーブルではサポートされていません。

Delete

組織からレコードを削除するにはPerson のId を指定します。

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963