EndPoint Query Work Item Comments
Name
query_workitem_comments
Description
Get work item comments associated with the specified project and organization that are filtered by a Wiql query. (A team can optionally be specified as well.). Read more about this API here https://learn.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/query-by-wiql?view=azure-devops-rest-7.0 and here https://learn.microsoft.com/en-us/azure/devops/boards/queries/query-operators-variables?view=azure-devops [API reference]
Parameters
Parameter | Label | Required | Options | Description | ||||||
---|---|---|---|---|---|---|---|---|---|---|
Project | Project Name | YES | The Name of the project. | |||||||
Query | Wiql Query | YES | The WIQL query (refer Azure DevOps Help to learn Wiql syntax. [API reference] | |||||||
Team | Team Id or Name | NO | Id or name of the team associated with the query. | |||||||
TimePrecision | Use time precision | NO |
|
Whether or not to use time precision. |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Id |
DT_I4
|
int
|
False |
||
WorkItemId |
DT_I4
|
int
|
False |
||
Text |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
RenderedText |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
Format |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
CreatedDate |
DT_DBTIMESTAMP
|
datetime
|
False |
||
CreatedByUniqueName |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
CreatedById |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
CreatedByDisplayName |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
ModifiedDate |
DT_DBTIMESTAMP
|
datetime
|
False |
||
ModifiedByUniqueName |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
ModifiedById |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
ModifiedByDisplayName |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
Url |
DT_WSTR
|
nvarchar(1000)
|
1000 | False |
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:
Query Work Item Comments using API Source
Azure DevOps
Query Work Item Comments

Query Work Item Comments using API Destination
Azure DevOps
Query Work Item Comments
