topic How to retrieve only updated data via API calls in HubSpot? in APIs & Integrations

How to retrieve only updated data via API calls in HubSpot?

yellalingh — Thu, 30 Oct 2025 10:47:20 GMT

Hi Team,

I am working on an ELT tool, using APIs I would like to know how can i make sure that I get only updated data(new data) in second time API call, something like offset we use for single API call to get all the data, as per the reference doc this Offset is not long live. Or is there a fixed time interval before which I can use the offset from first call and make the second request

Re: API request

Derek_Gervais — Fri, 01 Nov 2019 20:42:22 GMT

Hey @yellalingh ,

The offsets provided accross all of our paginated APIs are not long-lived; while the exact lifespan can differ depending on the API, none of them should be considered valid on a larger timescale than an hour.

Depending on what specific data you're pulling from HubSpot, you might consider using some of the recently modified / recently created endpoints (e.g. Recently Created Contacts). While you shouldn't store the offset value, you can store the addedAt timestamp for the last contact you've pulled. The next time you go to pull recently created contacts, you can stop once you've paged back far enough to reach addedAt values that you've already seen.

Re: API request

yellalingh — Fri, 08 Nov 2019 11:19:48 GMT

Hi @Derek_Gervais ,

I am trying to use Create timestamp to pull data, can I don't see any difference in the result. below is the sample url.

https://api.hubapi.com/email/public/v1/events?hapikey=*****&recipient=c****@gmail.com&created=1571241870660

I tried using this object too

{{'$and': [{'recipient': 'c**********@gmail.com'},{'created': {'$gt': 1571241870660}}]}}"

In both the cases i don't see any change. can you please help me understand if i am missing anything

Re: API request

Derek_Gervais — Fri, 08 Nov 2019 15:32:08 GMT

Hey @yellalingh ,

I see; thanks for including an example! The email events API doesn't support a `created` parameter: Instead, you can use a combination of `startTimestamp` and `endTimestamp` to define the timeframe for which you want to pull data, and then paginate through the data using the `offset` values provided in each response.

For more details on this method, check out the following endpoint doc: https://developers.hubspot.com/docs/methods/email/get_events

Re: API request

RubenBurdin — Wed, 22 Oct 2025 20:20:39 GMT

Hi @yellalingh you’re on the right track trying to pull only deltas.

For email activity, don’t use a created param. Page by time window instead: call the Email endpoints with a startTimestamp and endTimestamp, then use the returned offset only within that run.

Store a “watermark” timestamp from the last successful batch and move the window forward next job. Also note a 2025 update: the old /email/public/v1 Events API is being sunset, so plan to migrate to Marketing Emails v3 statistics, which also accept time-bounded queries for reporting (https://developers.hubspot.com/docs/api-reference/marketing-marketing-emails-v3/statistics/get-marketing-v3-emails-statistics-list )

For CRM objects like contacts/companies, use the CRM Search API with filters on hs_lastmodifieddate or createdate greater than your stored watermark; that gives you true incremental loads without relying on offsets (https://developers.hubspot.com/docs/api-reference/search/guide ).