ADO.NET Provider for Basecamp

Build 24.0.8963

Accesses

Retrieve, grant, and deny access permissions to Projects and Calendars on Basecamp.

テーブル固有の情報

Select

Accesses を取得するには、ProjectId もしくはCalendarId を指定する必要があります。これらのカラムはBasecamp がフィルタ条件として'=' 演算子と共に使うことがサポートされています。

SELECT * FROM Accesses WHERE ProjectId = '11111111'
SELECT * FROM Accesses WHERE CalendarId = '11111111'

Insert

Email Address もしくはId(すでに組織のメンバーである場合)を使って、メンバーにProject もしくはCalendar へのアクセスを与えることができます。

INSERT INTO Accesses (ProjectId, EmailAddresses) VALUES ('11111111', '[email protected], [email protected]')

INSERT INTO Accesses (CalendarId, Ids) VALUES ('11111111', '123456789, 987654321')

Update

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

Delete

Project もしくはCalendar から特定の人のアクセス権を削除するには、ProjectId もしくはCalendarId とその人のId を指定します。

DELETE FROM Accesses WHERE ProjectId = '11111111' AND Id = '123456789'
DELETE FROM Accesses WHERE CalendarId = '11111111' AND Id = '123456789'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The unique identifier of the person with access to the project or calendar.

Admin Boolean True

Boolean value to show if the current person is an admin or not.

AppUrl String True

The app URL.

AvatarUrl String True

The avatar URL of the person.

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 with access to the project or calendar.

FullsizeAvatarUrl String True

The full-size avatar URL of the person.

IdentityId String True

The identity Id of the person with access to the project or calendar.

IsClient Boolean False

Is the returned user a client or not.

Name String True

The name of the person with access to the project or calendar.

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.

Ids String False

A comma separated list of user Ids to be granted access to a project or calendar.

EmailAddresses String False

A comma separated list of user email addresses to be granted access to a project or calendar.

Pseudo-Columns

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

Name Type Description
ProjectId String

The Project Id associated with the access.

CalendarId String

The Calendar Id associated with the access.

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