SAP Knowledge Base Article - Public

3155617 - Error : 'Invalid parametertype used at function 'eq'

Symptom

You have received a error, 'Invalid parametertype used at function 'eq' while executing a Odata Query

Environment

SAP Cloud for Customer

Reproducing the Issue

  • Execute the below URL in your browser or Odata Console :
    • https://myXXXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ContactCollection?$filter=EmailInvalidIndicator eq 'false'
    • Where XXXXXX is the tenant ID.
  • You will get the the error, Invalid parametertype used at function 'eq'.

Cause

You are trying to filter a Boolean Value. In case of Boolean fields, it is not necessary to use ''.

Resolution

The Correct URL is as below :

https://myXXXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ContactCollection?$filter=EmailInvalidIndicator eq false

Keywords

Odata, Filter , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem

Product

SAP Cloud for Customer core applications all versions