SAP Knowledge Base Article - Public

3472253 - 1H 2024: SCIM API error "The filter expression is invalid" Capital 'AND' or 'OR'

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

Product

SAP SuccessFactors HCM suite all versions