Hubspot connector doesn't work for deal properties: 414 Request-URI Too Large

Boglarka Barany 0 Reputation points
2024-05-21T07:12:35.4133333+00:00

I am getting this error message when trying to copy data from Deal properties from Hubspot:

Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][Hubspot] (100) Error parsing JSON: Invalid value. while parsing string <html>

<head><title>414 Request-URI Too Large</title></head>

<body>

<center><h1>414 Request-URI Too Large</h1></center>

</body>

</html>

.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][Hubspot] (100) Error parsing JSON: Invalid value. while parsing string <html>

<head><title>414 Request-URI Too Large</title></head>

<body>

<center><h1>414 Request-URI Too Large</h1></center>

</body>

</html>

.,Source=HubspotODBC_sb64.dll,'

Please help to fix this, thank you!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,862 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 17,706 Reputation points
    2024-05-21T09:01:36.9866667+00:00

    Under Apache, the limit on the request URI length is defined by the configurable value LimitRequestLine. If you need to support longer request URIs, increase this value from its default of 8190. However, extremely long URLs are typically a mistake. Keeping URLs under 2000 characters ensures compatibility with most client and server software. The maximum URI length varies depending on several factors. For example, Chrome limits URL length to 2MB for practical reasons, including avoiding denial-of-service issues in inter-process communication. On most platforms, Chrome's omnibox displays URLs up to 32kB (kMaxURLDisplayChars), with a 1kB limit on VR platforms. Other browser limits include IE at 2083 characters, Firefox at 2047 characters, Safari at 80,000 characters, and Opera at 190,000 characters.

    To resolve issues with URL length:

    • By POST request: Convert the query string into a JSON object and send it to the API using a POST request.
    • By GET request: The maximum length of a GET request depends on both server and client-side limits. Most web servers have an 8k limit, which is configurable. Client-side limits vary by browser: IE and Safari limit to 2k, Opera to 4k, and Firefox to 8k. Therefore, the maximum GET request length is 8k, and the minimum is 2k.

    If a request exceeds the maximum length, it will be truncated by the web server or browser without warning. Some servers truncate the request data, while others reject the request entirely due to data loss, returning a response code 414. https://learn.microsoft.com/en-us/answers/questions/164041/data-factory-hubspot-connector-returns-414-request