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

    API - How to return more than 100 submission records

    Asked by fastk8 on March 25, 2016 at 05:15 PM

    I have a form which I an using as part of a registration process. I have been using the API URL (https://api.jotform.com/form/yyyyyyyyyyy/submissions?apiKey=xxxxxxxxxxxxxxxx') to download a subset of the form data to confirm registration etc. and processing frequently enough I didn't notice any issues.

    I now need to go back and get all the data for all of the submissions, but it appears that there is a 100 record limit on the data that is being returned and I am unable to return all of the data using the same API

    Is there a limit to the numbers that can be returned through the API?

    Is there a way to return all of the submissions using APIs?

    Any help would be appreciated.

    Thanks.

     

  • Profile Image
    JotForm Support

    Answered by Mike on March 25, 2016 at 06:01 PM

    Thank you for contacting us.

    The limit can be set up to one thousand, please see the next link.

    http://api.jotform.com/docs/#form-id-submissions

    To illustrate this: 

    1) Show 1,000 form entries.

    http://api.jotform.com/form/{ID}/submissions?apikey={key}&limit=1000

    2) Show entries starting from 100.

    http://api.jotform.com/form/{ID}/submissions?apikey={key}&offset=99

    3) Show entries starting from 200.

    http://api.jotform.com/form/{ID}/submissions?apikey={key}&offset=199

    If you need any further assistance, please let us know.