SSIS Components for Azure DevOps

Build 24.0.9063

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

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