Overview

This section shows the available API objects and provides more information on executing SQL to Azure DevOps APIs.

Key Features

• The driver models Azure DevOps entities like documents, folders, and groups as relational views, allowing you to write SQL to query Azure DevOps data.
• Stored procedures allow you to execute operations to Azure DevOps
• Live connectivity to these objects means any changes to your Azure DevOps account are immediately reflected when using the driver.
• ProjectId connection property allows you to get the data from the specific project. ProjectId specified in query will be given priority over the one specified in the connection string. If not specified in both query and connection string, then the first project from the source will be used.

Tables

Tables describes the available tables. The provider models the data in Azure DevOps into a list of tables that can be queried using standard SQL statements.

Views

Views describes the available views. Views are statically defined to model Projects, Tasks, Teams, etc. Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

Stored Procedures

Stored Procedures are function-like interfaces to Azure DevOps. Stored procedures allow you to execute operations to Azure DevOps, including downloading documents and moving envelopes.