The Data-Driven Building Blocks

These blocks are used to drive automation cases with external data—whether it comes from web services, spreadsheets, files on disk, or relational databases.

• HTTP Request: Calls any URL with an HTTP/HTTPS request (GET, POST, PUT, DELETE, etc.) and passes the response, status code, headers, and body, on to the next block in the case.

• Send Email: Sends SMTP e‑mails directly from a case, with dynamic recipients, subject, body, and attachments.

• Read Excel: Opens a .xlsx/.xls file, reads row‑by‑row or by range, and feeds each row’s values into subsequent blocks as variables.

• Database: Connects through ODBC/JDBC, runs SQL statements, and exposes the result set so each record can drive a test iteration or be validated inside the flow.

• Write Excel: Creates or updates workbooks during execution, ideal for logging evidence, exporting transformed data, or preparing input files for downstream processes.

• Command‑line: Executes operating‑system commands, PowerShell/Bash scripts, and other CLI tools, then captures their standard output and exit code for conditional logic.

• Compress File: Zips or unzips files and folders on the fly, allowing you to package test artifacts or extract data sets before they are consumed.

• Save File: Writes any text, binary, or image data travelling through the flow to a file whose path and name can be built at runtime.

• Set File: Injects an existing file, template, media asset, large data set, so later blocks (for example, Send Email or Compress File) can use it without manual uploads.

Updated 11.08.25.