Refresh device health fields on a schedule
Keep health fields current with a recurring update based on the device data your AppDrag function can access.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Visual SQL Update
Update rows in a database table.
Why this helps
A status field loses value when nobody remembers to refresh it after new device data becomes available.
- Refresh selected health fields on a recurring schedule.
- Use an existing AppDrag Visual SQL Update function.
- Reduce follow-up reminders to keep operational status current.
Setup
Build it in a few focused steps.
- 1Connect Adafruit IO and AppDrag once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3Tell Notis to run the existing AppDrag Visual SQL Update function for the device health fields and data it supports.
- 4Pick a recurring schedule and choose where run reports should go.
- 5Run once and verify the intended fields were refreshed.
Questions about this workflow
Can the update use the latest Adafruit IO reading?
Only if the existing AppDrag function can access that reading or it is otherwise supplied to the function. The schedule itself does not fetch Adafruit IO data.
Will this update every row?
The rows and fields affected depend on the Visual SQL Update function configured in AppDrag. Confirm its scope before using it.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Adafruit IO to Appdrag. A trigger fires from one place; an action lands in another.
Adafruit IO triggers
Appdrag actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Execute Cloud Backend function via DELETE
Executes a cloud backend function in the default environment.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Execute Preprod Function (DELETE)
Executes a backend function in the preproduction environment for testing or validation.
Execute PROD API Function (GET)
Executes a backend function in the production environment.
Execute Dev Function (PATCH)
Executes a backend function in the development environment.
Execute Cloud Backend function via POST
Executes a cloud backend function in the default environment.
Execute Function POST (Preprod Env)
Executes a cloud backend function in the preproduction environment.
Execute Cloud Backend function via PUT (default)
Executes a cloud backend function in the default environment.
Execute Cloud Backend function via PUT (preprod)
Executes a cloud backend function in the preproduction environment.
Connect any two apps with Notis in the middle.
Adafruit IO and Appdrag, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Appdrag.