ADO.NET Provider for Basecamp

Build 24.0.8963

CardTableCards

Create, Update, and Query the Card table cards.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the 本製品.
SELECT * FROM CardTableCards WHERE ProjectId = '37595039' AND CardTableColumnId = '7416523073'
SELECT * FROM CardTableCards WHERE ProjectId = '37595039' AND Id = '7416545710'

Insert

The columns CardTableColumnId, ProjectId and Title are required to insert.

INSERT INTO CardTableCards(ProjectId, CardTableColumnId, Title, Content, DueOn) VALUES('37595039', '7416523073', 'Test title2', 'Test Content2', '2025-01-02')

Update

You must specify the ProjectId and Id of the CardTableCard to update it.

UPDATE CardTableCards SET Title = 'Updated title' WHERE ProjectId = '37595039' AND Id = '7420207738'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Projects.KanbanBoardId

Id of the Card Table column.

ProjectId Long True

Projects.Id

The Project Id.

CardTableColumnId Long True

CardTableColumns.Id

The CardTableColum Id.

VisibleToClients Boolean True

Boolean value representing whether the columns are visible to clients.

CreatedAt Datetime True

The creation date.

UpdatedAt Datetime True

The updation date.

Title String False

Title.

InheritsStatus Boolean True

Inherits status.

Type String True

Type.

Url String True

Url.

AppUrl String True

App url.

BookmarkUrl String True

Bookmark url.

SubscriptionUrl String True

Subscription url.

Position Integer True

Position.

ParentId Long True

Parent Id.

ParentTitle String True

Parent title.

ParentType String True

Parent Type.

ParentUrl String True

Parent url.

ParentAppUrl String True

Parent app url.

BucketId Long True

Project Id.

BucketName String True

Project name.

BucketType String True

Project type.

CreatorId Long True

People.Id

Creator Id.

Description String False

Description.

Completed Boolean True

Completed.

Content String False

Content.

DueOn Datetime False

Due date.

CommentCount Integer True

Comment count.

CommentsCount Integer True

Comments count.

CommentsUrl String True

Comments Url.

Assignees String True

Assigness.

CompletionSubscribers String True

Completion subscribers.

CompletionUrl String True

Completion url.

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