WikiPages

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

Table Specific Information

Select

The driver 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 driver.

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'

Update

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'

Delete

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'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		Id of the wiki page.
ProjectId	String	True	Projects.Id	Id of the project for which this wiki was created.
WikiId	String	True	Wikis.Id	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.

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.


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. The allowed values are full, none, oneLevel, oneLevelPlusNestedEmptyFolders.
VersionOptions	String	Version options - specify additional modifiers to version. The allowed values are 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. The allowed values are branch, commit, tag.