Execute SQL query - Alumio Documentation

Runs a SQL query against a database and places the rows it returns into your data. Use this to read records straight from a database in the middle of a route, for example pulling order lines, looking up stock levels, or fetching customer details to enrich the data flowing through. The rows come back as a list at the location you choose, ready for the next steps to work with.

Fields

Sample data

This step runs a live query against the database, so the rows you get back depend on the data in your database. The example below looks up a product by the incoming sku and places the matching rows at matches.

Field	Value
Database connection	The configured database connection
Query	`SELECT sku, name, price FROM products WHERE sku = '&{sku}'`
Destination	`matches`

For an input of { "sku": "SHIRT-RED-M" }, the returned rows are placed at matches:

{
    "sku": "SHIRT-RED-M",
    "matches": [
        {
            "sku": "SHIRT-RED-M",
            "name": "Red T-Shirt M",
            "price": 19.95
        }
    ]
}

A query that returns no columns (such as an UPDATE or INSERT) places an empty list at the destination. See Placeholders for how to reference values such as &{sku} when building the query.

⌘I

​Fields

​Sample data

Fields

Sample data