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,
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)