I know that I can download a set of reports within a single dashboard in an Excel file with multiple sheets based on the number of reports through email. But my suggestion is whether we can do the same thing using an API. I’ve felt the need for this a lot recently, where I need to export the dashboard but through the API, and I hope it follows the same method and options as the email.
Note:
Not the canvas dashboard. I mean the normal dashboard if I can call it like that. Below an example
I need to be able using API to export the dashboard with 2 sheets based on the number of reports but not using email. I need to do it using API please.
See more details on how to export a widget at Get Data.
When the Job is finished, you can download the exported file using the download export API.
Exporting all reports from a dashboard into one single Excel file (with each report as a separate sheet) is currently not available via APIs.
That being said, I can definitely see how it can be a useful addition. Duly noted in our product backlog.
Let me get back to you when there’s an update. Cheers!