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

Table Specific Information

Select

The add-in 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. If the Id is also specified, this filter must be processed client-side.

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

For example:

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

Insert

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

INSERT INTO Projects (Name, description, visibility, CapabilitiesVersionControlType, CapabilitiesProcessTemplateTypeId) VALUES ('cdata','demo project', 'private', 'Git', '6b724908-ef14-45cf-84f8-768b5384da45')

Update

The following is an example of updating the Projects table:

UPDATE Projects SET name='Cdata' where Id='b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'

Delete

The following is an example of deleting from the Projects table:

DELETE FROM Projects WHERE Id = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'

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.
Links	String	True		Aggregate of the reference links.
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

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