> ## 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. # Request an asynchronous report Excel export. > Accepts the export request and returns a `Requested` notification rather than a completed workbook. When `RequestId` is blank, a new opaque value is assigned. Acceptance does not promise delivery, idempotency, cancellation, completion time, or retention behavior. ## OpenAPI ````yaml /risk-and-pricing/atoti-risk-services/apis-endpoints/openapi/openapi.mintlify.json post /Export/Excel/CreateAsync 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: /Export/Excel/CreateAsync: post: tags: - Report summary: Request an asynchronous report Excel export. description: >- Accepts the export request and returns a `Requested` notification rather than a completed workbook. When `RequestId` is blank, a new opaque value is assigned. Acceptance does not promise delivery, idempotency, cancellation, completion time, or retention behavior. operationId: ExportToExcelAsync requestBody: description: >- The body containing the opaque `ReportId`, optional `PortfolioType`, `IncludePivotTable` (default `false`), optional `Prefilter`, `RequestId`, restriction and row-filter identifiers, and `ReportType`. content: application/json-patch+json: schema: $ref: '#/components/schemas/ApiExportReportAsExcelRequest' application/json: schema: $ref: '#/components/schemas/ApiExportReportAsExcelRequest' text/json: schema: $ref: '#/components/schemas/ApiExportReportAsExcelRequest' application/*+json: schema: $ref: '#/components/schemas/ApiExportReportAsExcelRequest' responses: '200': description: >- Returns a notification acknowledging that the report Excel export was requested. content: application/json: schema: $ref: '#/components/schemas/ApiExportReportAsExcelResponse' '400': description: BadRequest '401': description: Unauthorized '403': description: Forbidden security: - oauth2: [] - apikey: [] components: schemas: ApiExportReportAsExcelRequest: description: >- Report-run, format, and filter selections for requesting an Excel export. discriminator: propertyName: $type mapping: Derivitec.Web.Core.Reports.ApiExportReportAsExcelRequest, Derivitec.Web.Core: '#/components/schemas/ApiExportReportAsExcelRequestMintlifyShape' Derivitec.Web.Core.Reports.ApiExportHistoricalPnlReportAsExcelRequest, Derivitec.Web.Core: '#/components/schemas/ApiExportHistoricalPnlReportAsExcelRequest' oneOf: - $ref: '#/components/schemas/ApiExportReportAsExcelRequestMintlifyShape' - $ref: '#/components/schemas/ApiExportHistoricalPnlReportAsExcelRequest' ApiExportReportAsExcelResponse: required: - $type type: object additionalProperties: false description: Asynchronous acknowledgement for a requested report export. 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 notification: $ref: '#/components/schemas/Notification' $type: type: string enum: - >- Derivitec.Web.Core.Reports.ApiExportReportAsExcelResponse, Derivitec.Web.Core ApiExportReportAsExcelRequestMintlifyShape: required: - $type type: object properties: 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 include_pivot_table: type: boolean description: Whether the exported workbook should include the report pivot table. prefilter: $ref: '#/components/schemas/FilterBase' request_id: type: string description: >- Client-generated identifier for the export request; it is not a report-run identifier. nullable: true report_type: enum: - risk - var - pnl - time_series type: string description: >- Report category that selects the applicable result or metadata shape. legacy_view_state: $ref: '#/components/schemas/LegacyExportViewState' $type: type: string enum: - >- Derivitec.Web.Core.Reports.ApiExportReportAsExcelRequest, Derivitec.Web.Core additionalProperties: false description: >- Report-run, format, and filter selections for requesting an Excel export. ApiExportHistoricalPnlReportAsExcelRequest: required: - $type type: object properties: 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 include_pivot_table: type: boolean description: Whether the exported workbook should include the report pivot table. prefilter: $ref: '#/components/schemas/FilterBase' request_id: type: string description: >- Client-generated identifier for the export request; it is not a report-run identifier. nullable: true report_type: enum: - risk - var - pnl - time_series type: string description: >- Report category that selects the applicable result or metadata shape. legacy_view_state: $ref: '#/components/schemas/LegacyExportViewState' observation_date: type: string description: Observation date of the historical P&L report selected for export. format: date-time $type: type: string enum: - >- Derivitec.Web.Core.Reports.ApiExportHistoricalPnlReportAsExcelRequest, Derivitec.Web.Core additionalProperties: false description: >- Observation-date selection for exporting a historical P&L report to Excel. Notification: description: User-facing record of a request's notification lifecycle and read state. discriminator: propertyName: $type mapping: Derivitec.Web.Core.Notifications.ExportPivotToExcelNotification, Derivitec.Web.Core: '#/components/schemas/ExportPivotToExcelNotification' Derivitec.Web.Core.Notifications.ExportReportErrorsToExcelNotification, Derivitec.Web.Core: '#/components/schemas/ExportReportErrorsToExcelNotification' Derivitec.Web.Core.Notifications.ExportReportToExcelNotification, Derivitec.Web.Core: '#/components/schemas/ExportReportToExcelNotification' Derivitec.Web.Core.Notifications.Notification, Derivitec.Web.Core: '#/components/schemas/NotificationMintlifyShape' Derivitec.Web.Core.Notifications.VarReportQueryExportErrorsNotification, Derivitec.Web.Core: '#/components/schemas/VarReportQueryExportErrorsNotification' Derivitec.Web.Core.Notifications.VarReportQueryExportPnLSeriesToExcelNotification, Derivitec.Web.Core: >- #/components/schemas/VarReportQueryExportPnLSeriesToExcelNotification oneOf: - $ref: '#/components/schemas/ExportPivotToExcelNotification' - $ref: '#/components/schemas/ExportReportErrorsToExcelNotification' - $ref: '#/components/schemas/ExportReportToExcelNotification' - $ref: '#/components/schemas/NotificationMintlifyShape' - $ref: '#/components/schemas/VarReportQueryExportErrorsNotification' - $ref: >- #/components/schemas/VarReportQueryExportPnLSeriesToExcelNotification 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' LegacyExportViewState: required: - $type type: object properties: table_id: type: string description: Table whose state this is. nullable: true filters: type: array items: $ref: '#/components/schemas/LegacyTableFilterWire' description: Filter conditions. nullable: true sorts: type: array items: $ref: '#/components/schemas/LegacyTableSortWire' description: Ordered sort instructions. nullable: true active_pivot_keys: type: array items: type: string description: Pivot keys to activate, in order. nullable: true expanded_paths: type: array items: $ref: '#/components/schemas/LegacyTablePivotPathWire' description: Expanded pivot paths. nullable: true expansion_depth: type: integer description: Depth every node should be expanded to. format: int32 nullable: true $type: type: string enum: - >- Derivitec.Web.Core.LegacyReportQuery.LegacyExportViewState, Derivitec.Web.Core additionalProperties: false description: >- The grid state a current-view export must reproduce. Null means "export the default view". ExportPivotToExcelNotification: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true report_id: type: string nullable: true $type: type: string enum: - >- Derivitec.Web.Core.Notifications.ExportPivotToExcelNotification, Derivitec.Web.Core additionalProperties: false ExportReportErrorsToExcelNotification: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true report_id: type: string nullable: true $type: type: string enum: - >- Derivitec.Web.Core.Notifications.ExportReportErrorsToExcelNotification, Derivitec.Web.Core additionalProperties: false ExportReportToExcelNotification: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true report_id: type: string nullable: true $type: type: string enum: - >- Derivitec.Web.Core.Notifications.ExportReportToExcelNotification, Derivitec.Web.Core additionalProperties: false NotificationMintlifyShape: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true $type: type: string enum: - Derivitec.Web.Core.Notifications.Notification, Derivitec.Web.Core additionalProperties: false description: User-facing record of a request's notification lifecycle and read state. VarReportQueryExportErrorsNotification: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true report_id: type: string nullable: true $type: type: string enum: - >- Derivitec.Web.Core.Notifications.VarReportQueryExportErrorsNotification, Derivitec.Web.Core additionalProperties: false VarReportQueryExportPnLSeriesToExcelNotification: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true report_id: type: string nullable: true report_configuration: $ref: '#/components/schemas/VarReportConfiguration' $type: type: string enum: - >- Derivitec.Web.Core.Notifications.VarReportQueryExportPnLSeriesToExcelNotification, Derivitec.Web.Core additionalProperties: false 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 LegacyTableFilterWire: required: - $type type: object properties: column_key: type: string description: >- The key of the column to filter, as given by the table definition. A column the definition does not mark filterable is rejected rather than ignored. nullable: true operator: enum: - is_equal_to - is_not_equal_to - starts_with - ends_with - contains - is_greater_than - is_greater_than_or_equal_to - is_less_than - is_less_than_or_equal_to type: string description: >- The comparison to apply. An operator the column does not list as supported is rejected rather than ignored. value: type: string description: >- The value to compare against, formatted culture-invariantly: a round-trip ISO timestamp for a date column, and a plain decimal point for a numeric one. nullable: true $type: type: string enum: - >- Derivitec.Web.Core.LegacyReportQuery.LegacyTableFilterWire, Derivitec.Web.Core additionalProperties: false description: >- One filter condition on one column. The legacy grid allowed a single condition per column, and conditions across columns combine with AND. LegacyTableSortWire: required: - $type type: object properties: column_key: type: string description: >- The key of the column to sort by, as given by the table definition. A column the definition does not know is rejected rather than ignored. nullable: true descending: type: boolean description: >- Whether to sort descending rather than ascending. Sorting is by signed value; sorting by absolute value is not offered for this table. $type: type: string enum: - >- Derivitec.Web.Core.LegacyReportQuery.LegacyTableSortWire, Derivitec.Web.Core additionalProperties: false description: One sort instruction on one column. LegacyTablePivotPathWire: required: - $type type: object properties: path: type: array items: type: string description: >- The pivot values from the root down, one per level. Values are the displayed strings, which is what identifies a group: positional indexes shift whenever the sort or filter changes, so they are never exchanged. nullable: true $type: type: string enum: - >- Derivitec.Web.Core.LegacyReportQuery.LegacyTablePivotPathWire, Derivitec.Web.Core additionalProperties: false description: One expanded pivot path, as pivot value strings from the root down. VarReportConfiguration: required: - $type type: object properties: name: type: string description: Display name for this report-query or export configuration. nullable: true example: Default row_query: $ref: '#/components/schemas/FilterBase' confidence_level: type: number description: >- Optional VaR confidence-level override expressed as a decimal fraction; null retains the report's configured level. format: double nullable: true example: 0.99 weighting_var_definition: $ref: '#/components/schemas/WeightingVarDefinition' $type: type: string enum: - Derivitec.Web.Core.VarReportConfiguration, Derivitec.Web.Core additionalProperties: false description: >- Optional named overrides used when querying or exporting a historical VaR report. WeightingVarDefinition: required: - $type type: object properties: active: type: boolean description: Whether the VaR weighting configuration is enabled. window_length: type: integer description: Window-length value; no unit is established here. format: int32 decay_period: type: integer description: Decay-period value; no unit is established here. format: int32 scheme: enum: - exponentially_weighted - filtered_historical type: string description: Weighting scheme selected for the historical VaR configuration. $type: type: string enum: - >- Derivitec.Web.Core.Reports.WeightingVarDefinition, Derivitec.Web.Core additionalProperties: false description: Configuration used to select VaR weighting behaviour. 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 ````