SSIS Components for Azure DevOps

Build 24.0.9063

ReleaseArtifacts

Retrieves a list of release artifacts.

Table Specific Information

Select

The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

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

The rest of the filter is executed client-side in the 本製品.

NOTE: ReleaseId is required in order to query ReleaseArtifacts.

For example:

	SELECT * FROM ReleaseArtifacts WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND ReleaseId = 2

Columns

Name Type References Description
ReleaseId [KEY] Integer

Releases.Id

Id of the release.
ProjectId String Id of the project.
Alias String Artifact alias.
DefinitionReference String Definition reference of the artifact.
IsPrimary Boolean Indicates whether artifact is primary or not.
IsRetained Boolean Indicates whether artifact is retained by release or not.
SourceId String Id of the source.
Type String Type of the artifact.
BuildVersionId String Sets the build id.
BuildVersionCommitMessage String commit message for the artifact.
BuildVersionName String Sets the build number.

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