API or export to capture the data

I’d like to automate profile valuation snapshot extraction. Could be an API, could be some kind of data export feature. Of the 2 the API is better because then I can automate the whole process of extract, transform, load with one program.