Automation Blocks


# Automation Blocks

Scripts use two types of blocks:

- [Trigger Blocks](20.trigger_blocks.md) — to start a script
- Action Blocks — to perform specific operations

Action blocks are grouped by purpose and organized into categories. The categories include:

- [Installed](17.Integrations.md) — shown when custom blocks are available
- [Databases](12.work_with_data_base.md) — for working with tables in the workspace or external databases
- [Storage](13.work_with_files.md) — for working with files
- [Services](14.work_with_service.md) — for working with calendars, email, HTTP requests, and JavaScript code
- [Tools](6.tools.md) — for working with neural networks, system tables, and helper blocks used in scripting

The left panel also displays recommended block groups that can be used without switching categories.

![Automation Block Categories](./images/au_e_19.1.png)

Below is a table of available action blocks and the groups they belong to.

| **Automation Block** | **Groups the Block Belongs To** |
|----------------------|--------------------------------|
| **Category** [Databases](12.work_with_data_base.md) | |
| [SQL Query#SQL Query](./12.work_with_data_base.md) | Workspace, Databases |
| [Select Rows via SQL Query#Select Rows via SQL Query](./12.work_with_data_base.md) | Workspace, Databases |
| [Insert rows#Insert rows](./12.work_with_data_base.md) | Workspace, Databases |
| [Update rows#Update rows](./12.work_with_data_base.md) | Workspace, Databases |
| [Get Table Schema#Get Table Schema](./12.work_with_data_base.md) | Workspace, Databases |
| [Create a View#Create a View](./12.work_with_data_base.md) | Workspace |
| [Create a Table#Create a Table](./12.work_with_data_base.md) | Workspace |
| [Remove the Table#Remove the Table](./12.work_with_data_base.md) | Workspace |
| [Rename the Table#Rename the Table](./12.work_with_data_base.md) | Workspace |
| [Clear the Table#Clear the Table](./12.work_with_data_base.md) | Workspace |
| **Category** [Storage](13.work_with_files.md) | |
| [Download File Content#Download File Content](./13.work_with_files.md) | FTP, SFTP, SMB |
| [Get File List#Get File List](./13.work_with_files.md) | FTP, SFTP, SMB |
| [Delete File#Delete File](./13.work_with_files.md) | FTP, SFTP, SMB |
| [Upload to Directory#Upload to Directory](./13.work_with_files.md) | FTP, SFTP, SMB |
| [Get CSV#Get CSV](./13.work_with_files.md) | FTP, SFTP, SMB |
| **Category** [Services](14.work_with_service.md) | |
| [Send Email#Send Email](./14.work_with_service.md) | Email, System Email |
| [Send Request#Send Request](./14.work_with_service.md) | HTTP |
| [Execute Code#Execute Code](./14.work_with_service.md) | JavaScript |
| [Get Calendars#Get Calendars](./14.work_with_service.md) | Microsoft Exchange |
| [Get Calendar Events#Get Calendar Events](./14.work_with_service.md) | Microsoft Exchange |
| **Category** [Tools](6.tools.md) | |
| [Send Message#Send Message](./16.work_with_ai.md) | AI Model |
| [Create Embedding#Create Embedding](./16.work_with_ai.md) | AI Model |
| [Extract Text from Document#Extract Text from Document](./16.work_with_ai.md) | AI Model |
| [Wait for Event#Wait for Event](18.event_processing.md) | Event Processing |
| [Ungroup Array#Ungroup Array](./6.tools.md) | — |
| [Synchronizer#Synchronizer](./6.tools.md) | — |
| [Get System Table#Get System Table](./6.tools.md) | System Tables |
| [Execute Script#Execute Script](./6.tools.md) | Scripts |
| [Return Data#Return Data](./6.tools.md) | Scripts |
| [Generate CSV#Generate CSV](./13.work_with_files.md) | File |
| [Archive#Archive](./13.work_with_files.md) | File |
| [Extract Archive#Extract Archive](./13.work_with_files.md) | File |
| [Extract Text from PDF#Extract Text from PDF](./13.work_with_files.md) | File |
| [Filter#Filter](./6.tools.md) | — |
| [Execute Instruction#Execute Instruction](6.tools.md) | Digital Assistant |


Instructions for configuring and using automation blocks

Trigger Blocks

Editing a Script

What Is Operavix

Quick Installation of the Operavix Server Component

Monitoring Agent

JS Tracker (Customer Journey Tracking)

Quick Installation

Quick System Setup

Building a Custom Dashboard

Template-Based Reports for Data Analysis

First Dashboard

What’s Next?

Quick Start 

Functional Architecture

Network Interaction of the System Components

Description of the System Functioning

System Integration with External Automated Systems

Technical Requirements for the Server and Hardware Equipment

Architectural Scheme of the Operavix Application

Network Scheme of the Operavix Application

Glossary

Description of the Operavix System 

Installing, Activating, and Removing the Operavix Application on Windows

Installing the Operavix Application on Linux

Updating Operavix on Windows

Updating Operavix on Linux

Updating Operavix

Cluster Mode Configuration

Installing the Automation Module on a Separate Server

Installing and Running the AI Agent

Installing and Running the Webhook Agent

Instructions for Installing, Updating, and Removing the System

Release Types

License Key

Beta Version Functionality

System Licensing

Working with Databases

Working with the System

System Configuration Files

Prometheus Metrics

Access Roles

Working with GraphQL

Managing System Users

System Emails to Users

Differences Between Operavix on Linux and Windows Operating Systems

Administration 

Installing and Removing the ClickHouse DBMS

Connecting the Application to the ClickHouse Analytical DBMS

Creating User Accounts in ClickHouse

Data Storage Structure in ClickHouse

ClickHouse 

Monitoring Agent Distribution

Monitoring Agent on Windows

Monitoring Agent on Linux

Starting and Stopping the Monitoring Agent

Installing, Updating, and Removing the Monitoring Agent

User Data Logging

Storing Monitoring Agent Logs

Export and Import of User Activity

Collecting Screenshots with the Monitoring Agent

Activity Archiving

Monitoring 

Signing In to the System

How to Recover Your Password

Home Page

Filtering

Navigation in the System

Workspaces

Personal Profile

System Setup

Users

Departments

Bulk Actions

Adding API Keys

Keytab File Creation for the Kerberos Authentication in Active Directory

Configuring Authentication Using OpenID Connect and Keycloak

Configuring SAML Authentication in Keycloak

Adding Authentication

The Monitoring Section

Connections Section

Data Storages

System Tables

System Settings 

Automation Agents

Execution Log

Control Panel

Connections

Working with Files

Working with Services

Working with LLM

Tools

Event Processing

Query and Code Editor

Script Validation and Publishing

Running a Script

Script Example

Automation 

Custom Integrations 

System Events

JS Tracker 

Workspace Access Settings

Adding and Configuring Tables

Table Replacement

Adding and Configuring Processes

Workspace Global Indicators

Display Rules

Data Model Configuration

Packages

General

Dashboard Access Settings

Click Filter

Table Report Export

Browse mode

Edit Mode

Views

Process Explorer

Sphere of Processes

Funnel Сhart

Table

Pivot Table

Strip Сhart

Combined Bar Chart

Bar Chart

Line Chart

Donut Chart

Histogram

Indicator

Percentage KPI

KPI List

Filter

Parameter

Text

Button

Widgets

Sorting

Markdown Usage Rules

Variables

Dimensions and Measures

Global Dashboard Indicators

Running a Script from a Dashboard

Go to the URL

Execute Script

Open View

Update Variable

Actions on Click

Input Methods

Displaying Monitoring Screenshots in Dashboards

Formula Editor

Formula Functions

The process Function

View Configuration in YAML

Widget Configuration in YAML

Dimensions and Measures in YAML

Data Formats and Formatting in YAML

YAML Editor

Dashboards

Report Example

Business Intelligence 

Package Creation Guide

Marketplace 

Configuring User Data Depersonalization upon Deletion in AD

LDAPS Activation

Synchronized Attributes Between the System and AD

Retrieving AD Security Groups Information via GraphQL Query

Configuring User Synchronization with Active Directory

User Synchronization 

Audit Mechanism Description

System Status Monitoring

Implemented Information Security Protection Measures in the System

Audit Logs

Docker Containers

Mutual Authentication Between Application Server and ClickHouse

For Security Administrator 

Known Issues and Limitations 

Automation Block	Groups the Block Belongs To
Category Databases
SQL Query	Workspace, Databases
Select Rows via SQL Query	Workspace, Databases
Insert rows	Workspace, Databases
Update rows	Workspace, Databases
Get Table Schema	Workspace, Databases
Create a View	Workspace
Create a Table	Workspace
Remove the Table	Workspace
Rename the Table	Workspace
Clear the Table	Workspace
Category Storage
Download File Content	FTP, SFTP, SMB
Get File List	FTP, SFTP, SMB
Delete File	FTP, SFTP, SMB
Upload to Directory	FTP, SFTP, SMB
Get CSV	FTP, SFTP, SMB
Category Services
Send Email	Email, System Email
Send Request	HTTP
Execute Code	JavaScript
Get Calendars	Microsoft Exchange
Get Calendar Events	Microsoft Exchange
Category Tools
Send Message	AI Model
Create Embedding	AI Model
Extract Text from Document	AI Model
Wait for Event	Event Processing
Ungroup Array	—
Synchronizer	—
Get System Table	System Tables
Execute Script	Scripts
Return Data	Scripts
Generate CSV	File
Archive	File
Extract Archive	File
Extract Text from PDF	File
Filter	—
Execute Instruction	Digital Assistant

.css-wsrjzs{display:inline;margin-right:12px;}@media screen and (max-width: 691px){.css-wsrjzs{display:inline-block;margin-right:0;}}Automation Blocks

Automation Blocks