FireDAC Components for Basecamp

Build 20.0.7587

Vaults

Retrieve Vaults(folders) on Basecamp 3 folders.

Table Specific Information

All projects have a primary Vault (folder). Additional Vaults may be nested under the primary Vault or any child Vault.

Select

The columns supported as search criteria by Basecamp are ProjectId, VaultId, and Id. If ProjectId is not specified in the query, the default ProjectId will be used.

SELECT * FROM Vaults WHERE  ProjectId = '11111111' AND VaultId = '222222222'

You can also retrieve a single To-do by specifying the Id.

SELECT * FROM Vaults WHERE  ProjectId = '11111111' Id = '333333333'

Insert

You can insert a new Vault by providing the ProjectId, VaultId, and Title, which are required parameters.

INSERT INTO Vaults (Title, ProjectId, Vaultid) VALUES ('InsertedVault', '11111111', '222222222')

Update

You can update the Vault title by providing the ProjectId, VaultId, and the new title.

UPDATE Vaults SET Title = 'Updated title' WHERE ProjectId = '11111111' AND Id = '333333333'

Delete

Vaults cannot be deleted.

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

The unique identifier of the topic.

ProjectId Long True

Projects.Id

The Project Id associated with the vault.

Status String True

The status of the vault.

Title String False

The title of the returned record.

Type String True

The type of the returned record.

CreatedAt Datetime True

The date and time when the record was created.

UpdatedAt Datetime True

The date and time when the record was last updated.

ParentId Long True

Id of the parent.

ParentTitle String True

Title of the parent.

ParentType String True

Type of the parent.

BucketId Long True

Id of the containing bucket.

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.

DocumentsCount Integer True

Number of documents the vault contains.

UploadsCount Integer True

Number of uploads the vault contains.

VaultsCount Integer True

Number of vaults the vault contains.

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
VaultId Long

The Vault Id that the record belongs to.

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