SAP Knowledge Base Article - Public

3254746 - Error when filtering double-type fields providing a value with comma/period character - Integration Center

Symptom

Double-type fields have floating values, for example field "fte" from EmpJob:

When you are creating a filter on such fields providing a floating value (containing a period/comma character in its value), the error below occurs in Integration Center:

"Server was unable to understand the URI of your OData API request, which contained the invalid character text sequence of: [[0], [.], [5]] . Please check the correctness of your query syntax, especially for unexpected whitespace or punctuation. For API syntax requirements consult
Code: BadRequestException
Status: Bad Request
Status Code: 400"

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite
    • Integration Center
    • OData API
      

Reproducing the Issue

  1. In "Filter and Sort" tab, select the double-type field
  2. Provide a floating value:



  3. Error occurs.

Resolution

Provide the floating value between single quote characters:

Keywords

quotes, single quotes, double, double type, double dash, invalid character.  , KBA , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , Problem

Product

SAP SuccessFactors HCM suite all versions

Attachments

Pasted image.png