Azure DevOps Connector
Documentation
Version: 2
Documentation

EndPoint Get Query Fileds


Name

get_query_fields

Description

Gets query fields for work items. [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
Option Value
false false
true true
Whether or not to use time precision.

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Name DT_WSTR nvarchar(4000) 4000 False
ReferenceName DT_WSTR nvarchar(4000) 4000 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:

Get Query Fileds using API Source

Azure DevOps
Get Query Fileds
SSIS API Source - Read from table or endpoint

Get Query Fileds using API Destination

Azure DevOps
Get Query Fileds
SSIS API Destination - Access table or endpoint