Azure Data Factory Hubspot connector returns 414 on Contacts Properties Values
Hey,
we started getting an error with Data factory utilizing the Hubspot connector. " Operation on target Copy_7eo failed: 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,' "
The linked service connection to the API works, but fetching records from Contact_properties_values endpoint for us seems to make the copy activity crash with the error above. Other endpoints do work just fine as this has for months.
Have there been changes lately to this particular endpoint?
I have been in contact with Microsoft support regarding this and they suggested to contact Hubspot's team.
Please let me know if there is any more information I can provide to get this fixed or start debugging this more in depth.
Azure Data Factory Hubspot connector returns 414 on Contacts Properties Values
Same here, today is 31/05/2022 and we are still experiencing the same error as described by jmik. We integrated our databse with hubspot via linked service in azure data factory. Suddenly the "Contact_properties_values" endpoint started throwing the "Error parsing JSON: Invalid value. while parsing string" error. Every other endpoint works perfectly.
Azure Data Factory Hubspot connector returns 414 on Contacts Properties Values
I'm with you. Same as here. But the difference is that I'm not using the Azure Data Factory for that. I'm using a script Python.
What I know is that we have to put all properties names in the url. While you have just a few properties, it's ok. But when you have more than 500, it could be a big problem.
I don't now yet the character limit of the Hubspot. I read a post that said something about 16.391.
I had to split the properties in groups before do made a GET request. Of course, it will taking so much time and so many requests to make!
I would love if Hubspot could grow the character limit, or implement a new endopoint to get all the objects with all properties.
Azure Data Factory Hubspot connector returns 414 on Contacts Properties Values
Hey,
I'm not exactly sure of the url as I'm not the one defining it in Azure Data Factory, you choose from a collection of pre made "tables" with the connector once the connection has been configured to the API.
It's just called Hubspot.Contact_properties_values .
It should return Vid, Property_Name, Property_Value
Discussed internally and there has been no change on the API side. Was informed that something similar has happened before and it is when too many properties are being called.
The connector gathers all properties defined in HubSpot and appends to the request url. The guess is that a new property was defined in HubSpot and that was the straw that broke the camel's back.
Azure Data Factory Hubspot connector returns 414 on Contacts Properties Values
Can you please tell me how I can get the same data by using HubSpot REST API? Which endpoint should I be using to get data instead of using HubSpot ADF Connector with tableName = "Hubspot"."Contact_Properties_Values"?
For example, when I use ADF with the above, I get a csv file something as follows. I'm trying to switch to using REST API that gives me a response containing same detailss
Azure Data Factory Hubspot connector returns 414 on Contacts Properties Values
So, the problem is the structure that you set up without foreseeing these problems. For small companies hubspot can be a useful service but for companies that are starting to have considerable growth hubspot is not helpful to handle all this volume.
Azure Data Factory Hubspot connector returns 414 on Contacts Properties Values
Great, I'll see what I can do. I did contact MS support already last Friday with the information you gave, so let's see if we get a response from there.
I'll also try to get the exact request uri if possible and forward any information that might be helpful here!