How can I send Jotform data to an SQL server?

  • Profile Image
    JaBurgess
    Asked on October 12, 2017 at 04:20 PM

    I am trying to send any new submissions made with my forms to my own SQL server. A moderator offered these options to a user from an old post, please see them below. Are these the only options available to import this data from Jot form?


    "1. You can post the submission data to your own page by enabling the "Send Post Data" in your form preferences and then redirect to your own thank you page where you can read the submission data and save it in your SQL Server DB. The following guide should help you:  http://www.jotform.com/help/213-Send-POST-Data-From-JotForm-Using-PHP-in-Custom-Thank-You-Page 

    2. You can take advantage of our Zapier integration app as well. Take a look at here: http://apps.jotform.com/app/zapier_integration 

    You may also like to check this app which should help you achieve your requirement:  https://zapier.com/zapbook/jotform/sql-server/7564/save-jotform-submissions-to-sql-server/ 

    3. You can directly download the SQL file of your submissions and import them in your database. Please take a look at the following app:  http://apps.jotform.com/app/ms_sql_server_export "

  • Profile Image
    aubreybourke
    Answered on October 12, 2017 at 05:28 PM

    Yes that is a very good answer that was provided.


    Additionally you can see the SQL apps JotForm supports here:

    https://apps.jotform.com/search/sql

    You can use webhooks:

    https://www.jotform.com/help/248-Webhook-PHP-Script-Examples

    Or you can use PHP:

    https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP