SAP Knowledge Base Article - Preview

2772208 - OData API filter value selected in API Request is always case sensitive

Symptom

OData API filter value which you are selecting for $FILTER parameter is always case sensitive.

Example: There is a USER in your SFSF System: "Aanya Singh".

Use Cases:

1.  Expected Data in Response:

 /odata/v2/User?$select=userId,firstName,lastName,username&$filter=(firstName eq 'Aanya' and lastName eq 'Singh')

 /odata/v2/User?$select=userId,firstName,lastName,username&$filter=firstName eq 'Aanya

2. No Data in Response:

/odata/v2/User?$select=userId,firstName,lastName,username&$filter=(firstName eq 'aanya' and lastName eq 'Singh')

/odata/v2/User?$select=userId,firstName,lastName,username&$filter=firstName eq 'aanya'

 


Read more...

Environment

SAP SuccessFactors

Product

SAP SuccessFactors HCM Core all versions

Keywords

Case Sensitive, Lower Case, Upper Case, ODATA API , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.