Feeds
Retrieves all feeds in an account.
Table Specific Information
Select
The provider 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.
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
Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
Name | Type | Description |
Role | String |
Filter by this role. The allowed values are administrator, collaborator, contributor, custom, none, reader. |