Api Connection from Fishbowl to Power Bi

We need to move information/report from our Inventory Management System (Fishbowl) to Power BI through an API connection. The report is called "customer purchase history". It would need to be formatted in a way that can be used by Power BI (When I export the report it takes a lot of manual cleaning) https://help.fishbowlinventory.com/s/article/Fishbowl-API