Table Projects
Description
No description available
Supported Operations
Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.| Method | Supported | Reference EndPoint |
|---|---|---|
| SELECT | get_projects | |
| INSERT | add_project | |
| UPDATE | update_project | |
| UPSERT | ||
| DELETE | delete_project | |
| LOOKUP | get_project |
Examples
SSIS
Use Azure DevOps Connector in API Source component to read data or in API Destination component to read/write data:
Read from Projects table using API Source
| There are no parameters to configure. |
Read/write to Projects table using API Destination
| There are no parameters to configure. |
ODBC application
Use these SQL queries in your ODBC application data source:
List projects
<p>Returns all projects in the organization. Use this to discover project names and IDs for use in other queries or in the connection default project. Columns include Id, Name, Description, Url, State, Revision, Visibility, and LastUpdateTime.</p>
SELECT * FROM ProjectsList projects (specific columns)
<p>Returns projects in the organization with only the columns you select (e.g. Id, Name, Description, Url, State, Revision, Visibility, LastUpdateTime). Use this to reduce payload size or to build a dropdown or report that needs a subset of project fields.</p>
SELECT Id, Name, Description, Url, State, Revision, Visibility, LastUpdateTime FROM ProjectsGet project by ID
<p>Returns a single project by its GUID. Use the project Id from the list of projects when you need full details for one project (e.g. name, description, visibility, last update time).</p>
SELECT * FROM Projects WHERE Id='a80fb082-f7c4-4345-911d-1c05ad1b1fc9'Create project
<p>Creates a new project in the organization. Supply name, abbreviation, description, source control type (Git or Tfvc), and visibility (private or public). The project is created asynchronously; poll or refresh to see it in the list. Requires appropriate organization permissions.</p>
INSERT INTO Projects (Name, Abbreviation, Description, SourceControlType, Visibility)
VALUES
('My New Project', 'MNP',
'The system we use for implementing point-of-service walk-in payment systems.',
'Git', 'private')Update project by ID
<p>Updates an existing project by its ID. Set the columns you want to change (e.g. Name, Description, Visibility); the WHERE clause targets the project. Use when you need to rename a project, change its description, or update visibility.</p>
UPDATE Projects SET Description = 'The system we use for implementing point-of-service walk-in payment systems and phone payments.'
WHERE Id='1be9ccef-45d7-4574-af67-7dc6c0699b6a'Delete project by ID
<p>Deletes a project by its ID. The project and its data are removed. This operation is irreversible and requires appropriate permissions. Confirm the project ID before running.</p>
DELETE FROM Projects WHERE Id='85kd1641-5555-49b1-9c5e-22c22a61d4c4'SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
List projects
<p>Returns all projects in the organization. Use this to discover project names and IDs for use in other queries or in the connection default project. Columns include Id, Name, Description, Url, State, Revision, Visibility, and LastUpdateTime.</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Projects';
EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];List projects (specific columns)
<p>Returns projects in the organization with only the columns you select (e.g. Id, Name, Description, Url, State, Revision, Visibility, LastUpdateTime). Use this to reduce payload size or to build a dropdown or report that needs a subset of project fields.</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT Id, Name, Description, Url, State, Revision, Visibility, LastUpdateTime FROM Projects';
EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];Get project by ID
<p>Returns a single project by its GUID. Use the project Id from the list of projects when you need full details for one project (e.g. name, description, visibility, last update time).</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Projects WHERE Id=''a80fb082-f7c4-4345-911d-1c05ad1b1fc9''';
EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];Create project
<p>Creates a new project in the organization. Supply name, abbreviation, description, source control type (Git or Tfvc), and visibility (private or public). The project is created asynchronously; poll or refresh to see it in the list. Requires appropriate organization permissions.</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Projects (Name, Abbreviation, Description, SourceControlType, Visibility)
VALUES
(''My New Project'', ''MNP'',
''The system we use for implementing point-of-service walk-in payment systems.'',
''Git'', ''private'')';
EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];Update project by ID
<p>Updates an existing project by its ID. Set the columns you want to change (e.g. Name, Description, Visibility); the WHERE clause targets the project. Use when you need to rename a project, change its description, or update visibility.</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Projects SET Description = ''The system we use for implementing point-of-service walk-in payment systems and phone payments.''
WHERE Id=''1be9ccef-45d7-4574-af67-7dc6c0699b6a''';
EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];Delete project by ID
<p>Deletes a project by its ID. The project and its data are removed. This operation is irreversible and requires appropriate permissions. Confirm the project ID before running.</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Projects WHERE Id=''85kd1641-5555-49b1-9c5e-22c22a61d4c4''';
EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];