ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves a list of upstream sources for the specific feed.

Table Specific Information


The 本製品 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 本製品.

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


Name Type References Description
Id [KEY] String Id of the feed upstream source.
FeedId String


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.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479