Forum Discussion

KatieJayne's avatar
KatieJayne
Occasional Visitor
7 months ago

Zephyr Test Case Results - Export to Excel/PowerBI

Hello,

I'm trying to export test case results automatically from Zephyr to Excel/Power BI. I need to export the test case key, test case name and latest result - what is the best way to do this? 

Zephyr Scale Cloud
  • ayyappadas's avatar
    ayyappadas
    New Member
    4 months ago

    Did you had any luck? using this API , i had a response back from /rest/tests/1.0/reports/testresults/export but downloading the excel report

  • MisterB's avatar
    MisterB
    Champion Level 3
    7 months ago

    I've not tried this myself but I imagine the automation would need to use Zephyr Scale's APIs to get the source data.  Perhaps Power BI already has this capability, but I don't know.  The Cloud version of the APIs can be found here: Zephyr Scale for Jira Cloud API

    Hopefully someone else on this forum can answer your question more fully.