Fetching Sensor Data from ThingSpeak with Specific Date and

The code fetches sensor data from specific fields within a defined time range and formats the data as a timetable for further analysis.

1. Time Initialization:

• The script first defines the start and stop times using datetime and dateshift functions.
• datetimeStart marks the beginning of the current hour.
• datetimeStop is set to 30 minutes after datetimeStart, effectively creating a 30-minute window.

1. Initial Data Fetching:

• The first thingSpeakRead call retrieves the last three data points from fields 1 and 2 of the specified ThingSpeak channel (2635364).
• The retrieved data is formatted as a timetable and stored in the variable data.

1. Data Fetching with Date Range:

• The script then refines the data retrieval by specifying a DateRange between datetimeStart and datetimeStop.
• It reads data only from field 2 of the channel within this 30-minute window, formatting it as a timetable.

1. Key Parameters:

• Channel ID: 2635364
• ReadKey: ''
• Fields: Specifies which fields of the ThingSpeak channel to read from.
• NumPoints: Limits the number of data points retrieved (3 in the initial call).
• OutputFormat: Specifies that the output should be in the form of a timetable.

This code is useful for scenarios where you need to monitor and analyze specific time-bound sensor data from a ThingSpeak channel.