I’m getting alerts sent from another platform as a JSON using a webhook.
These alerts contain high level information about some devices, mainly as short text fields.
I will maybe get these once an hour.
What do you recommend to store these as?
in a data table or Time series?
What pros/cons for either direction?
Time-series data ( data associated with a specific time “once an hour” ) should always be reported as Device State. It’s not recommended to store time-series data within a Data Table.
If you were updating a single Data Table row (not maintaining history), that would work.
Data Tables are meant to store static or semi-static data: Information that would change rarely or not at all. Some examples: fault code details, custom security rules, additional metadata for users or devices.
We have more when to and when not to use information about Data Tables in the docs: https://docs.losant.com/data-tables/overview/