Ability to generate and download reports through api

Would like to automate generating and downloading reports through the API.  I do not have access to the database but would like to have the ability.