Symptom
You notice the following error SCIM API when the filter expression e.g. "AND" or "OR" is in capital letters.
e.g.
https://[api endpoint]/rest/iam/scim/v2/Users?startId=initial&count=100&filter=userType eq "ONBOARDEE" OR userType eq "EMPLOYEE" AND active eq "true"
Sample error message:
The filter expression is invalid.userType eq \"ONBOARDEE\" OR userType eq \"EMPLOYEE\" AND active eq \"true\"","status":400
Environment
SAP SuccessFactors SCIM API
Cause
Known error. The issue was introduced with 1H 2024 release as part of our continuous effort to improve SCIM API (in particular, the introduction of ANTLR4 via our internal reference PLA-43218)
Resolution
Please use small case in the filter expression ("and" or "or") and the error will be resolved.
Our Engineering team are currently working on a permanent solution to allow both capital and small case in filter expressions, the ETA is 2H 2024 although this date is subject to change (our internal reference PLA-46920)
Keywords
PLA-46920, PLA-43218, ANTLR4, "The filter expression is invalid", SCIM, SCIM API, eq "ONBOARDEE" OR userType eq "EMPLOYEE" AND active eq "true", The filter expression is invalid.userType eq \"ONBOARDEE\" OR userType eq \"EMPLOYEE\" AND active eq \"true\"","status":400, /rest/iam/scim/v2/Users?startId=initial&count=100&filter=(userType%20eq%20%22ONBOARDEE%22%20and%20active%20eq%20true)%20OR%20(userType%20eq%20%22EMPLOYEE%22%20and%20active%20eq%20true) , {"schemas":["urn:ietf:params:scim:api:messages:2.0:Error"],"scimType":"invalidFilter","detail":"The filter expression is invalid.userType eq \"ONBOARDEE\" OR userType eq \"EMPLOYEE\" AND active eq \"true\"","status":400} , KI2405, 1H 2024, 2405, KEA, Known Error, known issue, bug, error, fix, defect, release, production, preview, H1 , KBA , LOD-SF-INT-API , API & Adhoc API Framework , BC-IAM-IPS , Identity Provisioning Service (IPS) , Known Error