ADO.NET Provider for Basecamp

Build 24.0.8963

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.

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