Accesses
Retrieve, grant, and deny access permissions to Projects and Calendars on Basecamp.
Table Specific Information
Select
You need to specify a ProjectId or CalendarId to retrieve Accesses. These columns are also the only columns supported by Basecamp as filter criteria; they can be used with the '=' operator.
SELECT * FROM Accesses WHERE ProjectId = '11111111' SELECT * FROM Accesses WHERE CalendarId = '11111111'
Insert
You can give someone access to a Project or Calendar using their Email Addresses or Ids (if they are part of the organization already).
INSERT INTO Accesses (ProjectId, EmailAddresses) VALUES ('11111111', '[email protected], [email protected]')
INSERT INTO Accesses (CalendarId, Ids) VALUES ('11111111', '123456789, 987654321')
Update
UPDATE is not a supported operation for the table Accesses.
Delete
To revoke access to someone from a Project or Calendar, specify the ProjectId or CalendarId and the Person's 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
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 | String |
The Project Id associated with the access. |
| CalendarId | String |
The Calendar Id associated with the access. |