SSIS Components for Azure DevOps

Build 24.0.9063

QueryColumns

Retrieves all columns for the specific query.

Table Specific Information

Select

The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • QueryId supports the '=' operator.
  • ProjectId supports the '=' operator.

The rest of the filter is executed client-side in the 本製品.

NOTE: QueryId is required in order to query QueryColumns.

For example:

	SELECT * FROM QueryColumns WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND QueryId = '40314330-b454-41fd-9514-e6be6096bd0b'

Columns

Name Type References Description
ProjectId String Id of the project.
QueryId String

Queries.Id

Id of the query.
Name String Friendly name of the column.
ReferenceName String Reference name of the column.
Url String The Url of the query column.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063