Forum Discussion
HamzaJ
09-09-2022Data Integration
If you have access to the server, you could schedule a python script to run at set times.
More on how you can use python to export widgets/dashboards to CSV:
https://community.sisense.com/t5/build-analytics/exporting-csv-using-rest-api/m-p/1698
Otherwise you could use tools like Zapier do this for you.
Get the widget jaql: https://support.sisense.com/kb/en/article/extracting-retrieving-results-from-widgets-to-json-format-using-jaql-queries-104695
Add the following to the root:
"csvSeparator": ";", "format": "csv",
Send this payload to <sisense_url>/api/v1/datasources/<elasticube>/jaql
This will result in a downloadable CSV which you can then send via email