What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Is there anyway i can call the data directly from the db where the data is being stored on

    Asked by SKGroup on March 03, 2017 at 04:21 AM
    Is there anyway i can call the data directly from the db where the data is being stored on. Please advice. 
  • Profile Image
    JotForm Support

    Answered by Jim_R on March 03, 2017 at 04:59 AM

    There's a way to achieve this using our API but you'd have to figure out yourself how you would parse the data once you get it. Meaning, the logic and function after getting the submission(s) will be done by you (or your developer if you have one).

    GET /form/{form-id}/submissions

    https://api.jotform.com/docs/#form-id 

    - Fetches all submissions at once

    Example: https://api.jotform.com/form/{formID}/submissions?apiKey={apiKey}

    GET /submission/{submission-id}

    https://api.jotform.com/docs/#submission-id 

    - Only fetches 1 submission at a time

    Example: https://api.jotform.com/submission/{submissionID}?apiKey={apiKey}

    It's worth mentioning that there are other ways of exporting your submission data aside from using the API. You may use reports, or export them to XLS/CSV. It all depends on how you want to utilize them:

    REPORTS (the guide below showcases lots of different reports)

    How-To-Create-Form-Reports-in-JotForm

    XLS/CSV

    How-to-Download-Form-Submissions-as-Excel-CSV-PDF