Retrieve one grouping level of a report table whose data is not held in Druid.
Returns one page of one grouping level, which is what a server-side row model requests:
the children of the group named by GroupKeys, or the top level when it is empty,
and the report’s own rows once it names every active pivot. Each request is answered
independently, so no expansion state is retained between calls. An unavailable or
restricted run, or a request the engine cannot satisfy, returns an unsuccessful
response envelope carrying a failure category. Report restriction and caller fields are
server-managed, and rows the caller is not authorized to see are never returned.
Authorizations
OAuth2 access-token requested from AWS Cognito and provided as a Auth Bearer header
Body
The body containing the required opaque report-run ReportId, the TableId and optional TableViewDefinitionId identifying the table, the StartRow and EndRow paging bounds, optional Filters and Sorts, the ActivePivotKeys giving the pivot hierarchy in order, the GroupKeys naming the group whose level is wanted, and a client-generated RequestSequence echoed back for correlation. Report restriction and caller fields are server-managed. A pivot key the report does not declare, and a filter operator a column does not support, are rejected rather than ignored.
Asks for one page of one grouping level of a non-Druid Risk report table. Every field the result depends on is present, so the request is reproducible without server-side session state.
The shape mirrors the Druid path's row_group_cols / group_keys, because both
are driven by AG Grid's server-side row grouping.
Derivitec.Web.Core.LegacyReportQuery.ApiGetLegacyTableRowsRequest, Derivitec.Web.Core Opaque identifier of the report run to retrieve or query. The value must not be null or empty.
Portfolio category used to resolve the requested portfolio. It may be omitted when the portfolio name resolves unambiguously.
derivitec, enfusion, orchestrade, liquidity_book, maia, fund_studio, not_set Table view's stable id, from the definition response.
Named table view to apply. Null selects the user's default.
Inclusive first visible row index.
Exclusive last visible row index.
Filter conditions.
Ordered sort instructions.
Pivot keys to group by, in order. This is AG Grid's
rowGroupCols, so reordering the row-group panel reorders the pivots.
Pivot value path of the group whose children are wanted, i.e. AG
Grid's groupKeys. Empty means the top level. The grid owns the expansion state
and asks for one level per request.
Opaque client sequence number, echoed back untouched so the client can discard a late response. The server never interprets it.
The report category that selects the applicable metadata shape. Server-managed.
risk, var, pnl, time_series Response
Returns the level's rows and its LastRow total, or an unsuccessful envelope with a failure category when the run is unavailable, restricted, or the request does not resolve.
One page of one grouping level of a non-Druid Risk report table. Carries no Druid segment or ingestion fields.
Derivitec.Web.Core.LegacyReportQuery.ApiGetLegacyTableRowsResponse, Derivitec.Web.Core Whether the operation completed successfully. The default is true; error outcomes set it to false.
true
Messages explaining operation-level failures. The collection is empty by default.
Requested slice of this level's rows.
Number of rows at this grouping level - not the number of raw report rows, and not the page size.
Client sequence number from the request, echoed back.
Failure category when the request was rejected.
unknown_column, unsupported_operator, invalid_filter_value, unknown_pivot, invalid_pivot_path, invalid_row_range, unknown_table, unknown_table_view, column_not_filterable