Historical form-submission data available via API?

forms

#1

I’m trying to get all historical form submission data in order to do more specific analysis of advertising spend. We have set up our forms so that utm_campaign, utm_source, etc. are submitted as fields along with the form submission.

In the cases that the form submission causes the fields utm_campaign, utm_source, etc. to be updated on the Contact, I can inspect the Contact’s field history and get the value from the form submission. So on a go-forward basis I can erase the Contact field values after every form submission to force an update to show up in the field history. However, if the form submission did NOT update the field on a prior submission (which was the case if the same contact came through via the same PPC campaign a couple times, which did happen fairly often) then I can’t know whether the field had a value or was blank on the previous form submission data.

Hubspot does have the raw form submission data in its DB. You can get at all the historical Form Submission data via the Huspot App. The URL pattern is: https://app.hubspot.com/forms-two/HUBID/FORM-GUID/submissions/CONVERSION-ID
However, I can’t see a way to get this same data programmatically. It feels like there’s a good chance since the data is available via the UI.

Related thread:


#2

Hi @robgonzalez,

There isn’t currently any public API for retrieving form submission data. You can export form submission data into a CSV, however, which would give you programatic access to the data. If you have the inclination, I would encourage you to check out the Ideas Forum on the HubSpot Community. There, you can create a post including your use case that product and other customers can see.


#3

@Derek_Gervais thanks for the reply! Where do I go to export the CSV of the form submission data?

On a go-forward basis we’ve configured a Hubspot Workflow to clear the field values right after the form submission, which will have the effect of forcing the inclusion of any new values submitted via forms to show up in the field history of the Contact.


#4

Hi @robgonzalez,

You can export the form submission data from the forms dashboard: