Tables
The add-in models the data in Azure DevOps as a list of tables in a relational database that can be queried using standard SQL statements.
CData Excel Add-In for Azure DevOps Tables
| Name | Description |
| AgentPools | Retrieves a list of agent pools. |
| BuildDefinitions | Retrieves a list of build definitions, sliced across all projects. |
| GroupMembers | Get direct members of a group. |
| Pipelines | Retrieves a list of pipelines |
| Projects | Get all projects in the organization that the authenticated user has access to and details of the specific project. |
| Repositories | Git repositories, sliced across all projects. |
| TestPlans | Get a list of test plans and details of specific test plan. |
| Users | Retrieves a list of users. This table will not retrieve results for the On-premise edition. |
| WorkItems | Retrieves a list of work items. This table includes custom fields which are automatically discovered when 'IncludeCustomFields' is enabled. |