JDBC Driver for Basecamp

Build 24.0.9060

Projects

Retrieve, create, update, and delete Projects on Basecamp.

Table Specific Information

Select

You can retrieve all active Projects from the organization, filter records by Drafts and Archived Projects, or simply set a Project Id for more information. Drafts, Archived, and Id are the columns supported as search criteria by Basecamp. 

SELECT * FROM Projects WHERE Drafts = True
SELECT * FROM Projects WHERE Advanced = True
SELECT * FROM Projects WHERE Id = '11111111'

Insert

Specify the Name and Description properties at a minimum to create a new Project. 

INSERT INTO Projects (Name, Description) VALUES ('Test Proj', 'This is a new test project.')

Update and Delete

Simply set the Project Id to update or delete a project you have access to. 

UPDATE Projects SET Name = 'Updated Proj', Description = 'This is an updated test project.' WHERE Id = '11111111'

DELETE FROM Projects WHERE Id = '11111111'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The unique identifier of the project.

AccessesAppUrl String True

The accesses app URL.

AccessesCount Integer True

The accesses count.

AccessesUpdatedAt Datetime True

Time when accesses were updated.

AccessesUrl String True

The accesses URL.

AppUrl String True

The app URL.

Archived Boolean False

When user archives a project, this value will be set to true.

AttachmentsAppUrl String True

The attachments app URL.

AttachmentsCount Integer True

The attachments count.

AttachmentsUpdatedAt Datetime True

Time when attachments were updated.

AttachmentsUrl String True

The attachments URL.

CalendarEventsAppUrl String True

The calendar events app URL.

CalendarEventsCount Integer True

The calendar events count.

CalendarEventsUpdatedAt Datetime True

Time when calendar events were updated.

CalendarEventsUrl String True

The calendar events URL.

Color String True

Color.

CreatedAt Datetime True

The creation time of the project.

CreatorAvatarUrl String False

Creator Avatar URL.

CreatorFullsizeAvatarUrl String False

Creator full-size Avatar URL.

CreatorId String False

The Id of the creator.

CreatorName String False

The name of the creator.

Description String False

The description of the project.

DocumentsAppUrl String True

The documents app URL.

DocumentsCount Integer True

The documents count.

DocumentsUpdatedAt Datetime True

Time when documents were updated.

DocumentsUrl String True

The documents URL.

Drafts Boolean False

Boolean value for a draft project.

ForwardsAppUrl String True

The forwards app URL.

ForwardsCount Integer True

The forwards count.

ForwardsUpdatedAt Datetime True

Time when forwards were updated.

ForwardsUrl String True

The forwards URL.

IsClientProject Boolean False

Whether the project is related to clients or not.

LastEventAt Datetime False

Time when the project was last modified.

Name String False

The name of the project.

Starred Boolean False

Boolean value for a starred project.

Template Boolean False

Boolean value for a template project.

TodolistsAppUrl String True

The todolists app URL.

TodolistsCompletedCount Integer True

The todolists completed count.

TodolistsRemainingCount Integer True

The todolists remaining count.

TodolistsUpdatedAt Datetime True

Time when todolists were updated.

TodolistsUrl String True

The todolists URL.

TopicsAppUrl String True

The topics app URL.

TopicsCount Integer True

The topics count.

TopicsUpdatedAt Datetime True

Time when topics were updated.

TopicsUrl String True

The topics URL.

Trashed Boolean False

Boolean value for a trashed project.

UpdatedAt Datetime True

Time when the project was updated.

URL String True

The URL of the project.

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