TDV Adapter for Azure DevOps

Build 23.0.8839

Boards

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

Table Specific Information

Select

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

  • 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

Projects.Id

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.
LinksChartsHref String Charts Reference Links. this field will be populated with a value only when the Id is specified.
LinksColumnsHref String Columns reference links. This field will be populated with a value only when the Id is specified.
LinksProjectHref String Project reference links. This field will be populated with a value only when the Id is specified.
LinksRowsHref String Rows reference links. This field will be populated with a value only when the Id is specified.
LinksSelfHref String Rows reference links. This field will be populated with a value only when the Id is specified.
LinksTeamHref String Team reference links. This field will be populated with a value only when the Id is specified.
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 23.0.8839