Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,365,160
Community Members
 
Community Events
168
Community Groups

Script for how to download eazyBi table into csv file automatically every month.

I have to automate Script for Download one table from EazyBI reports

1 answer

1 accepted

2 votes
Answer accepted

Hi, Varsha,

This is Janis from eazyBI.

eazyBI has many lesser-known features and one of those features is an API for eazyBI report result export.

  • In eazyBI for Jira Server:

JIRA_BASE_URL/plugins/servlet/eazybi/
accounts/account_id/export/report/report_id.format

  • In eazyBI for Jira Cloud:

https://aod.eazybi.com/accounts/account_id/export/report/report_id.format

 

format – csvxlsjsonpdfpng

 

The API also support additional parameters to filter results before exporting (More details in the documentation). And in the documentation page you'll also find a sample node.js script for exporting results.

eazyBI Documentation: Report results export API

If you need any help with this, you can reach out to eazyBI Community at community.eazybi.com or contact eazyBI support at support@eazybi.com 

Hello. Do you have a Excel file example how to download data from eazybi?

Hi @Renato Rodrigues ,
The report excel file is generated dynamically when you perform report download manually or initiated by the script.
You can try downloading manually any demo report: https://eazybi.com/accounts/1000/dashboards/14871-chart-types

Hi, 2 issues :
a) that link above "eazyBI Documentation: Report results export API" doesn't work.
b) Are there any reports which give 'sprint creeps"? i.e. issues moved in or out of sprints?

Hi @Nikhil Mahajan ,

 

You are right. The previously shared link is dead. Try this one - https://docs.eazybi.com/eazybi/set-up-and-administer/customization/report-results-export-api.

 

Visit the Sprint overview dashboard on our Demo account for some Sprint report examples - https://eazybi.com/accounts/1000/dashboards/5956-sprints-overview.

 

You can export the definitions of reports you are interested or even the whole dashboard and import them into your eazyBI - https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/export-and-import-report-definitions.

 

Best,

Roberts // support@eazybi.com

Suggest an answer

Log in or Sign up to answer