HubSpot Calls API - How to Results to Yesterday Activity Date?

aaron_payne — Tue, 02 Apr 2024 19:11:30 GMT

Hi there,

I am trying to pull all call records from HubSpot from the previous day. I am trying two different end points but am unsure of what the best method is to pull these call records.

Endpoints

- https://api.hubapi.com/crm/v3/objects/calls

- https://api.hubapi.com/crm/v3/objects/calls/search

Examples

1. I am using this enpoint that does return results but I am not sure how to filter the data to yesterday. The results seem to be from years ago and not showing the activity date of yesterday. Code below.

headers = {
'Authorization': 'Bearer xxxxxx',
'Content-Type': 'application/json'
}

properties = ["hs_call_title","activity_date"]

# Calculate the start and end timestamps for yesterday
yesterday = datetime.now() - timedelta(days=1)
start_timestamp = yesterday.strftime('%Y-%m-%d')
end_timestamp = yesterday.strftime('%Y-%m-%d')

# Specify parameters for the request
params = {
'limit': 100, # Adjust the limit as needed
'archived': False, # Exclude archived calls
'sort': 'createdAt ASC', # Sort by creation date in ascending order
'createdAt.gte': start_timestamp, # Filter calls created after the start of yesterday
'createdAt.lte': end_timestamp, # Filter calls created before the end of yesterday
'properties': properties # Include specified properties
}

# Make the API request
#response = requests.get('https://api.hubapi.com/engagements/v1/engagements/paged', headers=headers, params=params)
response = requests.get('https://api.hubapi.com/crm/v3/objects/calls', headers=headers, params=params)

Example 2

I am using the Search endpoint and getting an error with the filter groups JSON. Code below

headers = {
'Authorization': 'Bearer xxxxxxx',
'Content-Type': 'application/json'
}

# Calculate the start and end timestamps for yesterday
yesterday = datetime.now() - timedelta(days=1)
start_timestamp = yesterday.strftime('%Y-%m-%d') + "T00:00:00Z" # Start of yesterday
end_timestamp = yesterday.strftime('%Y-%m-%d') + "T23:59:59Z" # End of yesterday

# Specify parameters for the request
# Construct the search query
query = {
"filterGroups": [
{
"filters": [
{
"propertyName": "createdate",
"operator": "BETWEEN",
"value": [start_timestamp, end_timestamp]
}
]
}
],
"properties": ["hs_call_title"] # Include specified properties
}
# Make the API request
#response = requests.get('https://api.hubapi.com/engagements/v1/engagements/paged', headers=headers, params=params)
response = requests.post('https://api.hubapi.com/crm/v3/objects/calls/search', headers=headers, json=query)

What is the best way to simply pull all calls from the previous day?

Re: HubSpot Calls API - How to Results to Yesterday Activity Date?

Jaycee_Lewis — Wed, 03 Apr 2024 16:56:24 GMT

Hey, @aaron_payne 👋 The search API is likely your best bet as it allows for filters, search operators, and sorting. The endpoint https://api.hubapi.com/crm/v3/objects/calls doesn't offer those options.

Have fun building! — Jaycee

Re: HubSpot Calls API - How to Results to Yesterday Activity Date?

aaron_payne — Wed, 03 Apr 2024 17:44:01 GMT

Hi Jaycee, thank you for that information! Would it be possible to show an example code Python code block with the filters included the json query?

Re: HubSpot Calls API - How to Results to Yesterday Activity Date?

halice — Fri, 19 Sep 2025 13:02:02 GMT

Hi-

I know some time has passed since your post, but in case anyone has a similar question in the future.

This is JSON that worked for me - I specified the date using the GTE and LT operators for the time filters:

{ "filterGroups": [ { "filters": [ { "propertyName": "hs_timestamp", "operator": "GTE", "value": 1758204000000 // ms UNIX timestamp at 0:00 am }, { "propertyName": "hs_timestamp", "operator": "LTE", "value": 1758290400000 // ms UNIX timestamp at 0:00 am of the following day } ] } ], "properties": ["hubspot_owner_id"], "limit": 100, "after": 0 }

Hope this helps someone!

topic Re: HubSpot Calls API - How to Results to Yesterday Activity Date? in APIs & Integrations

HubSpot Calls API - How to Results to Yesterday Activity Date?

Re: HubSpot Calls API - How to Results to Yesterday Activity Date?

Re: HubSpot Calls API - How to Results to Yesterday Activity Date?

Re: HubSpot Calls API - How to Results to Yesterday Activity Date?