Database Query

This action can be used to run queries on a database and extract desired data.

Properties

‌Input

• Query: The query which will be executed on the given tatabase connection.

• Database Connection: The DatabaseConnection object which will be used to interract with the SQL Server.

Output

• Result: The resulting DataTable object returned by the query.

Note: This object must have the Variable Type set to DataTable.

Misc

• Display Name: action display name in your implementation project.

• Wait Before: number milliseconds robot to wait before executing the action.

• Wait After: number milliseconds robot to wait until moving to the next action.

• Abort on Error: True/False.

• Retry Times: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.

Use Case

Potential Use Cases

• Run querries on a database to extract customers based on the specified requirements and insert them in a CRM.