Excel Add-In for Azure DevOps

Build 24.0.9060

Tasks

Retrieves tasks in a task group.

Table Specific Information

Select

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

  • TaskGroupId supports the '=' operator.
  • ProjectId supports the '=' operator.
The rest of the filter is executed client-side in the add-in.


NOTE: TaskGroupId is required in order to query TaskGroupSourceDefinitions.

For example:

	SELECT * FROM Tasks WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND TaskGroupId = 7

Columns

Name Type References Description
ProjectId String Id of the project.
TaskGroupId [KEY] String

TaskGroups.Id

Id of the task group.
AlwaysRun Boolean Indicates whether to run the task always.
Condition String Condition for the task.
ContinueOnError Boolean Indicates whether to continue on error or not.
DisplayName String The display name of the task.
Enabled Boolean Indicates whether task is enabled or not.
Environment String Dictionary of environment variables.
Inputs String Dictionary of inputs.
TaskDefinitionType String The definition type.
TaskId String The unique identifier of task.
TaskVersionSpec String The version specification of the task.
TimeoutInMinutes Integer The maximum time in minutes, that a task is allowed to execute on agent before being cancelled by server.

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