Check AppDrag records when a device alert arrives
When a device relay sends an alert, have Notis fetch the relevant rows from AppDrag so the next step starts with context.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Visual SQL SELECT
Read rows from a database table.
Why this helps
An alert is harder to act on when the related records and recent context are somewhere else.
- Use the incoming alert as the reason to check the database.
- Retrieve rows through an existing AppDrag Visual SQL SELECT function.
- Give your team a clearer starting point for investigating a device issue.
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 use the alert payload to run the relevant AppDrag Visual SQL SELECT function and summarize returned rows.
- 4Pick the webhook trigger and choose where run reports should go.
- 5Send one real alert and confirm the returned data is useful.
Questions about this workflow
Will Notis create a Visual SQL function?
No. AppDrag must already have a Visual SQL SELECT function configured for the records you want to inspect.
Can the webhook query every feed?
Only if the existing function and the data sent in the request support that lookup. Supply any needed identifiers in the webhook payload.
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.