Get email events API - parameter startTimestamp not being respected

[BambooBox]

Hi,

I am trying to use the API below to fetch the events for a campaign post a given timestamp -  https://legacydocs.hubspot.com/docs/methods/email/get_events

and using the parameters as provided in the documentation so my URL looks like below:

https://api.hubapi.com/email/public/v1/events?campaignId=<XX>&limit=1000&startTimestamp=1664947667

As per the documentation, I expected the API to return all the events for the specified campaign(XX) post the time in startTimestamp parameter. But the API is returning me events even before the time provided.

Is this the correct behavior or am I missing anything? Is there any API to get the event data for a campaign after a specific date?  Please suggest.

Best Regards,

Ashima

[coldrickjack · Accepted solution]

Hey @BambooBox,

I think the issue is to do with the value you are including for the startTimestamp query parameter. HubSpot expects the value to be in milliseconds. The value you are passing (1664947667) translates to Tue Jan 20 1970 06:29:07. So it would make sense that you are getting back all of that data. 

I'm not sure what date range you are trying to work within but if I wanted to get all of the events for a campaign on or after 1st of Jan 2022 I'd do something like this:

https://api.hubapi.com/email/public/v1/events?campaignId=61935014&startTimestamp=1640995200000&limit=20

[coldrickjack · Accepted solution]

Hey @BambooBox,

I think the issue is to do with the value you are including for the startTimestamp query parameter. HubSpot expects the value to be in milliseconds. The value you are passing (1664947667) translates to Tue Jan 20 1970 06:29:07. So it would make sense that you are getting back all of that data. 

I'm not sure what date range you are trying to work within but if I wanted to get all of the events for a campaign on or after 1st of Jan 2022 I'd do something like this:

https://api.hubapi.com/email/public/v1/events?campaignId=61935014&startTimestamp=1640995200000&limit=20

[BambooBox]

Thanks, this was helpful

[JBeatty · Accepted solution]

@BambooBox,

To build upon this, it looks like the timestamp you entered "1664947667" is in seconds, while HubSpot expects milliseconds for its timestamp so if you want to do Wednesday, October 5, 2022 5:27:47 AM you would do "1664947667000" instead.

Best,

[TiphaineCuisset]

Hi @BambooBox 

Thank you for reaching out.

I want to tag some of our experts here - @coldrickjack @Bryantworks @JBeatty do you have any thoughts for @BambooBox on this? 

Thank you!

Best

Tiphaine