SAP Knowledge Base Article - Public

2827587 - Error : Invalid type for '$filter' system query option. Expected type is 'Edm.Boolean'

Symptom

You are trying to execute filter Query in a batch request. But, the system gives the above mentioned error.

Environment

SAP Cloud for Customer

Reproducing the Issue

Execute the below Query in a batch request.

Header Details :

Method - Post

Url:https://myXXXXXX.c4c.saphybriscloud.cn/sap/c4c/odata/cust/v1/deliverappt/$batch

Body :

--batch_guid_01
Content-Type: application/http
Content-Transfer-Encoding:binary

GET BO_DeliverApptRootCollection?$filter=AccompanyEmployee eq'XXX' HTTP/1.1

--batch_guid_01
Content-Type: application/http
Content-Transfer-Encoding:binary

GET BO_DeliverApptRootCollection?$format=json HTTP/1.1

--batch_guid_01--

Response:

{"error":{"code":"","message":{"lang":"en","value":"Invalid type for '$filter' system query option. Expected type is 'Edm.Boolean'"}}}

Cause

In Batch Request, Filter Query should be in the Encoded form UTF-8. Otherwise, System could not interpret it.

Resolution

Encode the Filter Query as below :

Before Encoding :

GET BO_DeliverApptRootCollection?$filter=AccompanyEmployee eq'XXX' HTTP/1.1

After Encoding :

GET BO_DeliverApptRootCollection?$filter%3DAccompanyEmployeeeq%27XXX%27 HTTP/1.1

Corrected Batch Query :

--batch_guid_01
Content-Type: application/http
Content-Transfer-Encoding:binary

GET BO_DeliverApptRootCollection?$filter%3DAccompanyEmployeeeq%27XXX%27 HTTP/1.1

--batch_guid_01
Content-Type: application/http
Content-Transfer-Encoding:binary

GET BO_DeliverApptRootCollection?$format=json HTTP/1.1

--batch_guid_01--

Note :

Only the Filter Part has to be Encoded to the format UTF-8.

Keywords

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

Product

SAP Cloud for Customer core applications 1.0 ; SAP Cloud for Customer core applications 1.5 ; SAP Cloud for Customer core applications 1305 ; SAP Cloud for Customer core applications 1308 ; SAP Cloud for Customer core applications 1311 ; SAP Cloud for Customer core applications 1402 ; SAP Cloud for Customer core applications 1405 ; SAP Cloud for Customer core applications 1408 ; SAP Cloud for Customer core applications 1411 ; SAP Cloud for Customer core applications 1502 ; SAP Cloud for Customer core applications 1505 ; SAP Cloud for Customer core applications 1508 ; SAP Cloud for Customer core applications 1511 ; SAP Cloud for Customer core applications 1602 ; SAP Cloud for Customer core applications 1605 ; SAP Cloud for Customer core applications 1608 ; SAP Cloud for Customer core applications 1611 ; SAP Cloud for Customer core applications 1702 ; SAP Cloud for Customer core applications 1705 ; SAP Cloud for Customer core applications 1708 ; SAP Cloud for Customer core applications 1711 ; SAP Cloud for Customer core applications 1802 ; SAP Cloud for Customer core applications 1805 ; SAP Cloud for Customer core applications 1808 ; SAP Cloud for Customer core applications 1811 ; SAP Cloud for Customer core applications 1902 ; SAP Cloud for Customer core applications 1905 ; SAP Cloud for Customer core applications 1908 ; SAP Cloud for Customer core applications 1911 ; SAP Cloud for Customer core applications 2002 ; SAP Cloud for Customer core applications 2005 ; SAP Cloud for Customer core applications 2008 ; SAP Cloud for Customer core applications 2011 ; SAP Cloud for Customer core applications 2102 ; SAP Cloud for Customer core applications 2105 ; SAP Cloud for Customer core applications 2108 ; SAP Cloud for Customer core applications 2111 ; SAP Cloud for Customer core applications 2202 ; SAP Cloud for Customer core applications 2205 ; SAP Cloud for Customer core applications 2208 ; SAP Cloud for Customer core applications 2211 ; SAP Cloud for Customer core applications 2302 ; SAP Cloud for Customer core applications 2305 ; SAP Cloud for Customer core applications 2308 ; SAP Cloud for Customer core applications 2311 ; SAP Cloud for Customer core applications 2402 ; SAP Cloud for Customer core applications 2405 ; SAP Cloud for Customer, core applications 2.0