query_analytical_data
Execute OData queries on analytical models to retrieve aggregated data with dimensions and measures, supporting filtering, sorting, pagination, and aggregations for BI and reporting.
Instructions
Execute OData queries on analytical models to retrieve aggregated data with dimensions and measures. Supports full OData query syntax: $select (column selection), $filter (WHERE conditions), $orderby (sorting), $top/$skip (pagination), $apply (aggregations with sum/average/min/max/count/groupby). Perfect for business intelligence, reporting, and data analysis.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Maximum number of results (default: 50, max: 10000) | |
| skip | No | Number of results to skip for pagination | |
| apply | No | Aggregation transformations (e.g., 'groupby((Currency), aggregate(Amount with sum as TotalAmount))') | |
| count | No | Include total count in response | |
| filter | No | OData filter expression (e.g., 'Amount gt 1000 and Currency eq "USD"') | |
| select | No | Comma-separated list of dimensions/measures to return (OData $select) | |
| orderby | No | Sort order (e.g., 'Amount desc, TransactionDate asc') | |
| asset_id | Yes | Asset identifier | |
| space_id | Yes | Space identifier | |
| entity_set | Yes | Entity set name to query |