ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves metadata or content of the wiki page for the provided path.

Table Specific Information


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

  • ProjectId supports the '=' operator.
  • WikiId supports the '=' operator.
  • Path supports the '=' operator.
  • IncludeContent supports the '=' operator.
  • RecursionLevel supports the '=' operator.
  • VersionOptions supports the '=' operator.
  • Version supports the '=' operator.
  • VersionType supports the '=' operator.

The rest of the filter is executed client-side in the 本製品.

NOTE: WikiId is required in order to query WikiPages.

For example:

	SELECT * FROM WikiPages WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND WikiId = '9d910096-122d-432e-b64a-8ef4d06d2905'
	SELECT * FROM WikiPages WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND WikiId = '9d910096-122d-432e-b64a-8ef4d06d2905' AND RecursionLevel = 'full'
	SELECT * FROM WikiPages WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND WikiId = '9d910096-122d-432e-b64a-8ef4d06d2905' AND Version = 'wikiMaster'


The following is an example of updating a WikiPages table:

UPDATE WikiPages SET Content = 'cd' WHERE Path = 'main' AND WikiId = 'e7c569e7-3ff0-432c-93f0-084c09d578b5' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'


The following is an example of deleting data in the WikiPages table:

DELETE FROM WikiPages WHERE WikiId = 'e7c569e7-3ff0-432c-93f0-084c09d578b5' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'


Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the wiki page.

ProjectId String True


Id of the project for which this wiki was created.

WikiId String True


Id of the wiki to which this page belongs to.

Content String False

Content of the wiki page.

GitItemPath String True

Path of the git item corresponding to the wiki page stored in the backing Git repository.

IsParentPage Boolean True

True if this page has subpages under its path.

Order Integer True

Order of the wiki page, relative to other pages in the same hierarchy level.

Path String True

Path of the wiki page.

RemoteUrl String True

Remote web url to the wiki page.

SubPages String True

Sub Pages of the wiki page.

Url String True

REST url for this wiki page.


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

Name Type Description
IncludeContent Boolean

True to include the content of the page in the response for JSON content type.

RecursionLevel String

Recursion level for subpages retrieval. Defaults to None.

使用できる値は次のとおりです。full, none, oneLevel, oneLevelPlusNestedEmptyFolders

VersionOptions String

Version options - specify additional modifiers to version.

使用できる値は次のとおりです。firstParent, none, previousChange

Version String

Version string identifier (name of tag/branch, SHA1 of commit).

VersionType String

Version type (branch, tag, or commit). Determines how Id is interpreted.

使用できる値は次のとおりです。branch, commit, tag

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