HubSpot EmailEvents API where clause

HubSpot EmailEvents API where clause

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