ppds_query_sql
Execute a SQL SELECT query against Dataverse. The SQL is transpiled to FetchXML internally. Supports JOINs, WHERE, ORDER BY, TOP, and aggregate functions. Example: SELECT name, revenue FROM account WHERE statecode = 0 ORDER BY revenue DESC
Input schema
| Name | Type | Required | Description |
|---|---|---|---|
| sql | String | yes | SQL SELECT statement (e.g., 'SELECT name, revenue FROM account WHERE statecode = 0') |
| maxRows | Int32 | no | Maximum rows to return (default 100, max 5000) |
Output
Returns Task<QueryResult>.