Apply invoice review outcomes to Appdrag records
Carry an invoice review decision into the corresponding Appdrag rows with a focused workflow.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Visual SQL Update
Update rows in a database table.
Why this helps
Invoice decisions are easy to lose when review notes and database records live in separate steps.
- Keep invoice review outcomes alongside relevant rows.
- Avoid retyping decisions into Appdrag.
- Review the outcome of each automation 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.
- 3Tell Notis to use the invoice review details in the webhook request to call the Appdrag Visual SQL UPDATE function.
- 4Choose a webhook trigger and select where run reports go.
- 5Test with one real invoice review and check the affected Appdrag rows.
Questions about this workflow
Does the workflow configure the Visual SQL mapping?
No. The Appdrag Visual SQL UPDATE function must already be configured. Notis uses the function and request details based on your instruction.
What if the webhook does not include a row identifier?
The function needs an appropriate way to determine which rows to update. Supply the identifier or matching criteria through the request or function configuration.
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.