> ## Documentation Index > Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt > Use this file to discover all available pages before exploring further. # Retrieve a page of rows from a report run. > Queries available result rows without starting or waiting for a report run. Grid paging uses a zero-based `StartRow` offset and an exclusive `EndRow` bound; their defaults are 0 and 50. Group columns, group keys, value columns, filters, sorting, and the time-series flag shape the result. A `LastRow` of -1 means the final row count is not yet established. Caller and access context are server-managed, and an unavailable or restricted run can return an unsuccessful response envelope. ## OpenAPI ````yaml /risk-and-pricing/atoti-risk-services/apis-endpoints/openapi/openapi.mintlify.json post /api/ReportQuery/GetRows openapi: 3.0.4 info: title: Derivitec Api 1.0 version: '1.0' servers: - url: https://api.riskportal.activeviam.com security: - oauth2: [] - apikey: [] tags: - name: AdminUser - name: AtotiReport - name: AtotiSession - name: BloombergOAuth - name: Bond - name: BondYieldCurvePage - name: BookAccess - name: Books - name: Commodity - name: Counterparties - name: Currencies - name: Equity - name: EquityDividend - name: EquityPage - name: FeatureFlag - name: Fx - name: FxPage - name: GroupAccess - name: Home - name: LegacyPosition - name: MarketData - name: MarketDataProvider - name: MarketDataProviderAccess - name: Meta - name: Notification - name: Organisation - name: PnLReport - name: PortfolioAccess - name: Portfolios - name: Position - name: PositionFilter - name: PricingEnvironment - name: PricingEnvironmentAccess - name: RateAsset - name: RateAssetPage - name: Report - name: ReportDefinition - name: ReportHistoryLauncherQuery - name: ReportLauncher - name: ReportQuery - name: ReportQueryViewUser - name: ReportRestriction - name: ReportView - name: RiskReport - name: Tradable - name: TradeBooking - name: User - name: VarReport - name: VarReportQuery - name: YieldCurvePage paths: /api/ReportQuery/GetRows: post: tags: - ReportQuery summary: Retrieve a page of rows from a report run. description: >- Queries available result rows without starting or waiting for a report run. Grid paging uses a zero-based `StartRow` offset and an exclusive `EndRow` bound; their defaults are 0 and 50. Group columns, group keys, value columns, filters, sorting, and the time-series flag shape the result. A `LastRow` of -1 means the final row count is not yet established. Caller and access context are server-managed, and an unavailable or restricted run can return an unsuccessful response envelope. operationId: GetRows requestBody: description: >- The body containing the required opaque report-run `ReportId`, grid query, optional `Prefilter`, and optional result-version `TimePositionsLoaded` timestamp. Report restriction, report type, portfolio type, market-data environment, and caller fields are server-managed. Valid column names, filter operators, time-series semantics, and row-value units are not defined by this operation. content: application/json-patch+json: schema: $ref: '#/components/schemas/ApiGetAgGridRowsRequest' application/json: schema: $ref: '#/components/schemas/ApiGetAgGridRowsRequest' text/json: schema: $ref: '#/components/schemas/ApiGetAgGridRowsRequest' application/*+json: schema: $ref: '#/components/schemas/ApiGetAgGridRowsRequest' responses: '200': description: >- Returns the requested rows, the result-version timestamp, and the `LastRow` paging indicator, or an unsuccessful envelope when the run is unavailable or restricted. content: application/json: schema: $ref: '#/components/schemas/ApiGetAgGridRowsResponse' '400': description: BadRequest '401': description: Unauthorized '403': description: Forbidden security: - oauth2: [] - apikey: [] components: schemas: ApiGetAgGridRowsRequest: required: - $type type: object properties: time_positions_loaded: type: string description: Timestamp identifying the loaded-position result version to query. format: date-time report_id: type: string description: >- Opaque identifier of the report run to retrieve or query. The value must not be null or empty. nullable: true portfolio_type: enum: - derivitec - enfusion - orchestrade - liquidity_book - maia - fund_studio - not_set type: string description: >- Portfolio category used to resolve the requested portfolio. It may be omitted when the portfolio name resolves unambiguously. nullable: true grid_query: $ref: '#/components/schemas/AgGridQuery' report_type: enum: - risk - var - pnl - time_series type: string description: >- Report category that selects the applicable result or metadata shape. market_data_environment_name_mappings: type: object additionalProperties: type: string nullable: true description: >- Market-data environment name mapping exposed by this request; accepted keys, values, and behavior are not established. nullable: true prefilter: $ref: '#/components/schemas/FilterBase' $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.ApiGetAgGridRowsRequest, Derivitec.Web.Core additionalProperties: false description: >- Report-run, grid, restriction, and filter selectors for retrieving result rows. ApiGetAgGridRowsResponse: required: - $type type: object properties: is_success: type: boolean description: >- Whether the operation completed successfully. The default is `true`; error outcomes set it to `false`. example: true error_messages: type: array items: type: string description: >- Messages explaining operation-level failures. The collection is empty by default. nullable: true last_row: type: integer description: >- Total row count when established, or -1 when the final count is not yet known. format: int32 data: type: array items: {} description: Report-grid rows returned for the requested page. nullable: true segment_loaded_time: type: string description: Timestamp identifying the returned result segment. format: date-time $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.ApiGetAgGridRowsResponse, Derivitec.Web.Core additionalProperties: false description: >- Paged report-result rows, their result-version timestamp, and final-row indicator. AgGridQuery: required: - $type type: object properties: start_row: type: integer description: >- Zero-based first requested row; defaults to 0. Druid time-series requests require 0. format: int32 example: 0 end_row: type: integer description: >- Exclusive upper row bound for the requested page; defaults to 50. For Druid history, this positive value caps the most recent returned points, subject to the server maximum. format: int32 example: 50 row_group_cols: type: array items: $ref: '#/components/schemas/AgGridColumn' description: Columns used to group the requested rows. nullable: true value_cols: type: array items: $ref: '#/components/schemas/AgGridColumn' description: >- Columns used as values in the requested rows. Druid history requires exactly one selected column; the server resolves necessary expression dependencies. nullable: true group_keys: type: array items: type: string description: Group keys that identify the requested group level. nullable: true filter_model: type: array items: $ref: '#/components/schemas/AgGridFilterBase' description: Client filters applied to the requested rows. nullable: true sort_model: type: array items: $ref: '#/components/schemas/AgGridSortModel' description: Client sort instructions applied to the requested rows. nullable: true is_time_series_request: type: boolean description: >- Whether a Druid query returns the selected value across recent report runs; defaults to false. History is bounded by the server lookback ending at the report load time and by server column, execution and response limits. Defaults are a 24-hour lookback and at most 1,000 points, further limited by EndRow. StartRow must be zero and ValueCols must contain exactly one column. Grid sorting is ignored; returned points are chronological. Filters and group keys remain active. Older runs outside the window are not returned. $type: type: string enum: - Derivitec.Web.Core.ReportQuery.AgGridQuery, Derivitec.Web.Core additionalProperties: false description: >- Client grid query for selecting, grouping, filtering, and sorting report rows. FilterBase: description: Base selection criterion for a named report-data field. discriminator: propertyName: $type mapping: Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core: '#/components/schemas/FilterMintlifyShape' Derivitec.Web.Core.Filters.FilterBase, Derivitec.Web.Core: '#/components/schemas/FilterBaseMintlifyShape' Derivitec.Web.Core.Filters.MultiFilter, Derivitec.Web.Core: '#/components/schemas/MultiFilter' Derivitec.Web.Core.Filters.StringFilter, Derivitec.Web.Core: '#/components/schemas/StringFilter' oneOf: - $ref: '#/components/schemas/FilterMintlifyShape' - $ref: '#/components/schemas/FilterBaseMintlifyShape' - $ref: '#/components/schemas/MultiFilter' - $ref: '#/components/schemas/StringFilter' AgGridColumn: required: - $type type: object properties: id: type: string description: Client column identifier used by the report-grid query. nullable: true display_name: type: string description: User-facing label for the report column or definition choice. nullable: true field: type: string description: Field name addressed by this grid-query item. nullable: true agg_func: type: string description: Aggregation function selected for this grid column. nullable: true $type: type: string enum: - Derivitec.Web.Core.ReportQuery.AgGridColumn, Derivitec.Web.Core additionalProperties: false description: Column reference in a client report-grid query. AgGridFilterBase: description: Common values for a client report-grid filter. discriminator: propertyName: $type mapping: Derivitec.Web.Core.ReportQuery.AgGridDateFilter, Derivitec.Web.Core: '#/components/schemas/AgGridDateFilter' Derivitec.Web.Core.ReportQuery.AgGridFilter, Derivitec.Web.Core: '#/components/schemas/AgGridFilterMintlifyShape' Derivitec.Web.Core.ReportQuery.AgGridFilterBase, Derivitec.Web.Core: '#/components/schemas/AgGridFilterBaseMintlifyShape' Derivitec.Web.Core.ReportQuery.AgGridInFilterInt, Derivitec.Web.Core: '#/components/schemas/AgGridInFilterInt' Derivitec.Web.Core.ReportQuery.AgGridInFilterPortfolioType, Derivitec.Web.Core: '#/components/schemas/AgGridInFilterPortfolioType' Derivitec.Web.Core.ReportQuery.AgGridInFilterString, Derivitec.Web.Core: '#/components/schemas/AgGridInFilterStringMintlifyShape' Derivitec.Web.Core.ReportQuery.AgGridInFilterStringList, Derivitec.Web.Core: '#/components/schemas/AgGridInFilterStringList' Derivitec.Web.Core.ReportQuery.AgGridIntNumberFilter, Derivitec.Web.Core: '#/components/schemas/AgGridIntNumberFilter' Derivitec.Web.Core.ReportQuery.AgGridMultiFilter, Derivitec.Web.Core: '#/components/schemas/AgGridMultiFilter' Derivitec.Web.Core.ReportQuery.AgGridNumberFilter, Derivitec.Web.Core: '#/components/schemas/AgGridNumberFilter' Derivitec.Web.Core.ReportQuery.AgGridPnlLookbackSetFilter, Derivitec.Web.Core: '#/components/schemas/AgGridPnlLookbackSetFilter' Derivitec.Web.Core.ReportQuery.AgGridPortfolioTypeFilter, Derivitec.Web.Core: '#/components/schemas/AgGridPortfolioTypeFilter' Derivitec.Web.Core.ReportQuery.AgGridReportStatusFilter, Derivitec.Web.Core: '#/components/schemas/AgGridReportStatusFilter' Derivitec.Web.Core.ReportQuery.AgGridSetFilter, Derivitec.Web.Core: '#/components/schemas/AgGridSetFilter' Derivitec.Web.Core.ReportQuery.AgGridStringFilter, Derivitec.Web.Core: '#/components/schemas/AgGridStringFilter' oneOf: - $ref: '#/components/schemas/AgGridDateFilter' - $ref: '#/components/schemas/AgGridFilterMintlifyShape' - $ref: '#/components/schemas/AgGridFilterBaseMintlifyShape' - $ref: '#/components/schemas/AgGridInFilterInt' - $ref: '#/components/schemas/AgGridInFilterPortfolioType' - $ref: '#/components/schemas/AgGridInFilterStringMintlifyShape' - $ref: '#/components/schemas/AgGridInFilterStringList' - $ref: '#/components/schemas/AgGridIntNumberFilter' - $ref: '#/components/schemas/AgGridMultiFilter' - $ref: '#/components/schemas/AgGridNumberFilter' - $ref: '#/components/schemas/AgGridPnlLookbackSetFilter' - $ref: '#/components/schemas/AgGridPortfolioTypeFilter' - $ref: '#/components/schemas/AgGridReportStatusFilter' - $ref: '#/components/schemas/AgGridSetFilter' - $ref: '#/components/schemas/AgGridStringFilter' AgGridSortModel: required: - $type type: object properties: col_id: type: string description: Column identifier addressed by this sort instruction. nullable: true sort: type: string description: Sort direction supplied for this column. nullable: true absolute_sorting: type: boolean description: Whether this sort instruction requests absolute sorting. $type: type: string enum: - Derivitec.Web.Core.ReportQuery.AgGridSortModel, Derivitec.Web.Core additionalProperties: false description: Sort instruction in a client report-grid query. FilterMintlifyShape: required: - $type type: object properties: field: type: string description: Name of the report-data field evaluated by this criterion. nullable: true type: type: string nullable: true $type: type: string enum: - Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core additionalProperties: false FilterBaseMintlifyShape: required: - $type type: object properties: field: type: string description: Name of the report-data field evaluated by this criterion. nullable: true $type: type: string enum: - Derivitec.Web.Core.Filters.FilterBase, Derivitec.Web.Core additionalProperties: false description: Base selection criterion for a named report-data field. MultiFilter: required: - $type type: object properties: field: type: string description: Name of the report-data field evaluated by this criterion. nullable: true operator: enum: - not_set - and - or type: string description: Logical rule used to combine the child criteria. conditions: type: array items: $ref: '#/components/schemas/FilterBase' description: >- Child criteria evaluated by the selected logical operator; nested groups are permitted. nullable: true $type: type: string enum: - Derivitec.Web.Core.Filters.MultiFilter, Derivitec.Web.Core additionalProperties: false description: >- Nested filter group that combines child criteria with a logical operator. StringFilter: required: - $type type: object properties: field: type: string description: Name of the report-data field evaluated by this criterion. nullable: true type: type: string nullable: true filter: type: string nullable: true $type: type: string enum: - Derivitec.Web.Core.Filters.StringFilter, Derivitec.Web.Core additionalProperties: false AgGridDateFilter: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true type: enum: - in_range - equals - not_equal - less_than - greater_than - blank - not_blank type: string description: Filter comparison or report-grid item type selected by the client. date_from: type: string description: Lower date bound for this date filter, when applicable. nullable: true date_to: type: string description: Upper date bound for this date filter, when applicable. nullable: true $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridDateFilter, Derivitec.Web.Core additionalProperties: false description: Date filter in a client report-grid query. AgGridFilterMintlifyShape: required: - $type type: object additionalProperties: false description: Base form of a client report-grid filter. properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true $type: type: string enum: - Derivitec.Web.Core.ReportQuery.AgGridFilter, Derivitec.Web.Core AgGridFilterBaseMintlifyShape: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridFilterBase, Derivitec.Web.Core additionalProperties: false description: Common values for a client report-grid filter. AgGridInFilterInt: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true values: type: array items: type: integer format: int32 nullable: true $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridInFilterInt, Derivitec.Web.Core additionalProperties: false AgGridInFilterPortfolioType: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true values: type: array items: enum: - derivitec - enfusion - orchestrade - liquidity_book - maia - fund_studio - not_set type: string description: >- Portfolio sources supported by public portfolio and trade-booking requests. nullable: true $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridInFilterPortfolioType, Derivitec.Web.Core additionalProperties: false AgGridInFilterStringMintlifyShape: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true values: type: array items: type: string nullable: true $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridInFilterString, Derivitec.Web.Core additionalProperties: false AgGridInFilterStringList: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true values: type: array items: type: string nullable: true type: enum: - not_populated - populated type: string operator: enum: - any - all type: string $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridInFilterStringList, Derivitec.Web.Core additionalProperties: false AgGridIntNumberFilter: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true filter: type: integer format: int32 filter_to: type: integer format: int32 type: enum: - equals - not_equal - less_than - less_than_or_equal - greater_than - greater_than_or_equal - in_range - blank - not_blank type: string $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridIntNumberFilter, Derivitec.Web.Core additionalProperties: false AgGridMultiFilter: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true operator: type: string nullable: true conditions: type: array items: $ref: '#/components/schemas/AgGridFilterBase' nullable: true $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridMultiFilter, Derivitec.Web.Core additionalProperties: false AgGridNumberFilter: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true filter: type: number format: double filter_to: type: number format: double type: enum: - equals - not_equal - less_than - less_than_or_equal - greater_than - greater_than_or_equal - in_range - blank - not_blank type: string double_precision: type: number format: double $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridNumberFilter, Derivitec.Web.Core additionalProperties: false AgGridPnlLookbackSetFilter: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true int_values: type: array items: enum: - daily - month_to_date - quarter_to_date - year_to_date - annual type: string nullable: true nullable: true $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridPnlLookbackSetFilter, Derivitec.Web.Core additionalProperties: false AgGridPortfolioTypeFilter: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true filter: enum: - derivitec - enfusion - orchestrade - liquidity_book - maia - fund_studio - not_set type: string description: >- Portfolio sources supported by public portfolio and trade-booking requests. filter_to: enum: - derivitec - enfusion - orchestrade - liquidity_book - maia - fund_studio - not_set type: string description: >- Portfolio sources supported by public portfolio and trade-booking requests. type: enum: - equals - not_equal - less_than - less_than_or_equal - greater_than - greater_than_or_equal - in_range - blank - not_blank type: string $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridPortfolioTypeFilter, Derivitec.Web.Core additionalProperties: false AgGridReportStatusFilter: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true filter: enum: - none - succeeded - failed - running - warning type: string description: Lifecycle states exposed for report runs and saved launcher items. filter_to: enum: - none - succeeded - failed - running - warning type: string description: Lifecycle states exposed for report runs and saved launcher items. type: enum: - equals - not_equal - less_than - less_than_or_equal - greater_than - greater_than_or_equal - in_range - blank - not_blank type: string $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridReportStatusFilter, Derivitec.Web.Core additionalProperties: false AgGridSetFilter: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true values: type: array items: type: string nullable: true $type: type: string enum: - Derivitec.Web.Core.ReportQuery.AgGridSetFilter, Derivitec.Web.Core additionalProperties: false AgGridStringFilter: required: - $type type: object properties: field: type: string description: Field name addressed by this grid-query item. nullable: true filter_type: type: string description: Filter category for this grid-query item. nullable: true filter: type: string nullable: true type: enum: - equals - not_equal - contains - not_contains - starts_with - ends_with - blank - not_blank type: string $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.AgGridStringFilter, Derivitec.Web.Core additionalProperties: false securitySchemes: oauth2: type: oauth2 description: >- OAuth2 access-token requested from AWS Cognito and provided as a Auth Bearer header flows: implicit: authorizationUrl: https://auth.riskportal.derivitec.com/oauth2/authorize scopes: {} apikey: type: apiKey description: API-Key requested via the site and provided as a header name: x-api-key in: header ````