Skip to content

Run JQL queries via API and send a spreadsheet summary via email

License

Notifications You must be signed in to change notification settings

aplater/jira-report-gen

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Jira Excel Report Generator

Python script to search Jira tickets using JQL. Returned tickets will match the search string and customer organization provided as command arguments. A generated XLSX of the records will be emailed using the SMTP values provided by runtime arguments.

As currently defined in main.py, results will be from the EXAMPLE project and only include tickets created in the last 7 days.

Getting Started

  • Add Jira Cloud API key information and API url
  • Update JQL Query

Prerequisites

  • Python 3.X+
  • SMTP server with anonymous relay enabled
  • Jira Cloud instance
    • API key

Deployment

main.py customer_jira_org_name search_string smtp_server_address smtp_port recipient email sender

Authors

License

This project is licensed under the MIT License - see the LICENSE.md file for details

References

About

Run JQL queries via API and send a spreadsheet summary via email

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages