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