fill out form details history

Question

Hi All we have a contact us form on one of our sites and I am looking for a way to get to the activity log history for a specific form element. The issue that arose is that the people that were receiving the email alerts that were triggered when the form was filled out are no longer with the company so for the past 6 months that team was unaware of the queries and requests that were coming in from the site's form. I have created a smart list for who filled out the form and have a list of the people who submitted the form but it seems we need to manually look at each person record to view the actual history of the details of the form submit. We have it set up that we clear the form element after the email alert is sent as we reuse this form element in other forms.
 
Is the a way to get the form submit detail other than this manual way? Maybe through an API pull?
 
thanks,
Kevin.

SanfordWhiteman · Accepted Answer

Is the a way to get the form submit detail other than this manual way? Maybe through an API pull?You can pull all Filled Out Form activities (going back 2 years) using the API, yes.

Darshil_Shah1 · Answer

Yes, that's possible! You can pull the filled out form activities using the Activities API (regular/bulk). I think bulk would be a better choice here especially if you have had a lot of form fills.

Use the filled out form activity's Activity ID in your GET call. You could get the Activity ID from the Describe Activities GET endpoint. The response would include the form submit date stamp and the data that was posted by the person.

Below is the JSON of the data that is included in the Fill out Form activity when pulled via API:

{
            "id": 2,
            "name": "Fill Out Form",
            "description": "User fills out and submits a form on web page",
            "primaryAttribute": {
                "name": "Webform ID",
                "dataType": "integer"
            },
            "attributes": [
                {
                    "name": "CAPTCHA Normalized Score",
                    "dataType": "string"
                },
                {
                    "name": "CAPTCHA Provider",
                    "dataType": "string"
                },
                {
                    "name": "CAPTCHA Raw Score",
                    "dataType": "float"
                },
                {
                    "name": "Client IP Address",
                    "dataType": "string"
                },
                {
                    "name": "Form Fields",
                    "dataType": "text"
                },
                {
                    "name": "Program Name",
                    "dataType": "string"
                },
                {
                    "name": "Program Type",
                    "dataType": "string"
                },
                {
                    "name": "Query Parameters",
                    "dataType": "string"
                },
                {
                    "name": "Referrer URL",
                    "dataType": "string"
                },
                {
                    "name": "User Agent",
                    "dataType": "string"
                },
                {
                    "name": "Webpage ID",
                    "dataType": "integer"
                }
            ]
        }

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded