Endpoint

Get Work Item Column Fields

Name

get_workitem_fields

Description

Get work item column fields in the default project within the organization. Read more about description on each field here https://learn.microsoft.com/en-us/azure/devops/boards/work-items/guidance/work-item-field?view=azure-devops [API reference]

Parameters

Parameter

Label

Required

Options

Description

Project

Project Name

YES

The Name of the project.

Expand

Expand Parameters

Option	Value
None	None
Relations	Relations
Fields	Fields
Links	Links
All	All

The expand parameters for work item attributes. Possible options are 'None', 'Relations', 'Fields', 'Links', and 'All'.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

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
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

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

Get Work Item Column Fields using API Source

Azure DevOps

Get Work Item Column Fields

SSIS API Source - Read from table or endpoint

Get Work Item Column Fields using API Destination

Azure DevOps

Get Work Item Column Fields

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get work item column fields

SELECT * FROM get_workitem_fields
WITH
(
    "Project" = 'abcd-1234-project'
)

SQL Server

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

Get work item column fields

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_workitem_fields
WITH
(
    "Project" = ''abcd-1234-project''
)';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];