Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • naphong saebae 25 posts 135 karma points
    Oct 10, 2022 @ 05:29
    naphong saebae
    0

    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.

  • Roy Berris 89 posts 577 karma points c-trib
    Oct 10, 2022 @ 13:52
    Roy Berris
    100

    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.

    https://our.umbraco.com/documentation/Add-ons/umbracoforms/developer/working-with-data/

  • naphong saebae 25 posts 135 karma points
    Oct 10, 2022 @ 16:18
    naphong saebae
    0

    I can retrieve data already. Thank you so much for your support. So fast for reply! much appreciate.

Please Sign in or register to post replies

Write your reply to:

Draft