@sanchid you are right, the table does not contain the details of the form submission. I double checked in our BigQuery database (see printscreen below). Pretty sure we could do this in the past with Fivetran though. I believe it might be related to the switch to the new HubsSpot API.
You would need the legacy API endpoint to capture the details of form submissions as @TomM2 refered to: https://legacydocs.hubspot.com/docs/methods/forms/get-submissions-for-a-form
If you prefer to use an ETL solution, Airbyte should be able to capture this data according to their documentation for HubSpot.
Hope this helps!
Best regards,
Jonas De Mets
HubSpot Revenue Operations & Co-Founder @ Koalify
Did my answer help? Please “mark as a solution” to help the community.
