CData Python Connector for Azure DevOps

Build 24.0.9060

QueryColumns

Retrieves all columns for the specific query.

Table Specific Information

Select

The connector 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 connector.

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.9060