SAP Knowledge Base Article - Public

3484664 - Unable To Filter a Phone Number in OData Endpoint


It is possible to see that fields such as "NormalisedPhone" and "NormalisedMobile" are filterable=true, however, when performing a GET call using these fields as filter like the below example, no results are returned:$filter=NormalisedPhone eq '+123456789'

or$filter=NormalisedPhone eq '123456789'


SAP Cloud for Customer


The special character "+" needs to be encoded as "%2B" for it to be considered.


Perform the same GET call but swap + for %2B, example:$filter=NormalisedPhone eq '%2B123456789'

This should correctly return results.

See Also

2330688 - How to Use Methods And Filters in OData Services


Fone; Telephone; Odata; mobile phone; area; code;  , KBA , LOD-CRM-INT-API , OData API (C4C Only) , How To


SAP Cloud for Customer core applications 2405