APIs & Integrations

LLiz
Member

Error when accesing tables from Synapse

SOLVE

Hi

 

We are trying to obtain the data of HubSpot from Azure Synapse without success.

We are getting the following error when accesing to the tables:

Error code 9603

Details ERROR [HY000] [Microsoft][Hubspot] (61) API Connection Failed. Bad Request. HTTP Responde code: 400

 

Any help?Captura3.JPG

0 Upvotes
1 Accepted solution
johnelmer
Solution
Top Contributor | Diamond Partner
Top Contributor | Diamond Partner

Error when accesing tables from Synapse

SOLVE

@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.

Did this post help solve your problem? If so, please mark it as a solution.




John Elmer, CEO
Bayard Bradford

Advanced CRM Implementation | RevOps Services | Datawarehouse.io Apps for HubSpot
HubSpot Diamond Solutions Partner

View solution in original post

2 Replies 2
johnelmer
Solution
Top Contributor | Diamond Partner
Top Contributor | Diamond Partner

Error when accesing tables from Synapse

SOLVE

@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.

Did this post help solve your problem? If so, please mark it as a solution.




John Elmer, CEO
Bayard Bradford

Advanced CRM Implementation | RevOps Services | Datawarehouse.io Apps for HubSpot
HubSpot Diamond Solutions Partner
dennisedson
Community Manager
Community Manager

Error when accesing tables from Synapse

SOLVE

@LLiz ,

Did you follow the instructions detailed on this page?

@johnelmer may have some advice, but it might be best to ask in the Azure community

Thanks,

Dennis




HubSpot Community Developer ShowMake sure to subscribe to our YouTube channel
where you can find the HubSpot Community Developer Show
0 Upvotes