How to get State from test case from Azure DevOps

[DavidPlante]

Hi!

I'm looking for a solution to this: I need to query all test cases under a particular Test Plan, and fetch the State value, so I could calculate a percentage of test case "Ready" on the total of test case under that suite.

I was planning to start from entitySet Tests or TestPoints, but neither of those have the State. 

Then, I thought I could use the entitySet WorkItem, but I can't find a way to track Test Cases from a given Test Plan.

Any thought on how I could achieve this? The end goal here is to calculate a percentage of "Ready" tests from all the test cases under a particular Test Plan.

Thanks and have a nice day!

[v-shex-msft · Accepted solution]

HI @DavidPlante ,

Perhaps you can try to use odata connector to get data from azure devops with custom queries:

How can I connect PowerBi to Queries in Azure Devops? - Stack Overflow

Regards,

Xiaoxin Sheng