-
creswellcaseyAsked on June 5, 2017 at 3: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.
-
CharlieReplied on June 5, 2017 at 4: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.