Tableau Connector for Azure DevOps

Build 24.0.9060

DeploymentGroups

Retrieves a list of all deployment groups.

Table Specific Information

Select

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

  • ProjectId supports the '=' operator.
  • Id supports the '=' operator.
  • Name supports the '=' operator.
  • Action supports the '=' operator.
  • Expand supports the '=' operator.
The rest of the filter is executed client-side in the connector.

For example:

    SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Id = 29
	SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Action = 'manage'
	SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Expand = 'tags'

Insert

The following is an example of inserting into a DeploymentGroups table:

INSERT INTO DeploymentGroups (ProjectId, Name) VALUES ('c831d3b4-a289-462f', 'TestName')

Update

The following is an example of updating a DeploymentGroups table:

UPDATE DeploymentGroups SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'

Delete

The following is an example of deleting data in a DeploymentGroups table:

DELETE FROM DeploymentGroups WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the deployment group.

Description String False

Description of the deployment group.

MachineCount Integer True

Number of deployment targets in the deployment group.

MachineTags String True

List of unique tags across all deployment targets in the deployment group.

Name String False

Name of the deployment group.

PoolId Integer False

Id of the agent pool.

PoolIsHosted Boolean True

A value indicating whether or not this pool is managed by the service.

PoolIsLegacy Boolean True

Determines whether the pool is legacy.

PoolName String True

Name of the pool.

PoolType String True

The type of the pool.

PoolScope String True

The scope of the pool.

PoolSize Integer True

The current size of the pool.

ProjectId String True

Id of the project.

ProjectName String True

Name of the project.

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
Action String

Get the deployment group only if this action can be performed on it.

The allowed values are manage, none, use.

Expand Boolean

Include these additional details in the returned object.

The allowed values are none, tags.

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