Azure DevOps Connector
Documentation
Version: 2
Documentation
Home » API Integration Hub » Azure DevOps Connector » Tables » Projects

Table Projects

Description

No description available

Parameters

Parameter Label Required Options Description Help
There are no parameters

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

Azure DevOps
Projects
SSIS API Source - Read from table or endpoint

Read/write to Projects table using API Destination

Azure DevOps
Projects
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get a list of projects associated with your Azure DevOps organization. 

SELECT * FROM Projects

Get specific columns from a list of projects associated with your Azure DevOps organization. 

SELECT Id, Name, Description, Url, State, Revision, Visibility, LastUpdateTime FROM Projects

Get details about a specific project by its Id. 

SELECT * FROM Projects WHERE Id='a80fb082-f7c4-4345-911d-1c05ad1b1fc9'

Create a new project for your organization. 

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 an existing project for your organization by referencing its Id. 

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 the specified project from your organization. 

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:

Get a list of projects associated with your Azure DevOps organization. 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Projects';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];

Get specific columns from a list of projects associated with your Azure DevOps organization. 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT Id, Name, Description, Url, State, Revision, Visibility, LastUpdateTime FROM Projects';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];

Get details about a specific project by its Id. 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Projects WHERE Id=''a80fb082-f7c4-4345-911d-1c05ad1b1fc9''';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];

Create a new project for your organization. 

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 [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];

Update an existing project for your organization by referencing its Id. 

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 [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];

Delete the specified project from your organization. 

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Projects WHERE Id=''85kd1641-5555-49b1-9c5e-22c22a61d4c4''';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];