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

  • SKGroup
    Asked on March 3, 2017 at 4:21 AM
    Is there anyway i can call the data directly from the db where the data is being stored on. Please advice. 
  • Support_Management Jotform Support
    Replied on March 3, 2017 at 4: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