API - How to return more than 100 submission records

  • Profile Image
    fastk8
    Asked 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
    Mike
    Answered 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.