Skip to main content

projects

Creates, updates, deletes, gets or lists a projects resource.

Overview

Nameprojects
TypeResource
Idazure_extras.visual_studio.projects

Fields

The following fields are returned by SELECT queries:

The operation succeeded. The response contains the details of the updated team project resource.

NameDatatypeDescription
idstringUnique identifier of the resource.
namestringResource name.
locationstringResource location.
propertiesobjectKey/value pair of resource properties.
tagsobjectResource tags.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, subscriptionId, rootResourceName, resourceNameGets the details of a Team Services project resource.
list_by_resource_groupselectresourceGroupName, subscriptionId, rootResourceNameGets all Visual Studio Team Services project resources created in the specified Team Services account.
createinsertresourceGroupName, subscriptionId, rootResourceName, resourceNamevalidatingCreates a Team Services project in the collection with the specified name. 'VersionControlOption' and 'ProcessTemplateId' must be specified in the resource properties. Valid values for VersionControlOption: Git, Tfvc. Valid values for ProcessTemplateId: 6B724908-EF14-45CF-84F8-768B5384DA45, ADCC42AB-9882-485E-A3ED-7678F01F66BC, 27450541-8E31-4150-9947-DC59F998FC01 (these IDs correspond to Scrum, Agile, and CMMI process templates).
updateupdateresourceGroupName, subscriptionId, rootResourceName, resourceNameUpdates the tags of the specified Team Services project.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
resourceGroupNamestringName of the resource group within the Azure subscription.
resourceNamestringName of the Team Services project.
rootResourceNamestringName of the Team Services account.
subscriptionIdstringThe Azure subscription identifier.
validatingstringThis parameter is ignored and should be set to an empty string.

SELECT examples

Gets the details of a Team Services project resource.

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure_extras.visual_studio.projects
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND rootResourceName = '{{ rootResourceName }}' -- required
AND resourceName = '{{ resourceName }}' -- required
;

INSERT examples

Creates a Team Services project in the collection with the specified name. 'VersionControlOption' and 'ProcessTemplateId' must be specified in the resource properties. Valid values for VersionControlOption: Git, Tfvc. Valid values for ProcessTemplateId: 6B724908-EF14-45CF-84F8-768B5384DA45, ADCC42AB-9882-485E-A3ED-7678F01F66BC, 27450541-8E31-4150-9947-DC59F998FC01 (these IDs correspond to Scrum, Agile, and CMMI process templates).

INSERT INTO azure_extras.visual_studio.projects (
data__location,
data__tags,
data__properties,
resourceGroupName,
subscriptionId,
rootResourceName,
resourceName,
validating
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ rootResourceName }}',
'{{ resourceName }}',
'{{ validating }}'
RETURNING
id,
name,
location,
properties,
tags,
type
;

UPDATE examples

Updates the tags of the specified Team Services project.

UPDATE azure_extras.visual_studio.projects
SET
data__location = '{{ location }}',
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND rootResourceName = '{{ rootResourceName }}' --required
AND resourceName = '{{ resourceName }}' --required
RETURNING
id,
name,
location,
properties,
tags,
type;