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 |
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:
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
