CData Python Connector for Azure DevOps

Build 24.0.9060

VariableGroups

Retrieves a list of variable 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 '=,in' operators.
  • Name supports the '=' operator.
  • Action supports the '=' operator.

The rest of the filter is executed client-side in the connector.

For example:

	SELECT * FROM VariableGroups WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4'
	SELECT * FROM VariableGroups WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND Id IN (1, 2, 3)

Insert

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

INSERT INTO VariablesAggregate#TEMP ([key1.value]) VALUES ('value1')
INSERT INTO VariableGroups (ProjectId, Name, Type, Variables) VALUES ('b154d8f3-bfd9-4bfb', 'TestVarGroup', 'Vsts', 'VariablesAggregate#TEMP')

Update

The following is an example of updating a VariableGroups table:

UPDATE VariableGroups SET Name = 'cdata2', Variables = '{\"name\" : \"cdata\"}' WHERE Id = 2 AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'

Delete

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

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

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the variable group.

ProjectId String True

Id of the project.

CreatedByDisplayName String True

The display name of the user who created this variable group.

CreatedById String True

The Id of the user who created this variable group.

CreatedByUrl String True

The URL od the user who created this variable group.

CreatedOn Datetime True

The time when variable group was created.

Description String False

Description of the variable group.

IsShared Boolean True

Indicates whether variable group is shared with other projects or not.

ModifiedByDisplayName String True

The display name of the user who modified this variable group.

ModifiedById String True

The Id of the user who modified this variable group.

ModifiedByUrl String True

The URL of the user who modified this variable group.

ModifiedOn Datetime True

The time when variable group was modified.

Name String False

Name of the variable group.

ProviderData String False

Provider data.

Type String False

Type of the variable group.

Variables String False

Variables contained in the variable group.

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

Specifies the action which can be performed on the variable groups.

The allowed values are manage, none, use.

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