API Contact Search Date Issue

Develop, Build & Integrate APIs & Integrations
1

I am using the API to pull back any contact created yesterday (3/11/2025).

The endpoint is: https://api.hubapi.com/crm/v3/objects/contacts/search

Using this date format:

{
 "limit": 200,
 "filterGroups": [
 {
 "filters": [
	 {
 "propertyName": "createdate",
 "value" : "2025-03-11T00:00:00.000Z",
 "operator": "GT"
 }
 ]
 }
 ],
 "sorts": [
 {
 "propertyName": "createdate",
 "direction": "DESCENDING"
 }
 ],
 "properties": [ "hs_object_id", "email", "createdate", "company", "firstname", "lastname" ] 
}

returns 75 records - you can see a snippet of the createdate and id of each from the results:

Screenshot 2025-03-12 122745.png
Screenshot 2025-03-12 122745.png287×751 36.9 KB

In Hubspot though, if I filter the contact list by created “yesterday” (or view all and sort by created date) there are actually only 2 contacts created:

Screenshot 2025-03-12 122824.png
Screenshot 2025-03-12 122824.png553×264 16.3 KB

I have also tried this date format:

{
 "limit": 200,
 "filterGroups": [
 {
 "filters": [
	 {
 "propertyName": "createdate",
 "value" : "1741651200000",
 "operator": "GT"
 }
 ]
 }
 ],
 "sorts": [
 {
 "propertyName": "createdate",
 "direction": "DESCENDING"
 }
 ],
 "properties": [ "hs_object_id", "email", "createdate", "company", "firstname", "lastname" ] 
}

with the same result.

Any idea why the records coming in the response would show a create date of 3/11 but in the app itself they all show 3/10 or earlier except for the 2 legitimate ones?

2

Would it not just be a simple Time Zone difference? Unix Timestamps, which is the format that Hubspot uses to store datetime fields, uses UTC time.

It looks like your Hubspot is set to EDT time. Have you checked to see if you switched to UTC for your account that you would get the same results in Hubspot as the API request?

Have you tested the api using with the EDT time zone?

2025-03-11T00:00:00.000-04:00

3

That was it - I missed that i was adjusting for 4 hrs on my code where I didn’t need to. Thanks!