Run scheduled cleanup for eligible Appdrag rows
Make an existing Appdrag cleanup function easier to run consistently with a scheduled Notis workflow.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Visual SQL Delete
Delete rows from a database table.
Why this helps
Routine record cleanup can slip when it depends on someone remembering to run a prepared database operation.
- Run a prepared cleanup function consistently.
- Reduce the need to remember a recurring database task.
- Keep a report of each run.
Setup
Build it in a few focused steps.
- 1Connect Affinda and Appdrag once in the Notis portal.
- 2Create an automation in Automations, New Automation, or describe it to Notis from any channel.
- 3Ask Notis to run the appropriate Appdrag Visual SQL Delete function and summarize its response.
- 4Pick a recurring schedule and choose where run reports go.
- 5Test carefully with one real run and confirm the function's configured criteria.
Questions about this workflow
Does Notis decide which rows are safe to delete?
The Visual SQL Delete function applies its configured behavior. Verify that behavior and criteria in Appdrag before scheduling it.
Does this use Affinda as a trigger?
No. Affinda has no listed trigger events for this package. This workflow starts on a Notis schedule.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Affinda to Appdrag. A trigger fires from one place; an action lands in another.
Affinda 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.
Affinda 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.