Actions34
- Global Choice Actions
- Plugin Actions
- Record Actions
- Relationship Actions
- SQL Query via TDS (Read-Only) Actions
- Table Actions
- Web Resource Actions
- Webhook Actions
SQL Query via TDS (Read-Only) → Execute Query
AI-generatedSummary
Executes a required SQL query against Dataverse through the read-only TDS resource and returns the query results.
Inputs
- SQL Query (required) — SQL statement to run against Dataverse, such as
SELECT TOP 10 name, emailaddress1 FROM account. - Custom Auth.Enable — Enable custom authentication to provide an access token and environment URL instead of using OAuth2 credentials.
- Custom Auth.Environment URL — Dataverse environment URL; required when custom authentication is enabled.
- Custom Auth.Token — Access token for custom authentication; can be supplied as an expression.
Output shape
A list of query result items.
The operation is declared as read-only. The table selector and reference-only table fields selector are not inputs to the SQL execution. The supplied source pack exposes the query function signature but not its implementation, so result details are not specified.