Need to export reconciliations and Transaction using rest API or EPM automate

Summary:

Is there any way that we can export specific View of recon's and Transaction using EPM automate or any rest API

Content (please ensure you mask any confidential information):

Currently my business users created user specific View in Reconciliation and Transaction screen with specific columns and exporting the values manually from Reconciliation and Transaction screen and using it in PowerBI for internal reporting ,by Period as a filter .

Now we would like to automate the process to export the data from Reconciliation and Transaction screen and SFTP the file to specific server where powerBI is running.

is there any rest API or EPM automate that we can use to export the data from those Reconciliation and Transaction screen.