Excel Add-In for Basecamp

Build 24.0.9060

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.

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