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.
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
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
Package Run Id: 109495981
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.
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!
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
