Connector Improvement: Add form submissions table for Hubspot
CompletedHi all,
I'd like to request that form submissions get added to the Hubspot connector via the `get_submissions_for_a_form` endpoint. This is different than the current `contact_form_submissions` endpoint in that it provides the form fill values as well. There is a previously opened request here, but it seems to have been marked as completed. Here is an example response from the proposed table:
"results": [
{
"submittedAt": 1547130102576,
"values": [
{
"name": "email",
"value": "example@example.com"
},
{
"name": "company",
"value": "Example Co"
},
{
"name": "phone",
"value": "123 555 4567"
}
],
"pageUrl": "https://www.example.com/form"
},
The form ID from the request parameters could be used to persist into the resulting table, enabling a join to the existing `form` table. Then, the end user could join to `contacts` based on email and essentially recreate the `contact_form_submission` table, but with the form submit values.
Thanks,
Brandon
-
Official comment
I'm pleased to announce we now support this - see our July release notes
Best regards - Alison
-
Hi Brandon, Drew from the Product Team here!
Thanks for this suggestion! Just to confirm, you are seeing the association table CONTACT_FORM_SUBMISSION, but not the actual data for FORM_SUBMISSION?
I'm putting this in the backlog for now, but I'll make sure we evaluate it for inclusion in an upcoming quarter.
-
Has this item moved up on the backlog yet?
-
Our organization is also looking for Fivetran to add a `FORM_SUBMISSION` table.
Please sign in to leave a comment.
Comments
4 comments