> ## 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 from the latest eligible named report. > Selects the latest completed report available for the named report and portfolio within the authenticated caller's access, then returns the requested grid page. This is a read, not a report launch, and it does not accept a report-run identifier. Caller, organisation, time zone, internal report and portfolio identifiers, market-data context, and effective row restrictions are server-managed. ## OpenAPI ````yaml /risk-and-pricing/atoti-risk-services/apis-endpoints/openapi/openapi.mintlify.json post /api/ReportQueryViewUser/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/ReportQueryViewUser/GetRows: post: tags: - ReportQueryViewUser summary: Retrieve a page from the latest eligible named report. description: >- Selects the latest completed report available for the named report and portfolio within the authenticated caller's access, then returns the requested grid page. This is a read, not a report launch, and it does not accept a report-run identifier. Caller, organisation, time zone, internal report and portfolio identifiers, market-data context, and effective row restrictions are server-managed. operationId: GetRows requestBody: description: >- The body containing required accessible `ReportName` and `PortfolioName`; `GridQuery` with rows defaulting from `StartRow=0` through `EndRow=50` plus optional grouping, group keys, filters, sorting, and `IsTimeSeriesRequest`; optional `PortfolioType`, reporting currency, market-data environment names, and `PnlLookback`; and `LiveScheduledReport`, which defaults to `false`. content: application/json-patch+json: schema: $ref: '#/components/schemas/ApiGetLatestAgGridRowsRequest' application/json: schema: $ref: '#/components/schemas/ApiGetLatestAgGridRowsRequest' text/json: schema: $ref: '#/components/schemas/ApiGetLatestAgGridRowsRequest' application/*+json: schema: $ref: '#/components/schemas/ApiGetLatestAgGridRowsRequest' responses: '200': description: >- Returns the selected report rows, `LastRow`, and segment-loaded time, or an unsuccessful envelope when no eligible report or required row restriction is available. content: application/json: schema: $ref: '#/components/schemas/ApiGetAgGridRowsResponse' '400': description: BadRequest '401': description: Unauthorized '403': description: Forbidden security: - oauth2: [] - apikey: [] components: schemas: ApiGetLatestAgGridRowsRequest: required: - $type type: object properties: report_name: type: string description: >- Organisation-scoped name of the report definition to use. The value must not be null or empty. nullable: true example: Daily risk overview reporting_currency: type: string description: >- Currency in which report values are expressed. When null, the service uses the caller's configured reporting currency or USD. nullable: true example: USD market_data_environment_names: type: array items: type: string description: >- Names of market-data environments to use for the report. The list is empty by default. nullable: true portfolio_name: type: string description: >- Name of the portfolio to select. The value must not be null or empty. nullable: true example: Example portfolio 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 pnl_lookback: enum: - daily - month_to_date - quarter_to_date - year_to_date - annual type: string description: Optional predefined P&L lookback selection. nullable: true grid_query: $ref: '#/components/schemas/AgGridQuery' live_scheduled_report: type: boolean description: >- Whether the latest-row request addresses the exposed live scheduled-report mode. $type: type: string enum: - >- Derivitec.Web.Core.ReportQuery.ApiGetLatestAgGridRowsRequest, Derivitec.Web.Core additionalProperties: false description: >- Selectors for retrieving the latest available report-grid rows by report name. 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. 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. 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 ````