Skip to content
| Marketplace
Sign in
Azure DevOps>Azure Pipelines>QueryMailer

QueryMailer

Henning Meyer

|
2 installs
| (0) | Free
A task for sending the results of a WIQL query via mail.

QueryMailer

QueryMailer is an Azure DevOps Extension that provides a task for sending WIQL query results via mail. The task encapsulates the Work Item Tracking / Send Mail functionality of the Azure DevOps Services REST API.

Agent Specification

✅ windows-latest
✅ macos-latest
✅ ubuntu-latest

Usage

steps:
- task: QueryMailer@0
  displayName: Send Query via Mail
  inputs:
    accessToken: $(creds.token)
    organization: 'FooOrganization'
    project: 'AmazingWebApp'
    subject: 'Work Item Selection'
    message: |
        Please take a look at the following work items.
    receivers: |
        90a41e6b-bab0-46ae-b1bb-0c2eb90432bc
        564555f3-f800-4c5b-b200-3f45670acfa5
        cd603395-24f7-41aa-b074-a1263df1bb4a
    wiql: 'select [System.Id] from Workitems'
Parameter Aliases Required Description
accessToken token true The Access Token used for API authorization
Required scopes: vso.work
organization org true The name of the Azure DevOps organization
project proj true The name of the Azure DevOps project
subject true The subject of the mail
message msg false The message included in the mail
receivers to false The tfIds of the users the mail get send to
Required if there is no value for cc provided
cc false The tfIds of the users the mail copy get send to
Required if there is no value for receivers provided
wiql true The WIQL query to process

Mail

Take a look at the screenshot to see how the mail is formatted.
The table contents are defined by the WIQL query.

Notes

  • The REST API functionality is currently limited to work with tfIds
  • The mail is send by Azure DevOps Services
  • The mail address of the token owner gets displayed in the mail
  • Receivers need to have permissions to read the included work items

Main Dependencies

  • Azure DevOps Client for Node.js
  • Azure DevOps Extension SDK
  • Azure Pipelines Task Lib

Credits

  • Icon by Deans_Icons
  • Contact us
  • Jobs
  • Privacy
  • Terms of use
  • Trademarks
© 2023 Microsoft