SAP Knowledge Base Article - Public

2573695 - org.apache.olingo.odata2.api.uri.UriSyntaxException: Invalid filter expression


Error in HCI

org.apache.olingo.odata2.api.uri.UriSyntaxException: Invalid filter expression: 'lastModifiedDateTime ge datetime'2017-11-28T00:00:00''., cause: org.apache.olingo.odata2.api.uri.expression.ExpressionParserException: Operator "ge" incompatible with operand types "Edm.DateTimeOffset" and "Edm.DateTime" at position 22 in "lastModifiedDateTime ge datetime'2017-11-28T00:00:00'"

while executing an ODATA Query with filter lastModifiedDateTime ge datetime'2017-11-28T00:00:00


SAP Cloud Platform Integration


  • This error occurs when there is a mismatch in the Type (datetimeoffset, datetime, etc) of the data that is being used in the operand in the comparison operator for the entity


  1. Go to ODATA API Data Dictionary
  2. Search for the entity for which the ODATA query is getting executed
  3. Search for the field for which the error is coming in HCI
  4. Check the Type for that field
  5. Correct the query with the Type that you have found in step no 4.


  • HCI
  • org.apache.olingo.odata2.api.uri.UriSyntaxException: Invalid filter expression
  • org.apache.olingo.odata2.api.uri.expression.ExpressionParserException
, KBA , failed to invoke method: , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-HCI , Standard SF to 3rd Party CPI (HCI) Content , Problem


SAP SuccessFactors HCM Core 1708