I don't think it is a good idea to query the forms database without Umbraco but ofcourse you can. If you open your database in SQL Server Management studio you will find the forms tables that start with UF. The UFRecords have the individual entries. In the RecordData column is the submitted data in JSON format.
Better option is to use the IRecordReaderService where you can get records by Form ID. And expose this through an (authorized) API.
How to retrieve entries data from Umbraco Forms via sql?
How to retrieve entries data from Umbraco Forms via sql? or who has database schema with umbraco form?
Thanks for your advance.
I don't think it is a good idea to query the forms database without Umbraco but ofcourse you can. If you open your database in SQL Server Management studio you will find the forms tables that start with
UF
. TheUFRecords
have the individual entries. In theRecordData
column is the submitted data in JSON format.Better option is to use the
IRecordReaderService
where you can get records by Form ID. And expose this through an (authorized) API.https://our.umbraco.com/documentation/Add-ons/umbracoforms/developer/working-with-data/
I can retrieve data already. Thank you so much for your support. So fast for reply! much appreciate.
is working on a reply...