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 ?