See patterns in monthly 21risk item data
Turn monthly fact table results into a short review that helps you notice patterns across sites and questions.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Get Items Per Month
Retrieves monthly item data by question and site.
Why this helps
Monthly data is useful for spotting patterns, but reviewing fact table rows one by one takes attention away from decisions.
- Summarizes returned monthly rows across sites and questions.
- Supports repeatable reviews using OData query options you provide.
- Reduces manual scanning of fact table data.
Setup
Build it in a few focused steps.
- 1Connect Agentql and 21risk once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name and prompt.
- 3In one instruction, ask Notis to retrieve itemspermonth data with your chosen OData parameters and summarize only patterns supported by the returned rows.
- 4Choose a recurring schedule and select where run reports should go.
- 5Test with one real query and check that the summary reflects the returned period and rows.
Questions about this workflow
Can it compare against historical data not returned by 21risk?
No. The summary should be limited to the monthly rows retrieved. Supply any additional baseline data in your instruction if you want a comparison.
What query options can I specify?
The listed action supports OData parameters such as filter, top, skip, select, and maxpagesizeinmb.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Agentql to 21risk. A trigger fires from one place; an action lands in another.
Agentql triggers
21risk actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get Compliance
Retrieves compliance data for sites, categories, and questions.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Items (BETA)
Retrieves items for analytics and reporting.
Get Items Per Month
Retrieves monthly item data by question and site.
Get Organizations
Lists organizations.
Get Properties
Retrieves property details related to sites, including insurance information.
Get Reports
Retrieves audit reports, including draft, published, and scheduled reports.
Get RiskModel Categories
Retrieves risk model categories used to group questions and compliance checks.
Get Risk Models
Lists risk models used for audits and compliance.
Connect any two apps with Notis in the middle.
Agentql and 21risk, 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 21risk.