Retrieves all feeds in an account.

Table Specific Information

Select

The connector 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 connector.

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