WikiPages
Retrieves metadata or content of the wiki page for the provided path.
Table Specific Information
Select
The connector 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 connector.
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'
Insert
The following
is an example of inserting
a WikiPages table:
INSERT INTO WikiPages(WikiId, Content, ProjectId, Path) VALUES ('e7c569e7-3ff0-432c-93f0-084c09d578b5', 'Content for testing', 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'main')
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 | Integer | True |
Permanent Id of the wiki page. | |
| ProjectId | String | True |
Id of the project for which this wiki was created. | |
| WikiId [KEY] | 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 [KEY] | String | False |
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
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 |