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: To improve performance, a single BuildId should be specified in the WHERE clause of the query.

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 [KEY]	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.