APIs & Integrations

tekbird
Member

Filter contacts based on lastmodifieddate

SOLVE

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

 

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

0 Upvotes
1 Accepted solution
WendyGoh
Solution
HubSpot Employee
HubSpot Employee

Filter contacts based on lastmodifieddate

SOLVE

Hi @tekbird,

 

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:

list.png

 

Hope this helps to clarify!

View solution in original post

0 Upvotes
4 Replies 4
WendyGoh
Solution
HubSpot Employee
HubSpot Employee

Filter contacts based on lastmodifieddate

SOLVE

Hi @tekbird,

 

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:

list.png

 

Hope this helps to clarify!

0 Upvotes
tekbird
Member

Filter contacts based on lastmodifieddate

SOLVE

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

0 Upvotes
aronhoekstra
Participant

Filter contacts based on lastmodifieddate

SOLVE

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.

0 Upvotes
WendyGoh
HubSpot Employee
HubSpot Employee

Filter contacts based on lastmodifieddate

SOLVE

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: 

 

Screen Shot 2019-09-11 at 9.25.59 AM.png

 

  • 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.

0 Upvotes