History of energy price lowest for duration

This query returns a list of when energy price was at the lowest and for a set duration (such as an hour) and between your preferred time settings.

About this query

Triggers, queries, and actions are the building blocks of Applets. Triggers tell an Applet to start, queries ask a question, and actions are its end result.

Developer info

Description: This query returns a list of when energy price was at the lowest and for a set duration (such as an hour) and between your preferred time settings.
API endpoint slug: agile_octopus.history_of_energy_price_lowest_for_duration
Runtime method: performQuery("agile_octopus.history_of_energy_price_lowest_for_duration")

Query fields

Happens after Dropdown list

Label: Happens after
Slug: happens_after
Required: true
Can have default value: false

Happens before Dropdown list

Label: Happens before
Slug: happens_before
Required: true
Can have default value: false

Number of periods Text input

Label: Number of 30-minute periods matching threshold
Helper text: Must be between 1 and 48.
Slug: number_of_periods
Required: true
Can have default value: true

Ingredients

Created atDate and time event was created.

Slug: created_at
Filter code: AgileOctopus.historyOfEnergyPriceLowestForDuration.CreatedAt
Type: Date with time (ISO8601)
Example: 2020-07-08T04:17:06.000+05:00

Triggered atDate when trigger event occurred.

Slug: triggered_at
Filter code: AgileOctopus.historyOfEnergyPriceLowestForDuration.TriggeredAt
Type: Date with time (ISO8601)
Example: 2020-07-08T04:17:06.000+05:00

Average priceOctopus Agile prices at lowest average for your set number of 30-minute periods

Slug: average_price
Filter code: AgileOctopus.historyOfEnergyPriceLowestForDuration.AveragePrice
Type: String
Example: 10

StartStart time of period

Slug: start
Filter code: AgileOctopus.historyOfEnergyPriceLowestForDuration.Start
Type: Date with time (ISO8601)
Example: 2020-07-08T04:17:06.000+05:00

EndEnd time of period

Slug: end
Filter code: AgileOctopus.historyOfEnergyPriceLowestForDuration.End
Type: Date with time (ISO8601)
Example: 2020-07-08T04:17:06.000+05:00

Number of periodsNumber of periods used in trigger settings

Slug: number_of_periods
Filter code: AgileOctopus.historyOfEnergyPriceLowestForDuration.NumberOfPeriods
Type: String
Example: 3