Pipelines

Retrieves a list of pipelines

Table Specific Information

Select

The add-in uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

Id supports the '=' operator.
ProjectId supports the '=' operator.
PipelineVersion supports the '=' operator.

The rest of the filter is executed client-side in the add-in.

For example:

	SELECT * FROM Pipelines WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM Pipelines WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Id = 123

Insert

The following is an example of inserting into Pipelines table:

INSERT INTO Pipelines (ProjectId, Name, Folder, ConfigurationPath, ConfigurationRepositoryId, ConfigurationRepositoryType, ConfigurationType) values ('a0gd2e71-533c-4f96-9e5b-063740ee660b','test-pipeline','\testfolder','build-deploy.yml','cebheae8-6036-438d-bc23-d456c4a213b4', 'azureReposGit','yaml')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Int	True		Id of the pipeline.
Folder	String	False		Folder in which the pipeline is located.
Name	String	False		Pipeline name.
Revision	Int	True		Revision number.
URL	String	True		URL of the pipeline.
Links	String	True		Aggregate of the reference links.
ConfigurationPath	String	False		Path to the pipeline's configuration file. This must link to a YAML file within the repository. Only available when the Id is specified.
ConfigurationRepositoryId	String	False		The pipeline's configuration's repository's id. Only available when the Id is specified.
ConfigurationRepositoryType	String	False		The pipeline's configuration's repository's type. Only available when the Id is specified.
ConfigurationType	String	False		The pipeline's configuration type. Only available when the Id is specified.
ProjectId	String	True		Id of the project.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.