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
- In "Filter and Sort" tab, select the double-type field
- Provide a floating value:
- 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
Attachments
Pasted image.png |