SQL queries and API requests

Use a query or request when a connected data source needs a custom read or action. Inspect the method, parameters, credentials, and expected result before attaching it to an app screen or workflow.

• SQL Query Builder and Making SQL queries cover database queries.

• API Builder and Making API requests cover HTTP requests.

• Text to SQL and Ask AI for queries and transformations offer assistance, but generated requests still need review.

Use a safe dataset to test write requests. The connector guide is under Data Sources.

Follow a task

• Use dynamic SQL inputs to reuse a query with different customer IDs.

• Choose an API response format.

• Transform API responses to select and rename fields.

• Configure pagination to retrieve more than the first page.

• Handle API errors.