Is it possible to filter form submissions by value of answer in API?

  • Profile Image
    SpottedPaint
    Asked on January 17, 2020 at 06:55 AM

    I want to do something like filter={name[first]:"Trevor"}

    and find all the form submissions that have Trevor as the first name.

    I'm doing curl "https://eu-api.jotform.com/user/submissions?filter=filter%3D%7Bname%5Bfirst%5D%3A%22Trevor%22%7D&orderby=id"  | python -m json.tool and getting all submissions. Is what I'm attempting possible using your API.

    The documentation https://api.jotform.com/docs/#user-submissions seems to feature examples that are filtering submissions by the form meta information rather than the content of the answers?

  • Profile Image
    Kevin_G
    Answered on January 17, 2020 at 09:05 AM

    I've been performing some tests and was indeed unable to get the submissions filtered by answers. I would however recommend you to kindly contact our API team so you can get more further assistance on this matter from that team, here is the email where you can contact them: api@jotform.com

    Thanks.

  • Profile Image
    SpottedPaint
    Answered on January 17, 2020 at 10:53 AM

    Thanks, I'll email them.