ODBC Driver for Azure DevOps

Build 24.0.9060

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

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. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.

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