WIQL to OData Azure DevOps Extension

Wiql to OData translates an Azure DevOps query into an OData query for use with Azure DevOps Analytics OData endpoints.

Features

• Convert 'flat list of work items' and 'work items and direct links' ADO queries to OData queries with the click of a button. These queries are url formatted and ready to be used in your apps with any http client.

Restrictions

• You must have Azure DevOps Analytics installed to your account.
• As with the Azure DevOps Analytics extension, this extension is currently in preview. It will not support some scenarios that OData or ADO Analytics currently doesn't support. For example...
  • Recursive (tree) Wiql queries are not supported.
  • Macros (such as @project, @me), are not supported. When possible, these values will be replaced with static values. @today is supported, but mathematical operations on @today such as @today - 1 are not supported, and will be replaced with a static value.
• The output query is a best guess, and may require some adjustment to perform exactly as required. Please heed the warnings listed below the query text.

Building the project

Just run:

npm run build:dev
npm run package:dev

This produces a .vsix file which can be uploaded to the Visual Studio Marketplace

You can also publish it to your own publisher by running:

npm run publish:dev

Reporting Security Issues

Security issues and bugs should be reported privately, via email, to the Microsoft Security Response Center (MSRC) at [email protected]. You should receive a response within 24 hours. If for some reason you do not, please follow up via email to ensure we received your original message. Further information, including the MSRC PGP key, can be found in the Security TechCenter.

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.microsoft.com.

When you submit a pull request, a CLA-bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., label, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.