Execute SQL Query

Definition

Execute given SQL query on nopCommerce database and returned execution result.
With this activity you can do anything! You have no limitation, if you need some info from your products, orders, customers and so on you can get them directly from database with this activity.
To work with this activity you need to know the nopCommerce database structure. You can find the default database schema here.

Properties

Property	Description
Query	SQL query to execute.

Outcomes

Outcome	Description
Done	Returns the output model.

Output Model

{
    Table1: [{ ... }] // object/objects of query result
}