Pipelines
Retrieves a list of pipelines
Table Specific Information
Select
The provider 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.
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.
Name | Type | Description |
PipelineVersion | Int |
The pipeline version, tied to the revision number. Only available when the Id is specified. |