I just want to write an API to extract historical weather data into a CSV. Any help is much appreciated!
I'm afraid this data is not available through any API in Eikon. The most you can do is semi-automate the download of report spreadsheets. See this thread for more details.