Power BI Connector for Azure DevOps

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060