Event Attendance query not pulling any information

  • 132Views
  • Last Post 25 September 2019
Melissa Wright posted this 24 September 2019


I'm using the query below to try and pull a raw file of attendees at an event we hosted earlier this month. This same query has worked fine for me in the past, but when I run it, I'm not getting any information (i.e., query finishes running and there is nothing listed in the raw data panel or the CSV file I export). I see the event was indeed logged in HubSpot as happening on 9/18/19. Could someone please review the query and let me know if I'm doing something wrong or if something has changed? Best, Melissa


SELECT c."First Name" as "FirstName", c."Last Name" as "LastName",c."Email" as "email", 

       e."timestamp"  as "Activity Date", e."Metadata_Body" as "Meeting Body"

FROM Contacts AS c, Engagements AS e

     INNER JOIN Engagements ON e.Associations_ContactIds like ('%' || c.Id || '%') 

WHERE  e.timestamp >='09/18/2019 00:00:00'

      AND e.timestamp <='09/18/2019 23:59:59'

      AND e.Type in ('Meeting')

      And e.activityType = 'University-Wide Event (e.g., Symposium)'

GROUP by c."First Name" , c."Last Name",c."Email", e."timestamp", e."Metadata_Body" 

ORDER BY c."First Name" , c."Last Name"

Dmitriy Muzurov posted this 25 September 2019

Hello Melissa,

Thank you for submitting a ticket with us.

We have tested the query on our side and it is working.

Please make sure the requested data corresponds to all specified conditions in your HubSpot account.

Should you have any questions, do not hesitate to contact us back.