Reference

Endpoint Get Work Item Comment by Comment Id and Work Item Id


Name

get_workitem_comment

Description

Get work item comment by its Comment Id (for specific WorkItem Id) [API reference]

Parameters

Parameter Required Options
Name: Id

Label: Id

Comment Id
YES
Name: WorkItemId

Label: WorkItemId

WorkItem Id for which you like to get comments
YES
Name: Project

Label: Project Name

The Name of the project.
YES
Name: api-version

Label: api-version

For this API you must set 7.0-preview for now

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_I4 int
WorkItemId DT_I4 int
Text DT_NTEXT nvarchar(MAX)
RenderedText DT_NTEXT nvarchar(MAX)
Format DT_WSTR nvarchar(4000) 4000
CreatedDate DT_DBTIMESTAMP datetime
CreatedByUniqueName DT_WSTR nvarchar(4000) 4000
CreatedById DT_WSTR nvarchar(4000) 4000
CreatedByDisplayName DT_WSTR nvarchar(4000) 4000
ModifiedDate DT_DBTIMESTAMP datetime
ModifiedByUniqueName DT_WSTR nvarchar(4000) 4000
ModifiedById DT_WSTR nvarchar(4000) 4000
ModifiedByDisplayName DT_WSTR nvarchar(4000) 4000
Url DT_WSTR nvarchar(1000) 1000
If the column you are looking for is missing, consider customizing Azure DevOps Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length 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 or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Azure DevOps
Azure DevOps Connector can be used to integrate Azure DevOps data in your App / BI Tools. You can create, read, query, modify, and delete WorkItems, Projects, Teams and more.
Azure DevOps
Get Work Item Comment by Comment Id and Work Item Id
Required Parameters
Id Fill-in the parameter...
WorkItemId Fill-in the parameter...
Project Name Fill-in the parameter...
Optional Parameters
api-version 7.0-preview
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Azure DevOps
Azure DevOps Connector can be used to integrate Azure DevOps data in your App / BI Tools. You can create, read, query, modify, and delete WorkItems, Projects, Teams and more.
Azure DevOps
Get Work Item Comment by Comment Id and Work Item Id
Required Parameters
Id Fill-in the parameter...
WorkItemId Fill-in the parameter...
Project Name Fill-in the parameter...
Optional Parameters
api-version 7.0-preview
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get work item comment by comment id and work item id

SELECT * FROM get_workitem_comment
WHERE Id = 'abcd-1234-id'
AND WorkItemId = 'abcd-1234-workitemid'
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 comment by comment id and work item id

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_workitem_comment
WHERE Id = ''abcd-1234-id''
AND WorkItemId = ''abcd-1234-workitemid''
WITH
(
    "Project" = ''abcd-1234-project''
)';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];