SSIS Components for Azure DevOps

Build 24.0.9063

BuildDefinitionDrafts

Retrieves a list of drafts associated with the specific definition.

Table Specific Information

Select

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

  • DefinitionId supports the '=' operator.
  • ProjectId supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.


NOTE: DefinitionId is required in order to query BuildDefinitionDrafts.

For example:

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

Insert

The following is an example of inserting into a BuildDefinitionDrafts table. For example:

INSERT INTO BuildDefinitionDrafts (projectId, Name, RepositoryId, RepositoryType, ProcessYamlFilename) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', cdata11211, 'e50698d4-bb6e-400f-a1a0-5f4d17517d9e', TfsGit, 'data.txt')

Update

The following is an example of updating a BuildDefinitionDrafts table:

UPDATE BuildDefinitionDrafts SET Name = 'Shubham2', revision = 1, RepositoryId = 'e50698d4-bb6e-400f-a1a0-5f4d17517d9e', ProcessYamlFilename = 'data.txt', RepositoryType = 'TfsGit' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND DefinitionId = '1'

Delete

The following is an example of deleting data in a BuildDefinitionDrafts table:

DELETE FROM BuildDefinitionDrafts WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Definitionid = '1'

Columns

Name Type ReadOnly References Description
ProjectId String True

Id of the project.

DefinitionId Integer False

BuildDefinitions.Id

Id of the build definition.

CreatedDate Integer False

The date this version of the definition was created.

Id [KEY] Integer True

The Id of the referenced definition.

Name String False

The name of the referenced definition.

Path String False

The folder path of the definition.

QueueStatus String False

A value that indicates whether builds can be queued against this definition.

Revision Integer False

The definition revision number.

Type String False

The type of the definition.

Uri String False

The definition's URI.

Url String False

The REST URL of the definition.

RepositoryId String False

Repositories.Id

The ID of the repository.

RepositoryType String False

The type of the repository.

ProcessType Integer False

The process type.

ProcessYamlFilename String False

The process YAML file name.

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