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

[Varsha Gupta]

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

[Janis Gulbis · Accepted solution]

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 – csv, xls, json, pdf, png

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 

[Renato Rodrigues]

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

[Gerda Grantiņa]

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

[Nikhil Mahajan]

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?

[Roberts Čāčus]

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

[Marius GNAMIEN]

Hello @Roberts Čāčus,

I'm currently evaluating eazyBI for Jira. I tried to use the API and I got the following message : 

You need to log in or sign up before continuing.

I don't understand cause I'm using the same browser on which one I'm alread connected to Jira.

Thank you in advance for your help.

Regards,

Marius

[Roberts Čāčus]

Hi @Marius GNAMIEN,

Some additional authentification steps are required if you are using eazyBI in Jira Cloud. Please see our documentation regarding that - https://docs.eazybi.com/eazybi/set-up-and-administer/customization/report-results-export-api#ReportresultsexportAPI-Authentication.

Let me know if you have any other questions.

Best,

Roberts // support@eazybi.com