How to create filter using answers field using API?

  • Profile Image
    creswellcasey
    Asked on June 05, 2017 at 03:42 AM

    Hello,

     

    I am trying to filter the submissions of a form using form's answer whose Id is 77.

    What key should I use? right now i used answers_77_answer:eq

     

    var client = new JotForm.APIClient(Helpers.EnvironmentVariables.JotFromApikey);

    Dictionary<String, String> submissionFilter = new Dictionary<string, string>();

     submissionFilter.Add("answers_77_answer:eq", Orderreq.SubmissionId);

    var submissions = client.getFormSubmissons(formID: Convert.ToInt64(jotformMenuId),filter: submissionFilter)["content"];

     

    I am getting all data. Filter is not working.

                

  • Profile Image
    Charlie
    Answered on June 05, 2017 at 04:44 AM

    Hi,

    I presume you are using JotForm's API to fetch the submission and filter them? We have a separate forum page and contact for this types of concern. Please post your question in our developer's forum page here: https://developers.jotform.com/forum. You can also email our API team at api@jotform.com

    I'm also not familiar with the language you are using, but I see that in this API page section: http://api.jotform.com/docs/#form-id-submissions. There's an option to set a filter. 

    However, it seems like you can only filter submission ID, creation date and last update date, it was mentioned in this forum post: https://developers.jotform.com/forum/post/55b52d7e52ef185263000253. Although it was dated 2 years ago. It's best to confirm this with the API team. 

    Another possible way is to fetch all the submissions using the general API call and create a function or method to filter from that list.

    I hope that helps.