IoT Application Enablement stores its data in a hot, warm and coldstore. If raw data is beyond the retention period its only available in the cold store. If you want to access the cold store here are 3 tips on how to get it right:
- You need to add the role template “Thing Editor” to your role to access the cold store. It has the appropriate scopes you need for accessing the cold store. You would do this in the cloud platform cockpit in the sub-account in the security section under role collections.
- Once you make a request to the api like this https://sap-iotaehandson.iot-sap.cfapps.eu10.hana.ondemand.com/appiot-coldstore/Things(’31AF7F6FC3C446BD896568DA7F5BFFE7′)/sap.iotaehandson.defaultpackage:air_quality_tag/air_quality_sensor?timerange=2017-01-01T00:00:00Z-2017-03-01T00:00:00Z you might find you get no values back? This is because this api only retrieves values that are exclusively in the cold store. So you first should find out the retention period (e.g. via api) and then access only data beyond the retention period with this api. All other data should be retrieved with the regular api (endpoint/route is called appiot-mds).
- Even when you try to access the data as described above you will still have no luck – you can at a maximum access 2 days worth of data. So to access data across a time range use multiple requests.
More information can be found under https://uacp2.hana.ondemand.com/viewer/p/SAP_IOT_APPLICATION_SERVICES under SAP IoT Application Enablement Services / Thing … Time Series Store.