Skip to main content
POST
Retrieve one grouping level of a report table whose data is not held in Druid.

Authorizations

Authorization
string
header
required

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.

$type
enum<string>
required
Available options:
Derivitec.Web.Core.LegacyReportQuery.ApiGetLegacyTableRowsRequest, Derivitec.Web.Core
report_id
string | null

Opaque identifier of the report run to retrieve or query. The value must not be null or empty.

portfolio_type
enum<string> | null

Portfolio category used to resolve the requested portfolio. It may be omitted when the portfolio name resolves unambiguously.

Available options:
derivitec,
enfusion,
orchestrade,
liquidity_book,
maia,
fund_studio,
not_set
table_id
string | null

Table view's stable id, from the definition response.

table_view_definition_id
string | null

Named table view to apply. Null selects the user's default.

start_row
integer<int32>

Inclusive first visible row index.

end_row
integer<int32>

Exclusive last visible row index.

filters
object[] | null

Filter conditions.

sorts
object[] | null

Ordered sort instructions.

active_pivot_keys
string[] | null

Pivot keys to group by, in order. This is AG Grid's rowGroupCols, so reordering the row-group panel reorders the pivots.

group_keys
string[] | null

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.

request_sequence
integer<int64>

Opaque client sequence number, echoed back untouched so the client can discard a late response. The server never interprets it.

report_type
enum<string>

The report category that selects the applicable metadata shape. Server-managed.

Available options:
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.

$type
enum<string>
required
Available options:
Derivitec.Web.Core.LegacyReportQuery.ApiGetLegacyTableRowsResponse, Derivitec.Web.Core
is_success
boolean

Whether the operation completed successfully. The default is true; error outcomes set it to false.

Example:

true

error_messages
string[] | null

Messages explaining operation-level failures. The collection is empty by default.

data
object[] | null

Requested slice of this level's rows.

last_row
integer<int32>

Number of rows at this grouping level - not the number of raw report rows, and not the page size.

request_sequence
integer<int64>

Client sequence number from the request, echoed back.

failure_category
enum<string> | null

Failure category when the request was rejected.

Available options:
unknown_column,
unsupported_operator,
invalid_filter_value,
unknown_pivot,
invalid_pivot_path,
invalid_row_range,
unknown_table,
unknown_table_view,
column_not_filterable