HubSpot EmailEvents API where clause

Thank you. I can work with that. One other question.

I changed my Query to this and it comes back quickly:

SELECT t.*

FROM EmailEvents AS t

where (t.CreatedAt > '2024-06-10 12:13:00' and t.type = 'SENT' )

But, if I add one more filter condition below, the Query runs slow again. Is this another limit I am hitting up against?

SELECT t.*

FROM EmailEvents AS t

where (t.CreatedAt > '2024-06-10 12:13:00' and t.type = 'SENT' and t.AppName = 'Batch')

---

Hi,

I am trying to pull data from the HubSpot EmailEvents API. If I query to pull all data, it works fine. But if I include a WHERE clause, it seems to just run forever.

SELECT t.*

FROM EmailEvents AS t

where (date(t.CreatedAt) > date('now', 'localtime', '-2 day'))

Is it possible to use a WHERE clause with the EmailEvents API?

The HubSpot documentation does show another API for bulk event data transfer, does SkyVia support this API? see https://legacydocs.hubspot.com/docs/methods/email/get_events

thank you