CSV export using API

Yes, absolutely!

You can request the search results of a query in CSV format by using the regular search resources (e. g. /search/universal/absolute) and setting the HTTP Accept header to text/csv or use the /export resource (e. g. /search/universal/absolute/export).