SSIS Components for Azure DevOps

Build 24.0.9063

Feeds

Retrieves all feeds in an account.

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.
  • Id supports the '=' operator.
  • Role supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.

For example:

	SELECT * FROM Feeds WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'

Insert

The following is an example of inserting into an Earnings table:

INSERT INTO Feeds (Id, BadgesEnabled, ProjectId, IsReadOnly, Name, Description) VALUES ('2c7f4f88-e64c-412e-b514-8c6b0dde5ecc', false, 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', false, 'hellqw', 'demo dashboards')

Update

The following is an example of updating a Feeds table:

UPDATE Feeds SET Name = 'abc' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND ID = '2dfe0d39-1ee0-4501-9924-2e6b186a7435'

Delete

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

DELETE FROM Feeds WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND ID = '2dfe0d39-1ee0-4501-9924-2e6b186a7435'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique Id of the feed.

BadgesEnabled Boolean False

If set, this feed supports generation of package badges.

Links String True

Aggregate of the reference links.

Capabilities String False

Supported capabilities of a feed.

DefaultViewId String False

The view that the feed administrator has indicated is the default experience for readers.

DeletedDate Datetime False

The date that this feed was deleted.

Description String False

A description for the feed. Descriptions must not exceed 255 characters.

FullyQualifiedId String False

This will either be the feed GUID or the feed GUID and view GUID depending on how the feed was accessed.

FullyQualifiedName String False

Full name of the view, in feed@view format.

HideDeletedPackageVersions Boolean False

If set, the feed will hide all deleted/unpublished versions.

IsReadOnly Boolean False

If set, all packages in the feed are immutable.

Name String False

A name for the feed.

ProjectId String True

Id of the project.

ProjectName String False

Name of the project.

UpstreamEnabled Boolean False

This should always be true. Setting to false will override all sources in UpstreamSources.

UpstreamEnabledChangedDate String False

If set, time that the UpstreamEnabled property was changed. Will be null if UpstreamEnabled was never changed after Feed creation.

Url String False

The URL of the base feed in GUID form.

ViewId String False

View Id.

ViewName String False

View name.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。

Name Type Description
Role String

Filter by this role.

使用できる値は次のとおりです。administrator, collaborator, contributor, custom, none, reader

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