Data-Driven | Leapwork Docs

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

• 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.

• 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.

• 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.

• 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.

• 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.

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

• 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.

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