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

  • Profile Image
    SKGroup
    Asked 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
    Jim_R
    Answered 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