Problem using Search API to get list of complete forms
I am trying to get a list of completed forms but having no luck.
When I do a GET on a form I see "status": "Completed". When I SEARCH for completed forms using the below request I get no results.
https://api.icims.com/customers/****/search/forms?searchJson={"filters": [{"name": "formdata.form.formname","value": ["federal_w4_stv"]},{"name":"formdata.formstatus","value":["Completed"],"operator":"="}]}
If I change the operator to !=, I get forms with "status": "Completed".
Anyone have any ideas on what I might be doing wrong?
What is the value "30" in
What is the value "30" in this {name":"formdata.formstatus","value":["30"],"operator":"="}. I've tried a similar query but with value = "Completed" but it doesn't work. I want to understand why 30 is working. Is that the id of the status value? I can't find any documentation on it. Thanks
This should help:
Call Type: POST
https://api.icims.com/customers/7610/search/forms
Payload
{"filters":[{"name":"formdata.formstatus","value":["30"],"operator":"="},{"name":"formdata.formid","value":["2146"],"operator":"="}],"operator":"&"}
Results (Truncated):
{
"searchResults": [
{
"self": "https://api.icims.com/customers/7610/forms/796",
"id": 796
}
,
{
"self": "https://api.icims.com/customers/7610/forms/822",
"id": 822
}
,
{
"self": "https://api.icims.com/customers/7610/forms/843",
"id": 843
}
,
{
"self": "https://api.icims.com/customers/7610/forms/871",
"id": 871
}
,
{
"self": "https://api.icims.com/customers/7610/forms/898",
"id": 898
}
,
{
"self": "https://api.icims.com/customers/7610/forms/918",
"id": 918
}
Call Type: GET (to retrieve specific information on who filled out the form)
https://api.icims.com/customers/7610/forms/796
Results (Employee Names HIDDEN for forum/company privacy):
{
"owner":
{
"profile": "https://api.icims.com/customers/7610/people/24952",
"id": 24952,
"value": "HIDDEN"
}
,
"updatedby":
{
"profile": "https://api.icims.com/customers/7610/people/24952",
"id": 24952,
"value": "HIDDEN"
}
,
"formname": "federal_w4_stv",
"updateddate": "2017-01-12 12:53 AM",
"links": [
{
"rel": "self",
"title": "the current form being viewed.",
"url": "https://api.icims.com/customers/7610/forms/796"
}
,
{
"rel": "formAbout",
"title": "the profile this Form is owned by.",
"url": "https://api.icims.com/customers/7610/people/24952"
}
],
"completeddate": "2017-01-12 12:53 AM",
"completedby":
{
"profile": "https://api.icims.com/customers/7610/people/24952",
"id": 24952,
"value": "HIDDEN"
}
,
"status": "Completed"
}