CData Python Connector for Azure DevOps

Build 24.0.9060

Boards

Retrieve boards for the specific project and details of the specified board.

Table Specific Information

Select

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

The rest of the filter is executed client-side in the connector.

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • TeamId supports the '=' operator.
For example:
	
	SELECT * FROM Boards WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM Boards WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Id = 'a1c17364-7447-47e6-9862-b10b78c3f09b'
	SELECT * FROM Boards WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40'
	SELECT * FROM Boards WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40' AND Id = 'a1c17364-7447-47e6-9862-b10b78c3f09b'

Columns

Name Type References Description
Id [KEY] String Id of the board
ProjectId String Id of the Project in which this board was created
TeamId String

Teams.Id

Id of the Team to which this board belongs to
AllowedMappings String Allowed mappings. This field will be populated with a value only when the Id is specified.
CanEdit Boolean Indicates if the board can be edited. This field will be populated with a value only when the Id is specified.
FieldsColumnFieldReferenceName String Reference name for the column field. this field will be populated with a value only when the Id is specified.
FieldsColumnFieldUrl String Full Http link for the column field. this field will be populated with a value only when the Id is specified.
FieldsDoneFieldReferenceName String Reference name for the done field. this field will be populated with a value only when the Id is specified.
FieldsDoneFieldUrl String Full Http link for the done field. this field will be populated with a value only when the Id is specified.
FieldsRowFieldReferenceName String Reference name for the row field. this field will be populated with a value only when the Id is specified.
FieldsRowFieldUrl String Full Http link for the row field. this field will be populated with a value only when the Id is specified.
IsValid Boolean Indicates whether this board is valid or not. This field will be populated with a value only when the Id is specified.
Links String Aggregate of the reference links.
Name String The name of the board
Revision Integer The revision of the board. This field will be populated with a value only when the Id is specified.
Url String The full http link to the board

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