Does anybody know the database table that contains EPiServer Forms Submissions?
It's inside DDS - in tblBigTable:
SELECT * FROM tblBigTable
WHERE StoreName LIKE 'FormData_%'
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.
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.
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.
I also wrote a blog about encrypting data for forms. Not sure if it's still valid though :)