Wikis
Retrieves all wikis in a project or collection.
Table Specific Information
Select
The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=' operator.
- ProjectId supports the '=' operator.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM Wikis WHERE Id = '35df8f05-c66c-4a97-953d-a2a6d47a6198' SELECT * FROM Wikis WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
Insert
The following is an example of inserting into Wikis table:
INSERT INTO Wikis (ProjectId, Name) VALUES ('03e4b7af-3bff-49d0', 'TestWiki')
Update
The following is an example of updating a Wikis table:
UPDATE Wikis SET Name = 'cd' WHERE Id = 'e7c569e7-3ff0-432c-93f0-084c09d578b5' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'
Delete
The following is an example of deleting data in a Wikis table:
DELETE FROM Wikis WHERE Id = 'e7c569e7-3ff0-432c-93f0-084c09d578b5' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Unique ID of the wiki. | |
MappedPath | String | False |
Folder path inside repository which is shown as wiki. | |
Name | String | False |
The name of the wiki. | |
ProjectId | String | False |
ID of the project in which the wiki is to be created. | |
Properties | String | True |
Properties of the wiki. | |
RemoteUrl | String | True |
Remote web url to the wiki. | |
RepositoryId | String | False |
Repositories.Id |
ID of the git repository that backs up the wiki. Not required for ProjectWiki type. |
Type | String | False |
Type of the wiki. | |
Url | String | True |
REST url for this wiki. |