I am working with Data Time series node. I am able to query the data for a range of time. But would like query the data points from a specific start date timestamp to end timestamp.
Example : From Dec 1st 2025 to Jan 27st 2026. But there is no configuration for the Time series node to enter start and end times.
Need some assistance on this topic.
You have a couple options …
First, the Data: Time Series Node allows you to set a “Custom” time range, which allows you to enter a Range Duration and a Range End, both of which accept string templates.
So assuming you have your start time and your end time on the payload as ISO strings like so …
{
"startTime": "2025-12-01T00:00:00.000Z",
"endTime": "2026-01-27T00:00:00.000Z"
}
… you can use a combination of the {{formatDate}} helper and the {{subtract}} helper to configure the node:
- Range Duration:
{{subtract (formatDate endTime 'x') (formatDate startTime 'x')}}
- Range End:
{{formatDate endTime ‘x’}}
Alternatively, you can use the Losant API Node and the Data: Time Series Query action with a query like the following (which you will need to edit to fit your use case) …
{
"start": {{formatDate startTime 'x'}},
"end": {{formatDate endTime 'x'}},
"attributes": [...],
"deviceIds": [...],
"resolution": "..."
}
Note that both start and end require the value to be a number representing milliseconds since Epoch.
1 Like
Thanks Dylan!! appreciate the response