View as Markdown
Azure DevOps icon

Azure DevOps ACTION

Query Work Items (WIQL)

Run a Work Item Query Language (WIQL) query and return the matching work item references. Returns ids and the queried columns, not full field values - pass the ids to the List Work Items action to read those. Use this whenever you need to find work by state, type, assignee or date. Example: SELECT [System.Id] FROM WorkItems WHERE [System.WorkItemType] = 'Bug' AND [System.State] <> 'Closed'. WIQL has no offset, so narrow the query itself rather than paging when Limit results come back. See the documentation
  • Action
  • Read only
  • OAuth
  • SDK
  • MCP

IMPLEMENTATION

Call this tool

Connect a user's Azure DevOps account once, then configure and run Query Work Items (WIQL) from your backend or agent.

import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "azure_devops-query-work-items",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    azure_devops: { authProvisionId: "apn_xxxxxxx" },
    organization: "Organization",
    project: "Project",
  },
})

console.log(result)

SCHEMA

Inputs

Pipedream supplies the connected account. Your application provides the operation-specific values below. Dynamic inputs are resolved against that user's account.

Query Work Items (WIQL) inputs
Property Type Description
organization Organization string
Name of the organization
Required Dynamic
project Project string
Project ID or project name to scope the query to. Run the List Projects action first to obtain valid values. Omit to query across the whole organization.
Optional
query Query string
The WIQL query text. Example: SELECT [System.Id], [System.Title], [System.State] FROM WorkItems WHERE [System.WorkItemType] = 'Bug' AND [System.State] <> 'Closed' ORDER BY [System.CreatedDate] DESC
Required
limit Limit integer
Maximum number of work item references to return (1-1000)
Optional
timePrecision Time Precision boolean
Interpret date values in the query with time precision rather than date-only precision.
Optional

REFERENCE

Tool details

Behavior hints are published with the component in the Pipedream registry and surface as MCP tool annotations, so an agent can reason about a tool before it calls it.

Registry key
azure_devops-query-work-items
Version
0.0.2
App
Azure DevOps
Authentication
OAuth
Read-only
Yes
Destructive
No
Open world
Yes