Retrieve paged VaR group tables.

curl --request POST \
  --url https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json-patch+json' \
  --data '
{
  "$type": "Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core",
  "confidence_level": 0.99,
  "row_query": {
    "$type": "Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core",
    "field": "<string>",
    "type": "<string>"
  },
  "row_restriction_filter": {
    "$type": "Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core",
    "field": "<string>",
    "type": "<string>"
  },
  "report_id": "<string>",
  "table_index": -1,
  "page": 1,
  "page_size": -1
}
'

import requests

url = "https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables"

payload = {
    "$type": "Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core",
    "confidence_level": 0.99,
    "row_query": {
        "$type": "Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core",
        "field": "<string>",
        "type": "<string>"
    },
    "row_restriction_filter": {
        "$type": "Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core",
        "field": "<string>",
        "type": "<string>"
    },
    "report_id": "<string>",
    "table_index": -1,
    "page": 1,
    "page_size": -1
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json-patch+json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json-patch+json'},
  body: JSON.stringify({
    $type: 'Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core',
    confidence_level: 0.99,
    row_query: {
      $type: 'Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core',
      field: '<string>',
      type: '<string>'
    },
    row_restriction_filter: {
      $type: 'Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core',
      field: '<string>',
      type: '<string>'
    },
    report_id: '<string>',
    table_index: -1,
    page: 1,
    page_size: -1
  })
};

