Excel Integration with Zephyr Test Execution Results

[ajayakannan]

My clients love to get their report in excel and very importantly they want it to get the live data dynamically. Is there any way for integrating Excel with Zephyr Test Execution Results , so that by just doing a refresh in Excel , it should import the test execution results dynamically ? I find it very difficult to download the execution results from Zephyr into excel and send it to clients.

[sanjeevpande · Accepted solution]

Excel does support integration with rest apis. You can use Zephyr Rest API to use the following to get the Executions.

https://zfjcloud.docs.apiary.io/#reference/zql/get-execution-navigation-result/get-execution-navigat...

Zephyr Rest API:

https://zephyrdocs.atlassian.net/wiki/spaces/ZFJCLOUD/pages/1925120024/REST+API