Our desired functionality is to write a cron job to make an API call at 1am on Monday which will spawn a task on the ZenDesk side to generate a View email and have it sent to a User.
Support does not allow for scheduling the "Export as CSV" function for Views; it must be done via a button click. The API does not appear to support Export as CSV to be emailed to a given user.
(If it does, I'd be interested in getting more details about how to make this happen.)
Absent this, I'd like to be able to create an Explore Dashboard from a Support View; it's a simple view, only 8 columns of data. I'm not seeing any documentation that explains how to generate an Explore Query from a Support View.