Sample - Execution Report(CSV) Based on ZQL Search

October 30, 2014

Code generates a CSV report based on a given ZQL query string. It then grabs execution information based on ZQL query and writes them to the file which can be used/viewed in spreadsheet software. Finally, basic cell formulas are used to total executions found.

See attached for downloadable copy

ZAPI documentation:

Sourced software:

- Python (Sample created in v2.7.5)

- Requests 2.3.0 (Latest version here:


Title:  Sample - Execution Report Based on ZQL Search

Product:  ZAPI

Version:  Zephyr for JIRA 2.1+, ZAPI 1.0+

Summary:  Create execution report in CSV format based on a ZQL search query