Azure DevOps Connector
Documentation
Version: 2
Documentation

EndPoint Search for Work Items by Text


Name

search_workitems_by_text

Description

Search for specific text within work items in the default project of the organization. [API reference]

Parameters

Parameter Label Required Options Description
SearchText Text to Search For YES

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(50) 50 False
Title DT_WSTR nvarchar(4000) 4000 False
WorkItemType DT_WSTR nvarchar(50) 50 False
AssignedTo DT_WSTR nvarchar(500) 500 False
State DT_WSTR nvarchar(100) 100 False
Tags DT_WSTR nvarchar(500) 500 False
Revision DT_WSTR nvarchar(50) 50 False
CreatedDate DT_DBTIMESTAMP datetime False
ChangedDate DT_DBTIMESTAMP datetime False
ProjectId DT_WSTR nvarchar(500) 500 False
ProjectName DT_WSTR nvarchar(500) 500 False
Hits 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:

Search for Work Items by Text using API Source

Azure DevOps
Search for Work Items by Text
SSIS API Source - Read from table or endpoint

Search for Work Items by Text using API Destination

Azure DevOps
Search for Work Items by Text
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Search for work items by text contained within the work item.

SELECT * FROM search_workitems_by_text WITH (SearchText='Text that I want to search for')

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Search for work items by text contained within the work item.

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM search_workitems_by_text WITH (SearchText=''Text that I want to search for'')';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];