List Projects

Table Specific Information

Select

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

• ProjectSK supports the '=,in' operator.

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

For example:

	SELECT * FROM Projects WHERE ProjectSK = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM Projects WHERE ProjectSK IN ('837ccd31-8159-4db3-b8ce-de0c36d2a0bf', '837ccd31-8159-4db3-b8ce-de0c36d2a0hg')

Columns

Name	Type	References	Description
ParentReference	String
ProjectSK [KEY]	String
ProjectId	String
ProjectName	String
ProjectVisibility	String