financial consolidation and close

Hi Experts,

There is a request from the client to automate the “Consolidation Journal Report” and “Data Load Mappings of Integration” to download and transfer these files to SharePoint through REST APIs using the OIC application.

We would like to understand the following points for this solution:

1. When the file is created in the Home location, on which server is it stored — UCM or any other?
2. Please share the server connection details required to connect through OIC to pick up the file.
3. What roles and APIs are needed to access or retrieve the files from the location?
4. If there is any existing