Excel Add-In for Azure DevOps

Build 24.0.9060

ReleaseDefinitionArtifacts

Retrieves a list of release definition artifacts.

Table Specific Information

Select

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

  • ProjectId supports the '=' operator.
  • DefinitionId supports the '=,in' operators.

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

NOTE: DefinitionId is required in order to query ReleaseDefinitionArtifacts.

For example:

	SELECT * FROM ReleaseDefinitionArtifacts WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND DefinitionId IN (1, 2, 3)	

Columns

Name Type ReadOnly References Description
DefinitionId [KEY] Integer True

ReleaseDefinitions.Id

Id of the release.

ProjectId String True

Id of the project.

Alias String False

Artifact alias.

DefinitionReference String False

Definition reference of the artifact.

IsPrimary Boolean False

Indicates whether artifact is primary or not.

IsRetained Boolean False

Indicates whether artifact is retained by release or not.

SourceId String True

Id of the source.

Type String False

Type of the artifact.

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