So, I want to use the data I have collected with Cumulocity to create automated reports. The creation of the reports must be automated such that they aggregate accumulated time series, alarm & event data into a single report which is automatically sent to relevant parties through e-mail at a fixed time interval (say, weekly or monthly).
I have a basic idea of how it works with the APIs provided by Cumulocity, but I'm rather intrigued regarding more specific implementations.
Should the data that I want to aggregate be retrieved with CEL (Cumulocity Event Language) and then the report created in the desired format (pdf) with my own script? Could anybody tell me if it's possible to host this kind of script in Cumulocity or should I have to host it myself?