Skip to content
Notis

Clear confirmed retired device records

Route a deliberate retirement request to the AppDrag delete function that handles the specific device record.

Trigger

Webhook received

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

Action

Visual SQL Delete

Delete rows from a database table.

Why this helps

Retired device records can clutter operational views when cleanup requests are easy to lose.

  • Turn a specific retirement request into a consistent cleanup action.
  • Call an existing AppDrag Visual SQL Delete function.
  • Keep stale device records from obscuring current operational work.

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 call the designated AppDrag Visual SQL Delete function only for a confirmed retired-device request with the required identifier.
  • 4Pick the webhook trigger and choose where run reports should go.
  • 5Test with one explicitly designated record and verify the intended result.

Questions about this workflow

Does this delete records automatically whenever a reading stops?

No. The workflow should require an explicit retirement request in the webhook payload. A missing reading alone does not prove that a device is retired.

What must be configured in AppDrag?

An existing Visual SQL Delete function must be configured for the intended table and record criteria.

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.

TriggerScheduled

Execute Cloud Backend function via DELETE

Executes a cloud backend function in the default environment.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

Execute Preprod Function (DELETE)

Executes a backend function in the preproduction environment for testing or validation.

ActionInstant

Execute PROD API Function (GET)

Executes a backend function in the production environment.

ActionInstant

Execute Dev Function (PATCH)

Executes a backend function in the development environment.

ActionInstant

Execute Cloud Backend function via POST

Executes a cloud backend function in the default environment.

ActionInstant

Execute Function POST (Preprod Env)

Executes a cloud backend function in the preproduction environment.

ActionInstant

Execute Cloud Backend function via PUT (default)

Executes a cloud backend function in the default environment.

ActionInstant

Execute Cloud Backend function via PUT (preprod)

Executes a cloud backend function in the preproduction environment.

ActionInstant

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.