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. |