Power BI Connector for Basecamp

Build 20.0.7587

Projects

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

Table Specific Information

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587