Skip to Content
0
Former Member
Feb 02, 2016 at 02:03 PM

IoT built-in OData API datetime filter not working

62 Views

I am using the builtin OData API from the IoT MMS services and datetime filtering is not working.

I tried this request :

https://<host>/com.sap.iotservices.mms/v1/api/http/app.svc/MY_TABLE?$filter=MY_COLUMN gt datetime'2016-01-01T00:00:00'


and I get the following error: Requested entity could not be found


<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<code></code>
<message xml:lang="en-US">Requested entity could not be found.</message>
</error>

I know that the column and table exist, and that the column is of type datetime.I can also filter by any other column (of other types, like string) and it works, so the filter syntax should be good.

Is the filtering of datetime not supported by the builtin OData API ?