Skip to main content

SQL Query Row

Through the SQL query row action it is possible to write an arbitrary SQL query which gets returned as response. It is possible to pass path and query parameters into the query by using curly brackets i.e. title. These fields are internally replaced by a prepared statement so you dont need to worry about SQL injections.

Configuration​

sql_query_row

Connection​

The database connection.

SQL​

The SQL to execute for example:

    SELECT * 
      FROM contract
INNER JOIN product
        ON contract.product_id = product.id
     WHERE product.id = {id}

Video​