How can i pass filter for getting submission data of my form id "3187" using curl API (Postman)

  • Dev Jigneshbhai Kansara
    Asked on January 3, 2022 at 12:53 PM

    Help me to get all submissions who's id greater than 3197.
    I also tried for {"id:gt":"3197"} but it's not working :(
    Please send Postman screenshot if possible.
    Thanks in advance......

    1641232148 61d33714866b0 issue Screenshot 10

    Jotform Thread 3635360 Screenshot
  • Christopher JotForm Support
    Replied on January 3, 2022 at 2:09 PM

    Please take note that submission ID is longer than a 4 digit number. Please use the complete submission ID when using filter as shown in the image from the API documentation.

    1641236954 61d349db00e45  Screenshot 10

    Please refer to the guide on how to retrieve submission ID.

    Guide: Where to Find the Submission ID?

  • kansaradev8p
    Replied on January 5, 2022 at 12:18 PM

    In above FAQ I mentioned test submission id, but I also tried with

     {"id:gt":"31974353596870"}

    but it gives me all data instead of data who's id > 31974353596870

    and I think I used curl method so I have to pass Encoded filter data format but I also tried that is also not working.


    curl -X GET "https://api.jotform.com/form/{form}/submissions?apiKey={apiKey}&filter=%7B%22id%3Agt%22%3A%2251695604124984990750%22%7D"

    1641403813 61d5d5a53f82c issue1 Screenshot 10

  • Christopher JotForm Support
    Replied on January 5, 2022 at 2:25 PM

    I have reviewed the URL that you are using for GET and it seems that it is incorrect. You have currently included curly bracket for the filter. It should be filter=31974353596870 not filter={31974353596870}.

    In the URL you have provided there is %7B which is equivalent to { while %7D is equivalent to }.

    curl -X GET "https://api.jotform.com/form/{form}/submissions?apiKey={apiKey}&filter=%7B%22id%3Agt%22%3A%2251695604124984990750%22%7D"

    The correct URL should be:

    curl -X GET "https://api.jotform.com/form/{form}/submissions?apiKey={apiKey}&filter=%22id%3Agt%22%3A%2251695604124984990750%22"

    Please try the URL that I have provided and let us know how it goes.