Retrieves a list of upstream sources for the specific feed.
Table Specific Information
The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.
Note: FeedId is required in order to query FeedUpstreamSources.
- FeedId supports the '=' operator.
- ProjectId supports the '=' operator.
- IncludeDeletedUpstreams supports the '=' operator.
SELECT * FROM FeedUpstreamSources WHERE FeedId = 'e14f9853-4830-4f04-9561-c551254a32c9' SELECT * FROM FeedUpstreamSources WHERE FeedId = 'e14f9853-4830-4f04-9561-c551254a32c9' AND IncludeDeletedUpstreams = true
|Id [KEY]||String||Id of the feed upstream source.|
|Id of the feed.|
|Id of the project.|
|DeletedDate||Datetime||UTC date that this upstream was deleted.|
|DisplayLocation||String||Locator for connecting to the upstream source in a user friendly format, that may potentially change over time.|
|Location||String||Consistent locator for connecting to the upstream source.|
|Protocol||String||Package type associated with the upstream source.|
|Status||String||Status of the Upstream source.|
|UpstreamSourceType||String||Source type, such as Public or Internal.|
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.
|IncludeDeletedUpstreams||Boolean||Include upstreams that have been deleted in the response.|