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

  • Profile Image
    Dev Jigneshbhai Kansara 
    Asked on January 03, 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.png

    Screenshot
  • Profile Image
    Christopher_T
    Answered on January 03, 2022 at 02: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_

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

    Guide: Where to Find the Submission ID?

  • Profile Image
    Christopher_T
    Answered on January 05, 2022 at 02: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.