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. |
| Projects | Get all projects in the organization that the authenticated user has access to and details of the specific project. |
| Users | Retrieves a list of users. This table will not retrieve results for the On-premise edition. |