Pipelines

Retrieves a list of pipelines

Table Specific Information

Select

The connector 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 connector.

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。