BuildLogs
Retrieve the logs for a build.
Table Specific Information
Select
The connector 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 connector.
- ProjectId supports the '=' operator.
- BuildId supports the '=' operator.
NOTE: BuildId is required in order to query BuildLogs.
For example:
SELECT * FROM BuildLogs WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND BuildId = 3
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The ID of the log. | |
| ProjectId | String | Id of the project. | |
| BuildId | Integer |
Builds.Id | Id of the build for which this log was created. |
| CreatedOn | Datetime | The date and time the log was created. | |
| LastChangedOn | Datetime | The date and time the log was last changed. | |
| LineCount | Integer | The number of lines in the log. | |
| Type | String | The type of the log location. | |
| Url | String | A full link to the log resource. |