Vaults
Retrieve Vaults(folders) on Basecamp 3 folders.
テーブル固有の情報
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| VaultId | Long |
The Vault Id that the record belongs to. |