ADO.NET Provider for Azure DevOps

Build 24.0.9060

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.
The rest of the filter is executed client-side in the provider.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060