FireDAC Components for Basecamp

Build 20.0.7587

Messages

Retrieve messages on Basecamp 3.

Table Specific Information

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

Select

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'

Insert

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')

Update

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'

Delete

Messages cannot be deleted.

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

The unique identifier of the message.

ProjectId Long True

Projects.Id

The Project Id associated with the schedule.

MessageBoardId Long True

Projects.MessageBoardId

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

People.Id

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-Columns

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