How to integrate Jotform API to SQL database?

  • Profile Image
    spectra279
    Asked on August 27, 2019 at 07:20 AM
    Hi
     
    We are planing to use your API to download the form submissions to our SQL database. We have some issues ;
     
    1. How we can download only the new records which we have not downloaded yet. We don't want to have duplicates. We have no way to query for new records only. 
    2. Is there way to download the recods as bulk instead one by one?
     
    Thanks
  • Profile Image
    AshtonP
    Answered on August 27, 2019 at 08:11 AM

     

    There are different approach by which you can integrate your jotform submissions data with MySQL database.

    One option is that you can send the submissions to your MySQL database using PHP. There is a configuration in step number 4 of the document below that won't allow duplicate records to upload to your database. Here is the document that will guide you for step by step configuration: How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.

    The other option you can use to integrate to your MySQL database is using Zapier. This guide will give you detailed information for on how to configure the same: https://zapier.com/apps/jotform/integrations/mysql

     

    For your second query to download the records in bulk, are you referring to submissions? If yes, then just access your form submissions page (https://www.jotform.com/help/269-How-to-view-Submissions).

    From there, you should see the "Download All Uploads" button. Click it to download the files in your format once:

     

    Please correct me if you are looking for something else or if you have any further questions on this.