Question

Search Custom Hubspot Object By Multiple Fields

  • 29 April 2024
  • 1 reply
  • 28 views

Hello everyone!
I have an integration from Segment to Hubspot Cloud Mode (Actions) where I created a mapping for group calls for update some deal’s properties on destination.

The problem here is that I have a custom property “empresa_id” for search the deal that may be updated, it’s an unique internal company ID on my application, but in Hubspot it can be repeated in other deal with the same “empresa_id” value so Hubpost API failed, because it supports only one record update by request.

I have another property called “empresa_activa” (boolean), it describes if deal is active or not, I want to use that property for search the deal to update too:



But when I configure it on mapping, the request always fails because the generated search in request is:

"filterGroups": [
{
"filters": [
{
"operator": "EQ",
"propertyName": "empresa_activa",
"value": "1"
}
]
},
{
"filters": [
{
"operator": "EQ",
"propertyName": "empresa_id",
"value": "999999"
}
]
}
],

When “filters” goes like that (separate objects) the results always will be more than one record so the error message is this:

“The search criteria defined by Custom Object Record Search Fields returned more than one records. The update request will be rejected.”

The request that I want to generate is something like this:

"filterGroups": [
{
"filters": [
{
"operator": "EQ",
"propertyName": "empresa_activa",
"value": "1"
},
{
"operator": "EQ",
"propertyName": "empresa_id",
"value": "999999"
}
]
}
],

I test it mannually on postman with the Hubspot API and it works!

Is there any way to generate the custom object search fields how I need?


1 reply

Userlevel 1

Hi @Nicolas Recabarren

Thanks for posting! Reading through this, it sounds like the issue is how Segment is sending/mapped to the Hubspot API where it will hit the Record Update limit of 1 each time. It seems you may already be familiar with our documentation on upserting the company and other available actions. The “Company Search Fields” box seems most relevant but please correct me if I’m wrong on that. 

I haven’t found a resolution just yet. Given the limitation I can bring it up with the right team as a potential product/integration gap, while I keep asking around internally for a potential solution. 

Have you by chance opened up a support ticket with Friends@segment.com yet? If not I can do that on your behalf.

Reply