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

Search for Work Items by Text using API Destination
Azure DevOps
Search for Work Items by Text

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];