ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves all wikis in a project or collection.

Table Specific Information


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

For example:

	SELECT * FROM Wikis WHERE Id = '35df8f05-c66c-4a97-953d-a2a6d47a6198'
	SELECT * FROM Wikis WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'


The following is an example of inserting into Wikis table:

INSERT INTO Wikis (ProjectId, Name) VALUES ('03e4b7af-3bff-49d0', 'TestWiki')


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'


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'


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


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.

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