SSIS Components for Azure DevOps

Build 24.0.9060

WikiVersions

Retrieves all wiki versions for the specific wiki.

Table Specific Information

Select

The component uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • WikiId supports the '=' operator.
  • ProjectId supports the '=' operator.

The rest of the filter is executed client-side in the component.

NOTE: WikiId is required in order to query WikiVersions.

For example:

	SELECT * FROM WikiVersions WHERE WikiId = '9d910096-122d-432e-b64a-8ef4d06d2905'
	SELECT * FROM WikiVersions WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND WikiId = '9d910096-122d-432e-b64a-8ef4d06d2905'

Columns

Name Type References Description
WikiId String

Wikis.Id

Id of the wiki.
ProjectId String Id of the project.
Version String Version string identifier (name of tag/branch, SHA1 of commit).
VersionOptions String Version options - Specify additional modifiers to version (e.g Previous).
VersionType String Version type (branch, tag, or commit). Determines how Id is interpreted.

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