The Visual Studio Team Services (VSTS) Analytics OData feed has been promoted to full public preview, available to everyone. Developers can use OData to access VSTS Analytics to write 3rd party or custom widgets. Or, write any tool or extension that takes advantage of the VSTS Analytics data model.
This OData feed is built on VSTS Analytics, our new reporting platform. For more information, check out our Channel 9 video:Â Visual Studio Team Services Reporting: Dashboards, Power BI, and OData. The video describes an overview of what is available today, and a roadmap of what’s coming.
The OData endpoint is available after you have installed the VSTS Analytics extension.
With the public preview version, we have versioned the OData endpoint to V1.0.
The version provided in private preview was available at: https://ACCOUNT.analytics.visualstudio.com/PROJECT/_odata/WorkItems
The version released with public preview is V1.0, and is available at: https://ACCOUNT.analytics.visualstudio.com/PROJECT/_odata/V1.0/WorkItems
As per our API Versioning policy, the private preview version will continue to be supported for 1 year. However, if you have code written against the private preview endpoint, we strongly encourage you to update your code to use the V1.0 endpoint. This will set you up for future updates.
We have also published documentation to get you started:
- What is Analytics – An overview of what VSTS Analytics is, and our vision for it
- Extend Analytics with OData – Overview to help you get started with OData
- OData Query guidelines – Do’s and Don’ts of writing OData queries against VSTS Analytics
- Create an Analytics Widget – Code sample to get you started creating your own Analytics Widget
Now that OData is publicly available, our next step is to provide a solid solution to connect Power BI to VSTS. That will be coming in January, 2018.
Enjoy!
Hi, I am trying to connect to DevOps Analytics ODATA and retrieve some of the ODATA tables from within Azure Data Factory. Some tables I am able to retrieve data for successfully but some tables even though i can preview the data in the pipeline, when i run the pipeline, I get the following weird error:
Activity Copy_aq1 failed: Failure happened on ‘Source’ side. ‘Type=System.Collections.Generic.KeyNotFoundException,Message=The given key was not present in the dictionary.,Source=mscorlib,’
I am at lost as to what this error is about how to resolve this error, it looks like there is something wrong with the Odata source itself? Any help or pointer to who i can contact on the DevOps Analytics ODATA team would be appreciated. Thanks!