@LLiz it’s hard to say what the problem is, but if you are not able to solve it, we offer an app in the HubSpot App Marketplace called MS SQL Server for HubSpot . The app pulls your HubSpot data into an Azure SQL data warehouse via prebuilt API connectors. The data warehouse in Azure is included in the cost.
Once your HubSpot data is in the data warehouse, it automatically refreshes on a scheduled basis. You can connect the SQL data warehouse to any other application that has a SQL connector.