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