Tableau Connector for Azure DevOps

Build 23.0.8839

Projects

Get all projects in the organization that the authenticated user has access to and details of the specific project.

Table Specific Information

Select

The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=' operator.
  • State supports the '=' operator.
The rest of the filter is executed client-side in the connector.

For example:

	SELECT * FROM Projects WHERE Id = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND State = 'wellFormed'

Insert

The following is an example of inserting into the Projects table:

INSERT INTO Projects (Name, Description, Visibility, CapabilitiesVersionControlType, CapabilitiesProcessTemplateTypeId) VALUES ('TestProject', 'This is a test', 'private', 'Git', '6b724908-ef14-45cf')

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.

LinksCollectionHref String True

Collection reference links.

LinksSelfHref String True

Self reference link.

LinksWebHref String True

Web reference link.

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 23.0.8839