Are there API errors in submission endpoints?

  • breckyneckberg
    Asked on February 25, 2020 at 10:54 AM

    Hi! On 2/23 our api connection stopped working - specifically we're using the https://api.jotform.com/form/{form_id}/submissions endpoint, with filter:

    "filter": {

        "created_at:gt": "2020-02-17T00:00:00.000-6:00",

        "created_at:lt": "2020-02-23T23:59:59.000-6:00"

    }


    It will work if I remove the filter, but will not work for any values in created_at:gt or created_at:lt.


    Thanks!

  • John Support Team Lead
    Replied on February 25, 2020 at 12:33 PM

    Can you try with the following URL:

    https://api.jotform.com/form/{formID}/submissions?apikey={apiKey}&filter={"created_at:gt":"2020-02-17 00:00:00"}&{"created_at:lt":"2020-02-23 00:00:00"}&orderby=id

    I just tested this using the TRY IT OUT section in our API PAGE and by directly using the URL and it works as intended.