Reference

Endpoint Delete Work Item

Name

delete_workitem

Description

Deletes an existing work item in the default project within the organization. [API reference]

Related Tables

WorkItems

Parameters

Parameter	Required	Options
Name: Project Label: Project Name The Name of the project.	YES
Name: Id Label: Work Item Id

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length
Id	`DT_I4`	`int`
project	`DT_WSTR`	`nvarchar(4000)`	4000
Title	`DT_WSTR`	`nvarchar(4000)`	4000
WorkItemType	`DT_WSTR`	`nvarchar(4000)`	4000
DeletedBy	`DT_WSTR`	`nvarchar(4000)`	4000
DeletedDate	`DT_WSTR`	`nvarchar(4000)`	4000

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
Id	`DT_WSTR`	`nvarchar(4000)`	4000

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

Required Parameters
Project Name	Fill-in the parameter...
Optional Parameters
Work Item Id
Continue processing on 404 error	True

SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the WorkItems 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:

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

WorkItems

Delete

Required Parameters
Project Name	Fill-in the parameter...
Optional Parameters
Work Item Id
Continue processing on 404 error	True

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 WorkItems WHERE Id = 7455

Delete work items match with Wiql Query

DELETE FROM WorkItems
Where 1=1 
WITH(Query='SELECT * FROM WorkItems Where [System.TeamProject]=''MyProject'' AND ([System.Id]=6469 OR [System.Id]=6468) ')

delete_workitem endpoint belongs to WorkItems 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 WorkItems WHERE Id = 7455';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];

Delete work items match with Wiql Query

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM WorkItems
Where 1=1 
WITH(Query=''SELECT * FROM WorkItems Where [System.TeamProject]=''''MyProject'''' AND ([System.Id]=6469 OR [System.Id]=6468) '')';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];

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