Endpoint

Get Project Details

Name

get_project

Description

Gets the details of the specified project within the organization by its project Id. [API reference]

Related Tables

Projects

Parameters

Parameter	Label	Required	Options	Description
Id	Id	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(500)`	500	`False`
Name	`DT_WSTR`	`nvarchar(500)`	500	`False`
Description	`DT_WSTR`	`nvarchar(1160)`	1160	`False`
Url	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
State	`DT_WSTR`	`nvarchar(100)`	100	`False`
Revision	`DT_I4`	`int`		`False`
Visibility	`DT_WSTR`	`nvarchar(100)`	100	`False`
LastUpdateTime	`DT_DBTIMESTAMP`	`datetime`		`False`

If the column you are looking for is missing, consider customizing Azure DevOps Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Project Id	`DT_WSTR`	`nvarchar(300)`	300	`False`

Required columns that you need to supply are bolded.

Examples

SSIS

Use Azure DevOps Connector in API Source component to read data or in API Destination component to read/write data:

Lookup a row in Projects table using API Destination

This Endpoint belongs to Projects table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Azure DevOps

Projects

Lookup

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get project details

SELECT * FROM get_project
WHERE Id = 'abcd-1234-id'

Get details about a specific project by its Id

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

get_project endpoint belongs to Projects table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get project details

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_project
WHERE Id = ''abcd-1234-id''';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_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 [LS_TO_AZURE_DEVOPS_IN_GATEWAY];

get_project endpoint belongs to Projects table(s), and can therefore be used via those table(s).