topic Re: Filter contacts based on lastmodifieddate in APIs & Integrations

Filter contacts based on lastmodifieddate

tekbird — Tue, 03 Sep 2019 17:29:05 GMT

I have the following stack overflow question created. If someone could check it:

https://stackoverflow.com/questions/57776230/filter-contacts-in-hubspot-api

Re: Filter contacts based on lastmodifieddate

WendyGoh — Wed, 04 Sep 2019 01:28:15 GMT

I hope all is well with you 😄

Currently, it is not possible to filter contacts based on properties. That said, if you've access to the list tools, you can create an active or static lists with the filter that you'd like (in this case it would be Last modified dateand use this endpoint here: Get contacts in a list | Contact Lists API to retrieve back the contacts in the list.

An example of how the list with the Last modified datefilter looks:

Hope this helps to clarify!

Re: Filter contacts based on lastmodifieddate

tekbird — Wed, 04 Sep 2019 07:00:52 GMT

@WendyGoh , thank you very much for the answer. hope this helps someone else too...

Re: Filter contacts based on lastmodifieddate

aronhoekstra — Tue, 10 Sep 2019 15:59:20 GMT

I also have a need to search contacts by the last modified date. This approach of creating a saved list may be helpful for some, but what if the date changes? I need to dynamically pass a date into the search - only return records that have been modified in the past hour, or something like that. What if I only wanted to return contacts modified in the past day that are only in a particular status (MQL)? This is impossible with the API. So it forces us to put a huge burden on your servers by requesting EVERYTHING and then filtering the results locally. It's inefficient, extremely slow, and costly to our servers. Its honestly in Hubspot's best interest in terms of performance to improve your API search capabilities.

Re: Filter contacts based on lastmodifieddate

WendyGoh — Wed, 11 Sep 2019 01:31:05 GMT

Hi @aronhoekstra,

In the case when you're trying to pull contacts with last modified date in the past day and with a particular lifecycle stage, I'd suggest for you to use the following criteria:

You can use either more than or less than days/weeks ago.

While I understand that that's not the ideal way of filtering contacts if your team is planning to use the HubSpot API to retrieve contacts. That said, if you haven't already done so, I'd strongly urge you to do an upvote and comment on this idea page here so that it's visible to the HubSpot product team and other HubSpot customers and developers. Hopefully this will gather more interest.