SAP Knowledge Base Article - Public

2745638 - How to Query Odata With Filter Containing "+" Character

Symptom

You are filtering an Odata query with a value that contains "+", however the query is not filtering accordingly.

Environment

  • SAP Business ByDesign.
  • SAP Cloud for Customer.

Reproducing the Issue

You are using any filter in an Odata query that contains a "+". Example: $filter=Phone eq '+1 123-456-7890'

Cause

The character "+" is a reserved delimiter, so this will be omitted or replaced as a space in URI, hence "+" symbol cannot be used in $filter value.

Resolution

Instead you can use an equivalent encoded character for "+" which is "%2B". Example: $filter=Phone eq '%2B1 123-456-7890'

Keywords

odata; query; filter; +; , KBA , LOD-CRM-INT-API , OData API (C4C Only) , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions