Troubleshooting Error 200 in HubSpot API Connection for Company Owner

Fausto B. · 2025-11-25T16:34:24.250Z

Hi there, I've been hitting this error 200 in my API connection to HubSpot. My goal is to get from HubSpot the company owner value (native property). Any guidance would be appreciated. Adding the details below: Method - POST Endpoint - https://api.hubapi.com/crm/v3/objects/companies/search This is the body of the API { "filterGroups": [ { "filters": [ { "propertyName": "domain", "operator": "EQ", "value": " Domain " } ] } ], "properties": [ "hubspot_owner_id", "domain" ] }

Troubleshooting Error 200 in HubSpot API Connection for Company Owner | Clay

Clay Support
APP
·
·
Looking at your JSON body, I can see a potential formatting issue. The value " Domain " has extra spaces around it, which might be causing problems.
For dynamic column references in Clay's HTTP API, you need to use the proper format. If "Domain" is a column reference, it should be "/Domain Column" with quotes around the slash notation.
Could you copy and paste your exact JSON body from Clay so I can help troubleshoot the specific formatting issue? This will help me spot any hidden characters or syntax problems that might be causing the error.
Fausto B.
·
·
{ "filterGroups": [ { "filters": [ { "propertyName": "domain", "operator": "EQ", "value": " Domain " } ] } ], "properties": [ "hubspot_owner_id", "domain" ] }
Clay Support
APP
·
·
I can see the issue! Your JSON has extra spaces around "Domain" in the value field: "value": " Domain ".
If "Domain" is referencing a Clay column, it should be formatted as "value": "/Domain Column" with quotes around the slash notation.
Try this corrected version:
{ "filterGroups": [ { "filters": [ { "propertyName": "domain", "operator": "EQ", "value": "/Domain Column" } ] } ], "properties": [ "hubspot_owner_id", "domain" ] }
The key fix is removing the extra spaces and using proper dynamic column reference formatting.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help resolving the API error or formatting your JSON correctly, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any other issues you’re encountering?
Fausto B.
·
·
I ran it but got the following answer { "total": 0, "results": [] }
Fausto B.
·
·
I know that in HubSpot the company owner value is populated for this specific row
Clay Support
APP
·
·
Getting zero results usually means the domain value doesn't match exactly what's in HubSpot. Try these fixes:
1.
Check the exact domain format - HubSpot might store domains as "example.com" while your column has "www.example.com" or vice versa
2.
Verify your column reference - Make sure "/Domain Column" matches your actual column name exactly
3.
Test with a known domain - Replace "/Domain Column" with a hardcoded domain like "clay.com" to see if the API works
Can you paste your current JSON body so I can help troubleshoot the exact formatting?
Clay Support
APP
·
·
Getting zero results usually means the domain value isn't matching exactly what's in HubSpot. The domain field in HubSpot is case-sensitive and needs to match precisely.
Try checking:
Remove "www." from your domain if it's included
Ensure no extra spaces or characters
Verify the exact domain format in HubSpot (some companies use different domain variations)
Also, make sure your column reference is correct - it should be "/Domain Column" with quotes around the slash notation. Can you copy and paste your current JSON body so I can help troubleshoot the exact formatting?
Clay Support
APP
·
·
If you still need help troubleshooting the API response or adjusting your JSON formatting, I’m here to assist. Would you like to share your current JSON body or any other details about what you’re trying to resolve?
Fausto B.
·
·
SHould I change the row type to text?
Clay Support
APP
·
·
No, changing the row type to text won't fix this. The issue is likely with your domain formatting or column reference.
For dynamic column references in JSON, you need quotes around the slash notation: "value": "/Domain Column". Also ensure the domain format matches exactly what's stored in HubSpot (no www, extra spaces, etc.).
Can you copy and paste your current JSON body so I can spot the exact formatting issue?
Fausto B.
·
·
now i got this error Clay received a 429 error from the API with Content: {"status":"error","message":"You have reached your secondly limit.","errorType":"RATE_LIMIT","correlationId":"5f984429-da24-4581-9241-55352f6b41b9","policyName":"SECONDLY","groupName":"publicapi:crm:search:oauth:24889766:7476749"}
Clay Support
APP
·
·
The 429 error means you've hit HubSpot's rate limit. You need to configure rate limiting in your HTTP API settings.
Set a Request Limit and Duration - for example, 10 requests per 1000ms (1 second). The rate limit must average at least 5 requests per second to work properly.
In your HTTP API enrichment, scroll down to the rate limiting section and add these settings to prevent hitting HubSpot's limits.
Clay Support
APP
·
·
Is that what you were looking for?

22 comments