Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

Episerver Forms - how to query the database

Vote:
 

So we built a form using Episerver forms.    I know it has a CSV export there.    The client wants to automate the processing of these forms outside of episerver by directly querying the sql database to get new records for the day.  

Can you give us some insight into what tables + queries I should be looking at?    I looked in the tblXFormData table but it was blank.   

What db queries do I need to do to recreate the CSV export?   Thanks,

#227839
Sep 14, 2020 15:03
Vote:
 

Hi,

I think you should gather the information using the repository service IFormDataRepository (so you would programmatically read different forms data and do what you like with that data, push it to external system etc). See this thread: https://world.episerver.com/forum/developer-forum/-Episerver-75-CMS/Thread-Container/2017/5/programetically-getting-episerver--forms--submitted-data/

But then again it sounds that "Episerver" is just internediate storage for the submissions, so why not then use an actor or implement your own actor that pushes the submitted form data to the external system (it sounds like there is another system where this form data is needed?).

So if actors is the way, then see the documentation: https://world.episerver.com/documentation/developer-guides/forms/implementing-a-customized-actor/

(most likely that tblXFormData is the old EPiServer.XForms table, the new Episerver Forms is the "new kid" in town, well been that already for quite some time :D)

#227841
Sep 14, 2020 15:41
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.