Projects
Retrieve, create, update, and delete Projects on Basecamp 3.
テーブル固有の情報
Select
You can retrieve all active Projects from the organization, or set a project Id to retrieve a single project. Id is the only column supported as search criteria by Basecamp.
SELECT * FROM Projects WHERE Id = '11111111'
Insert
Specify at least the Name and optionally Description properties to create a new Project.
INSERT INTO Projects (Name, Description) VALUES ('Test Proj', 'This is a new test project.')
Update およびDelete
Set the Project Id to update or delete a project you have access to.
UPDATE Projects SET Name = 'Updated Project', Description = 'This is an updated test project.' WHERE Id = '11111111' DELETE FROM Projects WHERE Id = '11111111'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
The unique identifier of the project. | |
| Status | String | True |
The status of the project. | |
| Purpose | String | True |
The purpose of the project. | |
| CreatedAt | Datetime | True |
The creation time of the project. | |
| UpdatedAt | Datetime | True |
Time when the project was updated. | |
| Description | String | False |
The description of the project. | |
| Name | String | False |
The name of the project. | |
| Bookmarked | Boolean | False |
Boolean value for a bookmarked project. | |
| CalendarId | Long | True |
Id of the project's Calendar. | |
| ChatId | Long | True |
Id of the project's Chat. | |
| ToDoSetId | Long | True |
Id of the project's ToDo Set. | |
| MessageBoardId | Long | True |
Id of the project's Message Board. | |
| QuestionnaireId | Long | True |
Id of the project's Questionnaire. | |
| VaultId | Long | True |
Id of the project's Vault. | |
| InboxId | Long | True |
Id of the project's Inbox. | |
| KanbanBoardId | Long | True |
Id of the project's Kanban Board. |