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

  • SpottedPaint
    Asked on January 17, 2020 at 6: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?

  • Kevin Support Team Lead
    Replied on January 17, 2020 at 9: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.

  • SpottedPaint
    Replied on January 17, 2020 at 10:53 AM

    Thanks, I'll email them.