We have an issue where we have to manually click Export Report on SFDC reports though the UI on many reports. These reports have several filters and filter logic such as "(1 or 2) AND (4 AND 1)" and other filters such as ("Status=Completed AND User="First_Last") OR (CloseDate>=TODAY), etc.
Ideally, we want to automate the process of running the report, exporting the data as a xls (excel) format, and saving to a particular location.
The idea was to create a java class that pulls a selective list of reports that we can export into an XML file. Then another java class can then use the XML file to find the filter criteria and logic that can be used to build a SOQL query dynamically so that if in Salesforce the report criteria or filters are updated, we can easily have the java class update without manually updating (basically trying to prevent the hardcoding of soql query).
I am needing assistance with trying to get the appropriate API to use so that when the selective list of reports are pulled, i can parse through the XML file and easy create an Excel file for each report that contains the filter logic and criteria. I imagine i can use the ANT migration tool to generate the xml files.