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