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.
Last updated