EPiServer Forms Submissions - Database table

James Wilkinson

Vote:

Hello,

Does anybody know the database table that contains EPiServer Forms Submissions?

Thanks

#177441

Apr 11, 2017 16:10

Marija Jemuovic

Vote:

It's inside DDS - in tblBigTable:

SELECT * FROM tblBigTable
WHERE StoreName LIKE 'FormData_%'

BR,

Marija

#177451

Apr 12, 2017 9:21

Paul Gruffydd

Vote:

Just a note of caution - I'd avoid poking around in the database if you don't have to. I'd certainly avoid coding something against it as the structure of the database changes from time to time without warning so you may end up having trouble updating your Episerver solution if you go down that route.

That said, if you still want to access form data in the database, but don't fancy unpicking the structure of tblBigTable there are SQL views created for each of the forms, with names starting "VW_FormData_" followed by the GUID of the form.

#177475

Apr 12, 2017 14:32

James Wilkinson

Vote:

Thank you Paul and Marija. I wasn't aware it used the DDS and agree that directly peaking around the database wouldn't be good practice.

I've found a lower level method in the FormDataRepository called GetSubmissionData which I can use to hook into and expose the data for what I'm trying to acheive.

#177478

Apr 12, 2017 15:11

Marija Jemuovic

Vote:

Hi, James,

I didn't figure out you needed API-s, thought you just wanted a sneak peak in the DB :)

Anyways, you might find some inspiration here on Dejan's post for transforming the submissions to some more readable data.

#177479

Apr 12, 2017 15:29

Daniel Ovaska

Vote:

I also wrote a blog about encrypting data for forms. Not sure if it's still valid though :)

http://world.episerver.com/blogs/Daniel-Ovaska/Dates/2016/7/episerver-formsencrypting-submitted-data/

#177481

Apr 12, 2017 16:34