Projects
Get all projects in the organization that the authenticated user has access to and details of the specific project.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier of the project. | |
| CapabilitiesProcessTemplateName | String | False |
Process template capabilities this project has. | |
| CapabilitiesProcessTemplateTypeId | String | False |
Process template capabilities this project has. | |
| CapabilitiesVersionControlType | String | False |
Version control capabilities this project has. | |
| CapabilitiesVersionControlGitEnabled | Boolean | False |
Version control capabilities this project has. | |
| CapabilitiesVersionControlTfvcEnabled | Boolean | False |
Version control capabilities this project has. | |
| DefaultTeamId | String | False |
Team (identity) GUID. | |
| DefaultTeamName | String | False |
The name of the default team. | |
| DefaultTeamUrl | String | False |
The URL of the team. | |
| DefaultTeamImageUrl | String | False |
URL to default team identity image. | |
| Description | String | False |
The description of the project. | |
| LastUpdateTime | Datetime | False |
The timestamp at which the project was last updated. | |
| Links | String | True |
Aggregate of the reference links. | |
| Name | String | False |
The name of the project. | |
| Revision | Integer | False |
The revision of the project. | |
| State | String | False |
The current state of the project. | |
| Url | String | False |
URL to the full version of the object. | |
| Visibility | String | False |
Indicates whom the project is visible to. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。
| Name | Type | Description |
| GetDefaultTeamImageUrl | Boolean |
If set, returns of the default team image URL. |
| IncludeCapabilities | Boolean |
Include capabilities (such as source control) in the team project result (default: false). |