Connector Improvement: Inclusion of Form Table into Pardot Connector
CompletedWe have a customer inquiring about the inclusion of the Form table within the Pardot connector. Presently, the Pardot connector's API version 3 supports data extraction from this table. However, the current design of the connector does not incorporate this table in the schema ERD. We kindly request your assistance in addressing this matter and enabling the customer to utilize this data seamlessly at their destination via the Pardot connector.
-
Official comment
Hi all,
Thanks for following along on this feature request and helping us improve the connector.We added several new tables related to Pardot forms to our connector in July 2025. You can find more info in our release notes here: https://fivetran.com/docs/connectors/applications/pardot/changelog#july2025.
I'm marking this feature request as completed.
Cheers,
Luke -
Hi,
Thanks for submitting this feature request.
What is the use case for this data? The V3 and V4 Pardot APIs provide a few basic fields for Forms. With V5, Salesforce added Form Fields, Form Handlers, and Form Handlers Fields. However, it doesn't seem like these endpoints are particularly useful. The data entered in forms is already included in the VISTORY_ACTIVITY table in our schema. These new endpoints only provide a list of the metadata for each form (see below).
Please let me know if this serves the use case. Any additional detail you can provide about the use case will help us determine the priority of this request.
Thanks,
Luke{
"id": 34,
"createdAt": "2023-07-17T17:25:48-04:00",
"form": {
"campaignId": 1,
"name": "Standard Form",
"thankYouContent": "<p>Thank you for filling out the form. We will get back to you shortly.</p>"
},
"formId": 1,
"label": "First Name",
"prospectApiFieldId": "firstName"
"progressives": [
{
"prospectApiFieldId": "email"
},
{
"prospectApiFieldId": "lastName"
}
]
} -
We too are interested in Forms, Form Fields, Form Handlers and Form Handler fields. For our use case, it is okay to get these objects and not the actual data entered by the user as we are trying to understand which forms are driving leads.
-
Hi Navan,
Thanks for providing that context. I've added this to our backlog. We'll start development once we complete the rollout of the V5 endpoints to all Pardot connections. I expect to start rolling this out in about a month. I can reach out once it's ready for testing if you'd like early access, let me know.
Cheers,
Luke
Please sign in to leave a comment.
Comments
4 comments