Retrieves a list of upstream sources for the specific feed.

Table Specific Information

Select

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

• FeedId supports the '=' operator.
• ProjectId supports the '=' operator.
• IncludeDeletedUpstreams supports the '=' operator.

The rest of the filter is executed client-side in the connector.

NOTE: FeedId is required in order to query FeedUpstreamSources.

For example:

	SELECT * FROM FeedUpstreamSources WHERE FeedId = 'e14f9853-4830-4f04-9561-c551254a32c9'
	SELECT * FROM FeedUpstreamSources WHERE FeedId = 'e14f9853-4830-4f04-9561-c551254a32c9' AND IncludeDeletedUpstreams = true

Columns

Name	Type	References	Description
Id [KEY]	String		Id of the feed upstream source.
FeedId	String	Feeds.Id	Id of the feed.
ProjectId	String		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.
Name	String		Display name.
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-Columns

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

Name	Type	Description
IncludeDeletedUpstreams	Boolean		Include upstreams that have been deleted in the response.