JDBC Driver for Basecamp

Build 22.0.8462


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.


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'


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


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'


Vaults cannot be deleted.


Name Type ReadOnly References Description
Id [KEY] Long True

The unique identifier of the topic.

ProjectId Long True


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


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 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462