Execute SQL

Use Execute SQL to run a custom SQL query from an API Endpoint workflow.

Most of the time, Get rows, Insert rows, Update rows, and Delete rows are easier. Execute SQL is best when you need something very specific.

Use with care

SQL is powerful. A small mistake can return too much data, change the wrong rows, or delete data.

Add the action

1. In Data & API, open your API Endpoint workflow.
2. Click + Add an action.
3. Go to Data → Tables.
4. Select Execute SQL.

Configuration

Write your query

In SQL Query, enter your query in Query.

If you want to use dynamic values, you can add named parameters in your query using the $name format (for example $email or $userId).

Add parameters (optional)

In SQL Parameters, add each parameter you used in the query:

• Name: The parameter name (without the $)
• Value: The value to use (you can bind this)

Result

After the action runs, you can use the query result from the action’s result in later actions.

CONTINUE LEARNING

Learn how to retrieve rows without writing SQL.

Get rows →