Technology Blog Posts by SAP
cancel
Showing results for 
Search instead for 
Did you mean: 
marcus_behrens1
Product and Topic Expert
Product and Topic Expert
0 Likes
371
Pre-requisite is that postgres data storage option has been configured for your SAP Cloud Platform Internet of Things for the Cloud Foundry Environment instance.

You can find a URL like the following in the api hub but its not so easy to understand the filter syntax for the timestamp with the given help:
https://weather-station.eu10.cp.iot.sap/iot/core/api/v1/devices/18/measures?&skip=0&top=10

If you now want to check the values in measures for a specific time then here are 2 tips to make it work:

  1. filter=timestamp ge 1513144500 (this is the time in seconds) does not work as the time will be treated as milliseconds since EPOCH

  2. filter=timestamp ge 1513144500000 (this is the time in milliseconds) does not work as parsing of such a large integer fails

  3. filter=timestamp ge '1513144500000' does work!