topic Re: Filtering companies by last activity date in APIs & Integrations

Filtering companies by last activity date

fsad — Fri, 16 Feb 2024 13:35:33 GMT

I'm trying to reach the API endpoint, filtering by the "last activity" field, and I'm not receiving a response.

https://api.hubapi.com/crm/v3/objects/companies?limit=20&properties=lastActivity

This is the first time I'm attempting to access the HubSpot API. Any suggestions and/or assistance would be appreciated.

Thank you!

Re: Filtering companies by last activity date

dsmarion — Fri, 16 Feb 2024 13:46:27 GMT

If you really want to dive in you might consider taking a certification course that teaches you all about using the APIs: https://academy.hubspot.com/

Re: Filtering companies by last activity date

zach_threadint — Tue, 05 Mar 2024 02:59:10 GMT

Hi @fsad 👋

Welcome to the community 🙂

You might consider using the CRM Search API for this request.

For example, imagine you want to identify Companies that have a "Last Activity Date" of on or after 1 January 2024. Your HubSpot CRM Search API request might look something like this:

POST https://api.hubapi.com/crm/v3/objects/COMPANY/search

Headers:

Content-Type: application/json
Accept: application/json
Authorization: Bearer {YOUR_ACCESS_TOKEN}

Body (JSON):

{ "limit": 100, "properties": [ "notes_last_updated" ], "filterGroups": [ { "filters": [ { "propertyName": "notes_last_updated", "operator": "GTE", "value": "2024-01-01" } ] } ] }

Please note that the property "Last Activity Date" has an internal name (used when interacting with HubSpot APIs) of "notes_last_updated". This property's description, as supplied by HubSpot, is:

"The last time a call, chat conversation, LinkedIn message, postal mail, meeting, note, sales email, SMS, or WhatsApp message was logged for a company. This is set automatically by HubSpot based on user actions in the company record."

I hope this proves useful. Please let me know if you have any follow-up questions.