Using API to search for companies based on a specific property value

[growthMarketer]

Hi everyone,

I'm trying to use Hubspot API to access a filtered list of companies we have on Hubspot.

Unfortunately, the API only has a query to get all companies, but not for searching companies based on a company property. The contact API does provide a search endpoint though, so I wondered if something similar is possible for companies:
https://developers.hubspot.com/docs/methods/contacts/search_contacts

Using the company API and the endpoint for all companies is not relevant for us because we have more than 1M companies. It's a wasteful use of resources for both Hubspot & us as it would mean making 1,000 queries to get all our companies, then filtering them out on our side.

This is a basic and critical API endpoint for a CRM so I'm bit disconcerted that this is not available.

[lscanlan]

Hi @growthMarketer,

While you can search companies by domain: https://developers.hubspot.com/docs/methods/companies/search_companies_by_domain, it's not possible to search by company properties. If you take a look at the post here: https://community.hubspot.com/t5/APIs-Integrations/Search-for-companies-by-name/m-p/239345, my colleague Isaac posted a reply towards the bottom of that thread. There is an idea currently on our ideas forum, which you can find here: https://community.hubspot.com/t5/HubSpot-Ideas/Search-contacts-companies-and-deals-by-custom-propert.... Definitely add any extra feedback you have and add your vote to it. I see the idea is submitted. I'm not sure what the timeline is like, but the more traction it gets, the more visibility it will have.