Schedule a daily export to excel
I see where you can schedule an automated report that sends a image via email and I also see how to export data in Axiom. What I would like to do is export a set of data to excel daily. What is the best approach for doing this?
2 replies
-
Hi ,
Unfortunately, we don't have anything that outputs an Excel file automatically, but you could use our Excel Add-in to build a report. We also have an API which you could run at scheduled times to retrieve data. I'll place some links here if any of these are of interest.
https://helpcenter.canarylabs.com/category/excel-add-in-v24
https://readapi.canarylabs.com/24.1/
https://github.com/CanaryLabs/SampleCode/tree/master/Samples/V23/Data%20Retrieval/PowershellThe last link contains some Powershell examples using the web API to output a csv file of the data.
-
Thank you. We are going to try the Excel Add-in and if that doesn't do what they need I'll work on the API.
Print this page