FireDAC Components for Basecamp

Build 20.0.7654


Retrieve messages on Basecamp 3.

Table Specific Information

You can query messages posted on the message board of the specified project.


The columns supported as search criteria by Basecamp are ProjectId, MessageBoardId.

If ProjectId is not specified in the query, the default ProjectId will be used.

SELECT * FROM Messages WHERE ProjectId = '11111111' AND MessageBoardId = '22222222'

You can also retrieve a single message by specifying the Id.

SELECT * FROM Messages WHERE  ProjectId = '11111111' AND Id = '33333333'


You can insert a new message, by providing the required ProjectId, MessageBoardId, and Subject in addition to the message related parameters.

INSERT INTO Messages (ProjectId, MessageBoardId, Content, Subject, Status ) VALUES ('1111111', '2222222', 'Content test', 'Subject test',  'active')


You can also update messages by providing the ProjectId and message Id.

UPDATE Messages SET subject = 'Updated subject', content = 'Updated content'  WHERE ProjectId = '11111111' AND Id = '1234567689'


Messages cannot be deleted.


Name Type ReadOnly References Description
Id [KEY] Long True

The unique identifier of the message.

ProjectId Long True


The Project Id associated with the schedule.

MessageBoardId Long True


The Message Board Id that the message belongs to.

Status String False

The status of the message

Type String True

The type of the returned record.

CreatedAt Datetime True

The date and time when the message was created.

UpdatedAt Datetime True

The date and time when the message was last updated.

Content String False

Provided content for the message

Subject String False

Subject of the message

ParentTitle String True

Title of the parent.

ParentType String True

Type of the parent.

BucketName String True

Name of the containing bucket.

BucketType String True

Type of the containing bucket.

CreatorId Long True


The Id of the creator.

CreatorName String True

The name of the creator.

CategoryId Long False

The Id of the category.

CategoryName String True

The name of the category.

CommentsCount Integer True

Number of comments the document has.


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
IncludeReplies Boolean

Set this to true to retrieve replies for each message.

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