Query resources in workflows

📘

Learn more about Retool's supported integrations and how to connect your own data sources.

You can add Resource query blocks to workflows that enable you to write queries that interact with databases and APIs. You can write SQL queries for databases with SQL or perform API requests.

Write SQL queries

You use SQL mode to write SQL statements, primarily used for reading data. GUI mode provides you with an interface to construct queries that write or modify data with greater accuracy than a raw SQL statement. This can prevent unintentional changes due to erroneous SQL statements.

Perform API requests

API resources, such as REST, GraphQL, and SOAP APIs, also use a GUI to construct queries. You can also use the RESTQuery resource to manually interact with APIs that are not configured as an existing resource.