fetch('https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    '$type' => 'Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core',
    'confidence_level' => 0.99,
    'row_query' => [
        '$type' => 'Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core',
        'field' => '<string>',
        'type' => '<string>'
    ],
    'row_restriction_filter' => [
        '$type' => 'Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core',
        'field' => '<string>',
        'type' => '<string>'
    ],
    'report_id' => '<string>',
    'table_index' => -1,
    'page' => 1,
    'page_size' => -1
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json-patch+json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables"

	payload := strings.NewReader("{\n  \"$type\": \"Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core\",\n  \"confidence_level\": 0.99,\n  \"row_query\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"row_restriction_filter\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"report_id\": \"<string>\",\n  \"table_index\": -1,\n  \"page\": 1,\n  \"page_size\": -1\n}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json-patch+json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json-patch+json")
  .body("{\n  \"$type\": \"Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core\",\n  \"confidence_level\": 0.99,\n  \"row_query\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"row_restriction_filter\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"report_id\": \"<string>\",\n  \"table_index\": -1,\n  \"page\": 1,\n  \"page_size\": -1\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json-patch+json'
request.body = "{\n  \"$type\": \"Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core\",\n  \"confidence_level\": 0.99,\n  \"row_query\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"row_restriction_filter\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"report_id\": \"<string>\",\n  \"table_index\": -1,\n  \"page\": 1,\n  \"page_size\": -1\n}"

response = http.request(request)
puts response.read_body

{
  "$type": "Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesResponse, Derivitec.Web.Core",
  "is_success": true,
  "error_messages": [
    "<string>"
  ],
  "price_histories_count": 123,
  "group_var_tables": [
    {
      "$type": "Derivitec.Web.Core.VarReportQuery.GroupVarTable, Derivitec.Web.Core",
      "data_table": "<unknown>",
      "table_definition": {
        "$type": "Derivitec.Web.Core.VarReportQuery.GroupVarTableDefinition, Derivitec.Web.Core",
        "columns": [
          {
            "$type": "Derivitec.Web.Core.VarReportQuery.VuetifyDataTableColumns, Derivitec.Web.Core",
            "value": "<string>",
            "title": "<string>",
            "multiplier": 1,
            "col_type": "<string>",
            "visible": true
          }
        ],
        "columns_scaled_by_aum": [
          "<string>"
        ],
        "group_by_properties": [
          "<string>"
        ],
        "sort_column": "<string>",
        "sort_direction": "ascending",
        "take_n": 123,
        "title": "<string>",
        "infinite_scroll": true
      },
      "last_row": 123,
      "page": 123,
      "page_size": 123
    }
  ]
}

POST

api

VarReportQuery

GroupVarTables

Retrieve paged VaR group tables.

curl --request POST \
  --url https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json-patch+json' \
  --data '
{
  "$type": "Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core",
  "confidence_level": 0.99,
  "row_query": {
    "$type": "Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core",
    "field": "<string>",
    "type": "<string>"
  },
  "row_restriction_filter": {
    "$type": "Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core",
    "field": "<string>",
    "type": "<string>"
  },
  "report_id": "<string>",
  "table_index": -1,
  "page": 1,
  "page_size": -1
}
'

import requests

url = "https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables"

payload = {
    "$type": "Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core",
    "confidence_level": 0.99,
    "row_query": {
        "$type": "Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core",
        "field": "<string>",
        "type": "<string>"
    },
    "row_restriction_filter": {
        "$type": "Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core",
        "field": "<string>",
        "type": "<string>"
    },
    "report_id": "<string>",
    "table_index": -1,
    "page": 1,
    "page_size": -1
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json-patch+json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json-patch+json'},
  body: JSON.stringify({
    $type: 'Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core',
    confidence_level: 0.99,
    row_query: {
      $type: 'Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core',
      field: '<string>',
      type: '<string>'
    },
    row_restriction_filter: {
      $type: 'Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core',
      field: '<string>',
      type: '<string>'
    },
    report_id: '<string>',
    table_index: -1,
    page: 1,
    page_size: -1
  })
};

fetch('https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    '$type' => 'Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core',
    'confidence_level' => 0.99,
    'row_query' => [
        '$type' => 'Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core',
        'field' => '<string>',
        'type' => '<string>'
    ],
    'row_restriction_filter' => [
        '$type' => 'Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core',
        'field' => '<string>',
        'type' => '<string>'
    ],
    'report_id' => '<string>',
    'table_index' => -1,
    'page' => 1,
    'page_size' => -1
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json-patch+json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables"

	payload := strings.NewReader("{\n  \"$type\": \"Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core\",\n  \"confidence_level\": 0.99,\n  \"row_query\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"row_restriction_filter\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"report_id\": \"<string>\",\n  \"table_index\": -1,\n  \"page\": 1,\n  \"page_size\": -1\n}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json-patch+json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json-patch+json")
  .body("{\n  \"$type\": \"Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core\",\n  \"confidence_level\": 0.99,\n  \"row_query\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"row_restriction_filter\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"report_id\": \"<string>\",\n  \"table_index\": -1,\n  \"page\": 1,\n  \"page_size\": -1\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.riskportal.activeviam.com/api/VarReportQuery/GroupVarTables")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json-patch+json'
request.body = "{\n  \"$type\": \"Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core\",\n  \"confidence_level\": 0.99,\n  \"row_query\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"row_restriction_filter\": {\n    \"$type\": \"Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core\",\n    \"field\": \"<string>\",\n    \"type\": \"<string>\"\n  },\n  \"report_id\": \"<string>\",\n  \"table_index\": -1,\n  \"page\": 1,\n  \"page_size\": -1\n}"

response = http.request(request)
puts response.read_body

{
  "$type": "Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesResponse, Derivitec.Web.Core",
  "is_success": true,
  "error_messages": [
    "<string>"
  ],
  "price_histories_count": 123,
  "group_var_tables": [
    {
      "$type": "Derivitec.Web.Core.VarReportQuery.GroupVarTable, Derivitec.Web.Core",
      "data_table": "<unknown>",
      "table_definition": {
        "$type": "Derivitec.Web.Core.VarReportQuery.GroupVarTableDefinition, Derivitec.Web.Core",
        "columns": [
          {
            "$type": "Derivitec.Web.Core.VarReportQuery.VuetifyDataTableColumns, Derivitec.Web.Core",
            "value": "<string>",
            "title": "<string>",
            "multiplier": 1,
            "col_type": "<string>",
            "visible": true
          }
        ],
        "columns_scaled_by_aum": [
          "<string>"
        ],
        "group_by_properties": [
          "<string>"
        ],
        "sort_column": "<string>",
        "sort_direction": "ascending",
        "take_n": 123,
        "title": "<string>",
        "infinite_scroll": true
      },
      "last_row": 123,
      "page": 123,
      "page_size": 123
    }
  ]
}

Authorizations

Authorization

string

header

required

OAuth2 access-token requested from AWS Cognito and provided as a Auth Bearer header

Body

The body containing the opaque ReportId, optional VaR selection fields, TableIndex (default -1), Page (default 1), and PageSize (default -1).

Requests paged group VaR tables for a report.

$type

enum<string>

required

Available options:

Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesRequest, Derivitec.Web.Core

confidence_level

number<double> | null

Optional VaR confidence-level override expressed as a decimal fraction; null retains the report's configured level.

Example:

0.99

row_query

object

Base selection criterion for a named report-data field.

Option 1
Option 2
Option 3
Option 4

Show child attributes

weighting_var_definition

object

Configuration used to select VaR weighting behaviour.

Show child attributes

row_restriction_filter

object

Base selection criterion for a named report-data field.

Option 1
Option 2
Option 3
Option 4

Show child attributes

full_report_filter

object

Nested filter group that combines child criteria with a logical operator.

Show child attributes

report_configuration

object

Optional named overrides used when querying or exporting a historical VaR report.

Show child attributes

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_index

integer<int32>

Zero-based configured table index to select; -1 requests all tables and is the default.

Example:

-1

page

integer<int32>

One-based page number to return; defaults to 1.

Example:

1

page_size

integer<int32>

Number of rows requested per table; -1 uses each table definition's take_n value and is the default.

Example:

-1

Response

Returns the selected page of one or all available VaR group tables.

Returns paged group VaR tables and their display definitions.

$type

enum<string>

required

Available options:

Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryGroupVarTablesResponse, 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.

price_histories_count

integer<int32>

Number of position price histories used to produce the query result.

group_var_tables

object[] | null

Selected group VaR tables with page metadata and display definitions.

Show child attributes

Introduction

Release and upgrades

User guide

Admin user guide

APIs Endpoints

Retrieve paged VaR group tables.

Authorizations

Body

Response