Execute Query (Get Results)
Run a query; SELECT results are stored as a DataTable.
Overview
Execute Query (Get Results) is a no-code automation step in the Database category of AutoFlowRPA. It performs its action in a single step when the workflow reaches it. You can configure 3 parameter(s) to control exactly how it behaves. It is one of 369 commands you can drag into a workflow in the visual builder — no scripting required.
What it does
Run a query; SELECT results are stored as a DataTable.
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
| Connection name | variable | Required | db | |
| SQL query | multiline | Required | SQL to run. Variables are expanded first. Example: SELECT * FROM users Supports variables | |
| Store result in | variable | Required | Example: result |
How to use Execute Query (Get Results)
- 1
Open AutoFlowRPA and drag the Execute Query (Get Results) command from the Database group onto the canvas.
- 2
Set its parameters in the side panel — Execute Query (Get Results) has 3 configurable field(s).
- 3
Connect it into your workflow and press Run. Everything executes locally on your machine.
Frequently asked questions
What does the Execute Query (Get Results) command do?
Run a query; SELECT results are stored as a DataTable.
Which group does the Execute Query (Get Results) command belong to?
Execute Query (Get Results) is part of the Database group. AutoFlowRPA ships with 369+ ready-made commands you can combine without code.
Does the Execute Query (Get Results) command take any parameters?
Yes — Execute Query (Get Results) has 3 configurable field(s), all editable in the visual node editor.
More Database commands
Ready to automate your busywork?
Start your free 30-day trial today. No credit card, no commitment.