Reference

Endpoint Delete Work Item Comment

Name

delete_workitem_comment

Description

Delete work item comment for a specific Work Item Id and Comment Id [API reference]

Related Tables

WorkItemComments

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
Status DT_WSTR nvarchar(4000) 4000
StatusCode DT_I4 int
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
WorkItemId DT_I4 int
Id DT_I4 int
Required columns that you need to supply are bolded.

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
Delete Work Item Comment
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
RawOutputDataRowTemplate {}
EnableRawOutputModeSingleRow True
ContineOnErrorForStatusCode True
ErrorStatusCodeToMatchRegex 404|405
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the WorkItemComments table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to delete work item comment:

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
WorkItemComments
Delete
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
RawOutputDataRowTemplate {}
EnableRawOutputModeSingleRow True
ContineOnErrorForStatusCode True
ErrorStatusCodeToMatchRegex 404|405
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Delete a specific work item by its Id 

DELETE FROM WorkItemComments WHERE WorkItemId=6455 and Id=5284411

delete_workitem_comment endpoint belongs to WorkItemComments 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:

Delete a specific work item by its Id 

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM WorkItemComments WHERE WorkItemId=6455 and Id=5284411';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];

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