topic Re: Customer Map - Prefilter Customer Map API in APIs & Integrations

Customer Map - Prefilter Customer Map API

ianhill — Mon, 15 Oct 2018 15:41:16 GMT

Hey,

I'm in the process of creating a "Customer Map" so we can see where out customers are based, when meeting them, we can also see who else is in the area for a visit.

The issue I'm having is that the " Get all companies" API will return every company we have in the database. Unfortunately, not every company in the database is our customer - yet!

Is there a way to prefilter this API to show just those who are marked as a "Customer"?

If not, is there any alternative methods you can think of?

Cheers, Ian

Re: Customer Map - Prefilter Customer Map API

cbarley — Mon, 15 Oct 2018 21:15:12 GMT

Hi @ian_hill123, there's no way to prefilter companies when using the Companies API, unfortunately. You'll need to continue to get all companies, then filter on your end only the companies with a lifecyclestage of customer

Re: Customer Map - Prefilter Customer Map API

ianhill — Tue, 16 Oct 2018 09:08:59 GMT

Thanks for clarifying Conner

We have over 120,000 companies in the CRM, which will take over 500 calls to your API to get all of the companies. Is there a quicker, more robust way? Maybe like getting all companies in a list? Or maybe a Reporting API?

Re: Customer Map - Prefilter Customer Map API

cbarley — Tue, 16 Oct 2018 18:44:56 GMT

Hi @ian_hill123 unfortunately not. Like tickets contacts and deals, companies cannot be filtered or grabbed in parallel to limit calls

Re: Customer Map - Prefilter Customer Map API

ianhill — Wed, 17 Oct 2018 08:11:26 GMT

No worries mate, I'm going to create an external database and use the webhooks to keep it up to date.

Thank you for the help

Re: Customer Map - Prefilter Customer Map API

cbarley — Wed, 17 Oct 2018 13:45:25 GMT

No worries @ian_hill123 !

Re: Customer Map - Prefilter Customer Map API

Dan1 — Tue, 05 May 2020 20:20:19 GMT

Hi @ianhill ,

I know this was a question was from a few years ago, but just in case you didn't figure out a solution. Check out our app GeoMapper in the HubSpot app marketplace. It's built solely for HubSpot customers.

We created the solution for exactly the use case you referenced. However we went a few steps further, so you can create any filter you want.

I hope this helps 🙂