Hubspot to Sql Replication Package - 414 error code

  • 239Views
  • Last Post 21 October 2022
0
votes
Grant McInnes posted this 13 October 2022

 

Receiving the following error when trying to get Contacts data back from Hubspot:

<html> <head><title>414 Request-URI Too Large</title></head> <body> <center><h1>414 Request-URI Too Large</h1></center> </body> </html>

 

What is the api call you are using? Is there any internal logs that can help me troubleshoot this? Does the api call include archived properties?

I think the issue is that the request length is greater than 8190 so I need to know what the request looks like that is too long.

 

 

Attached Files

Order By: Standard | Newest | Votes
0
votes
Grant McInnes posted this 14 October 2022

I could really use some help on this issue. I have the Contacts schema in sql fixed so that it is not running up against the 8KB limit anymore but the Hubspor to Sql replication is not adding any rows to the sql table, even though there are contacts in hubspot AND the package completes successfully. 

 

Is there any internal logging that can help me determine why no data is being added to sql? Thanks as always for all the help!

Grant

0
votes
Mariia Zaharova posted this 15 October 2022

 Hello Grant,

 

Please specify the package Id or its link so we can check it.

 

Thank you and looking forward to your reply.

 

Best regards,

Mariia

0
votes
Grant McInnes posted this 17 October 2022

 Package Run Id: 109495981

0
votes
Mariia Zaharova posted this 19 October 2022

Hello Grant,

 

Thank you for your reply.

 

Please try the following steps:

- reset the LastSyncTime value in Parameters

- select additionally Drop Tables and Create Tables options

- save and run the package.

 

We are looking forward to your reply with the results.

 

Best regards,

Mariia

0
votes
Grant McInnes posted this 19 October 2022

Thanks, this helps and we are able to push data into sql after following these steps AND after we reduced the number of properties in the Contacts object. We need to know what the threshold is in terms of number of properties we can add to the Contacts object. 

Can you also investigate package id 109383510 which was the error I first reported in this ticket.

 <html> <head><title>414 Request-URI Too Large</title></head> <body> <center><h1>414 Request-URI Too Large</h1></center> </body> </html>

 

Thanks for your support!

0
votes
Mariia Zaharova posted this 21 October 2022

Hello Grant,

 

This error occurs on the Contacts table.

This error is not related to Skyvia limits, it is related to the limitation of web request standards. When executing any package, Skyvia forms an API call and sends it as a web request. If the length of this request exceeds the allowed length of the URL, the package will fail. 

The total length of the Request-URI depends on the names of the columns and not their total number. Unfortunately, we cannot tell you the max length of the Request-URI allowed by HubSpot API. The only solution is to continue removing unnecessary columns with long names.

 

Best regards,

Mariia

Close