Scripts and Programs

These actions let your AI Employee step outside the mouse-and-keyboard world: run scripts, launch or close desktop programs, and talk directly to SQL databases on your network.

Run Powershell Script

Runs a PowerShell command or script on the AI Employee’s computer. Use it for anything Windows can do from the command line - renaming batches of files, calling internal services, checking system state.

Script Command - the PowerShell command(s) to run. Supports {{Field}} tokens, so process data can flow straight into the script.
Wait for Results - when on, the AI Employee waits for the script to finish (up to 60 seconds) and holds the script’s output as a result that later actions can use; any error text is included in the output. When off, the script is started and the job moves on immediately.

With Wait for Results on, the action fails if the script runs longer than 60 seconds.

Run Python Script

Runs a Python script using a Python installation on the AI Employee’s computer. Use it when your automation needs logic or data handling that is easier to express in Python.

Python Executable Folder Path and Python Executable File Name - where Python is installed. Support {{Field}} tokens.
Python Script Folder Path and Python Script File Name - the script to run. Support {{Field}} tokens.

The action fails if the Python installation or the script file cannot be found. The script’s output is written to the run log.

Run Executable

Launches a program on the AI Employee’s computer, waits for it to finish loading, and brings its window into focus so the following actions can work inside it. This is the usual first step of a job that automates a desktop application.

Executable Folder Path and Executable File Name - the program to launch. Support {{Field}} tokens.
Executable File Arguments - optional command-line arguments to pass to the program. Supports {{Field}} tokens.

The launched window’s title and program name are held as results for later actions. The action fails if the program cannot be found or its window never appears.

Kill Executable

Force-closes a running program by matching its window title, its program file name, or both. Use it to guarantee a clean starting state - for example, closing any leftover browser or application windows before a job begins.

Window Name Contains (Optional) - text that appears in the window’s title. Supports {{Field}} tokens.
Window Executable Name (Optional) - the program’s file name (for example excel.exe). Supports {{Field}} tokens.

Because the program is terminated immediately, any unsaved work in it is lost. The action fails if the matched program cannot be closed.

SQL - Query

Runs a SELECT query against a SQL Server database and can start a new process instance for every row the query returns, mapping the row’s columns into process fields. Use it to pull work items out of a line-of-business database and turn each one into a running process.

SQL Connection String - how to connect to the database.
SQL Query - the query to run. Supports {{Field}} tokens, so values from the process can drive the WHERE clause.
Process to Start - the process template to start for each returned row.
Process Field to Update / SQL Column Name pairs - up to 30 mappings pairing a process field with the SQL column whose value should fill it.

If the query returns no rows, the action succeeds without starting anything. It fails if the database returns an error, or if rows come back but no process template is selected.

SQL - Update

Runs an INSERT, UPDATE, or DELETE statement against a SQL Server database. Use it to write results back to another system once the AI Employee has finished its work.

SQL Connection String - how to connect to the database.
SQL Query - the statement to run. Supports {{Field}} tokens.

The action succeeds even when zero rows are affected; it fails only if the database returns an error.