API connection or a way to connect to ftop data and export

Hello, I'm very much interested in trying to automate the process of exporting data from FTOP. For example I'd like to be able to connect it to an excel or a Access DB or even a LOB app that might connect sales, the data from the clients and FT Managers. This way I could generate alerts when different thresholds are met (i.e usage, new workloads, etc...) Is there a way to do this? Thank you kindly!