Turn parsed documents into a focused ClickHouse lookup
Bring parsed context into a database query and get the result summary alongside the automation run report.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Execute ClickHouse Query
Runs a database query and returns the results.
Why this helps
A useful document detail can get stranded in a parsing tool when checking it against analytics data takes extra steps.
- Use parsed context to guide a database lookup
- Get a summary of returned query results
- Keep the result connected to the automation run
Setup
Build it in a few focused steps.
- 1Connect Airparser and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis from any channel to create it.
- 3In one instruction, describe how parsed context should guide a ClickHouse SQL query and what returned data to summarize.
- 4Choose the webhook trigger, select a report channel, and send parsed Airparser output to the Notis webhook.
- 5Test with one real document and confirm the query has the data and access it needs.
Questions about this workflow
Can Notis infer missing information from a document?
It can analyze the supplied parsed context, but missing fields or historical values must come from the user or the queried database.
What happens if the parsed result does not contain enough context?
The instruction should tell Notis what to do when details are missing, such as report that the query needs more information.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Airparser to ClickHouse. A trigger fires from one place; an action lands in another.
Airparser triggers
ClickHouse actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Execute ClickHouse Query
Runs a database query and returns the results.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Database Schema
Retrieves an overview of a database's schema and tables.
Get Table Schema
Gets the schema and column details for a table.
Get ClickHouse Play Interface
Returns the ClickHouse Play interface for writing queries and viewing results.
List ClickHouse Databases
Lists the databases in an instance.
List ClickHouse Tables
Lists tables in databases with basic details.
Connect any two apps with Notis in the middle.
Airparser and ClickHouse, 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 ClickHouse.