-
Dev Jigneshbhai KansaraAsked 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...... -
Christopher JotForm SupportReplied 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.
Please refer to the guide on how to retrieve submission ID.
-
kansaradev8pReplied 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"
-
Christopher JotForm SupportReplied 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 }.
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.