We have this request to create a report to compare Alfresco Site's data VS. Our own System Data. And now what we aim is get the list of file names or data under sites then insert it to outside DB(Oracle or MySql), but the problem is we have no idea where to start yet. We are still on research phase and hoping that we can find better way to call or retrieve information from Alfresco.
API could be the best option for this but we have no idea yet on how.
Below showing Files from PIMS:METRO CARMEN Site - Document Library. File that we want to retrieve from the Site.