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