API filter to Pull candidates from iCIMS



Hi,

I am working on an integration with iCIMS to pull candidates moved to one of the below dispositioned statuses and also type of hire = 'professional' and Country is not China.

I am using the below API and filter, however this is not returning the expected results. Please suggest the correct filter.

Below are Statuses we need to pull

TA Reviewed: Not Selected 14660

HM Reviewed: Not Selected14661

HM Interviewed: Not Selected2038

Pre-Offer Screening Do Not Proceed2037

Offer Accepted2036

Offer Declined/Rejected10025

POST: https://api.icims.com/customers/13241/search/applicantworkflows?fields=baseprofile,associatedprofile,status,proposedstartdate,field48756,field48757,proposedstartdate

 

BODY: 

{

"filters": [

{"name":"applicantworkflow.job.customfield2027.listnode",

"value":["C47140"],

"operator":"="},

{"name":"applicantworkflow.job.joblocation.addresscountry",

"value":["D41046"],

"operator": "!="

},

{"name":"applicantworkflow.person.folder",

"value": ["D32013","D32011"],

"operator": "!="

}

],

"operator": "&",

"children": [

{

"filters": [

{

"name": "applicantworkflow.lastinstatus14660",

"value": ["2024-01-09 12:00 AM"],

"operator": "="

},

{

"name": "applicantworkflow.lastinstatus14661",

"value": ["2024-01-09 12:00 AM"],

"operator": "="

},

{

"name": "applicantworkflow.lastinstatus2038",

"value": ["2024-01-09 12:00 AM"],

"operator": "="

},

{

"name": "applicantworkflow.lastinstatus2037",

"value": ["2024-01-09 12:00 AM"],

"operator": "="

},

{

"name": "applicantworkflow.lastinstatus2036",

"value": ["2024-01-09 12:00 AM"],

"operator": "="

},

{

"name": "applicantworkflow.lastinstatus2035",

"value": ["2024-01-09 12:00 AM"],

"operator": "="

}

],

"operator": "|"

}

]

}

 

Product