--- title: "BDC Borrower Valuations List" url: "https://console.9fin.com/apis/bdc/versions/6a9605ac-8bcf-48e9-98dc-483d291112fd/operations/get_bdc_valuations" --- > Full API specification: https://console.9fin.com/apis/bdc/versions/6a9605ac-8bcf-48e9-98dc-483d291112fd.md # BDC Borrower Valuations List `GET` `/v0/bdc/valuations` Operation ID: `get_bdc_valuations` Returns a paginated list of borrower-level valuation summaries aggregated across BDC lenders. Each row represents one borrower for a given quarter, with consensus metrics computed over all BDCs holding the borrower — average fair value ratio (FVR), FVR delta from the prior quarter, standard deviation of FVRs, min/max FVR, total fair value, and count of BDCs holding. Use this to compare how BDCs collectively value the same borrower, or to track how a borrower's consensus valuation has shifted quarter-over-quarter. For row-level detail on individual holdings (specific instruments, terms, interest rates), use the BDC Holdings endpoints instead. ## Query parameters - `sort_by` (optional) - Comma-separated list of `field__asc` / `field__desc` tokens applied in order, e.g. `company_name__desc,price__asc`. Sortable fields: issuer_name, avg_fvr, avg_fvr_weighted, bdcs_holding, managers_holding, total_fair_value, total_fair_value_delta, fvr_delta, fvr_delta_weighted, fvr_standard_deviation, min_fvr, max_fvr, holding_quarter, non_accrual. - `limit` (optional) - Maximum number of rows to return. - `cursor` (optional) - Opaque keyset-pagination cursor from a prior page. - `bdc_name__eq` (optional) - Filter bdc_name where the value is equal to the given value. - `bdc_name__neq` (optional) - Filter bdc_name where the value is not equal to the given value. - `bdc_name__contains` (optional) - Filter bdc_name where the value contains the given value. - `bdc_name__in` (optional) - Filter bdc_name where the value is in the given list. - `bdc_name__isnull` (optional) - Filter bdc_name to rows where the value is NULL (true) or is not NULL (false). - `manager__eq` (optional) - Filter manager where the value is equal to the given value. - `manager__neq` (optional) - Filter manager where the value is not equal to the given value. - `manager__contains` (optional) - Filter manager where the value contains the given value. - `manager__in` (optional) - Filter manager where the value is in the given list. - `manager__isnull` (optional) - Filter manager to rows where the value is NULL (true) or is not NULL (false). - `seniority__eq` (optional) - Filter seniority where the value is equal to the given value. - `seniority__neq` (optional) - Filter seniority where the value is not equal to the given value. - `seniority__contains` (optional) - Filter seniority where the value contains the given value. - `seniority__in` (optional) - Filter seniority where the value is in the given list. - `seniority__isnull` (optional) - Filter seniority to rows where the value is NULL (true) or is not NULL (false). - `industries__contains` (optional) - Filter where the industries array contains this value. - `industries__isnull` (optional) - Filter industries to rows where the value is NULL (true) or is not NULL (false). - `issuer_name__eq` (optional) - Filter issuer_name where the value is equal to the given value. - `issuer_name__neq` (optional) - Filter issuer_name where the value is not equal to the given value. - `issuer_name__contains` (optional) - Filter issuer_name where the value contains the given value. - `issuer_name__in` (optional) - Filter issuer_name where the value is in the given list. - `issuer_name__isnull` (optional) - Filter issuer_name to rows where the value is NULL (true) or is not NULL (false). - `avg_fvr__eq` (optional) - Filter avg_fvr where the value is equal to the given value. - `avg_fvr__neq` (optional) - Filter avg_fvr where the value is not equal to the given value. - `avg_fvr__gt` (optional) - Filter avg_fvr where the value is greater than the given value. - `avg_fvr__gte` (optional) - Filter avg_fvr where the value is greater or equal to the given value. - `avg_fvr__lt` (optional) - Filter avg_fvr where the value is less than the given value. - `avg_fvr__lte` (optional) - Filter avg_fvr where the value is less or equal to the given value. - `avg_fvr__in` (optional) - Filter avg_fvr where the value is in the given list. - `avg_fvr__isnull` (optional) - Filter avg_fvr to rows where the value is NULL (true) or is not NULL (false). - `avg_fvr_weighted__eq` (optional) - Filter avg_fvr_weighted where the value is equal to the given value. - `avg_fvr_weighted__neq` (optional) - Filter avg_fvr_weighted where the value is not equal to the given value. - `avg_fvr_weighted__gt` (optional) - Filter avg_fvr_weighted where the value is greater than the given value. - `avg_fvr_weighted__gte` (optional) - Filter avg_fvr_weighted where the value is greater or equal to the given value. - `avg_fvr_weighted__lt` (optional) - Filter avg_fvr_weighted where the value is less than the given value. - `avg_fvr_weighted__lte` (optional) - Filter avg_fvr_weighted where the value is less or equal to the given value. - `avg_fvr_weighted__in` (optional) - Filter avg_fvr_weighted where the value is in the given list. - `avg_fvr_weighted__isnull` (optional) - Filter avg_fvr_weighted to rows where the value is NULL (true) or is not NULL (false). - `bdcs_holding__eq` (optional) - Filter bdcs_holding where the value is equal to the given value. - `bdcs_holding__neq` (optional) - Filter bdcs_holding where the value is not equal to the given value. - `bdcs_holding__gt` (optional) - Filter bdcs_holding where the value is greater than the given value. - `bdcs_holding__gte` (optional) - Filter bdcs_holding where the value is greater or equal to the given value. - `bdcs_holding__lt` (optional) - Filter bdcs_holding where the value is less than the given value. - `bdcs_holding__lte` (optional) - Filter bdcs_holding where the value is less or equal to the given value. - `bdcs_holding__in` (optional) - Filter bdcs_holding where the value is in the given list. - `bdcs_holding__isnull` (optional) - Filter bdcs_holding to rows where the value is NULL (true) or is not NULL (false). - `managers_holding__eq` (optional) - Filter managers_holding where the value is equal to the given value. - `managers_holding__neq` (optional) - Filter managers_holding where the value is not equal to the given value. - `managers_holding__gt` (optional) - Filter managers_holding where the value is greater than the given value. - `managers_holding__gte` (optional) - Filter managers_holding where the value is greater or equal to the given value. - `managers_holding__lt` (optional) - Filter managers_holding where the value is less than the given value. - `managers_holding__lte` (optional) - Filter managers_holding where the value is less or equal to the given value. - `managers_holding__in` (optional) - Filter managers_holding where the value is in the given list. - `managers_holding__isnull` (optional) - Filter managers_holding to rows where the value is NULL (true) or is not NULL (false). - `total_fair_value__eq` (optional) - Filter total_fair_value where the value is equal to the given value. - `total_fair_value__neq` (optional) - Filter total_fair_value where the value is not equal to the given value. - `total_fair_value__gt` (optional) - Filter total_fair_value where the value is greater than the given value. - `total_fair_value__gte` (optional) - Filter total_fair_value where the value is greater or equal to the given value. - `total_fair_value__lt` (optional) - Filter total_fair_value where the value is less than the given value. - `total_fair_value__lte` (optional) - Filter total_fair_value where the value is less or equal to the given value. - `total_fair_value__in` (optional) - Filter total_fair_value where the value is in the given list. - `total_fair_value__isnull` (optional) - Filter total_fair_value to rows where the value is NULL (true) or is not NULL (false). - `total_fair_value_delta__eq` (optional) - Filter total_fair_value_delta where the value is equal to the given value. - `total_fair_value_delta__neq` (optional) - Filter total_fair_value_delta where the value is not equal to the given value. - `total_fair_value_delta__gt` (optional) - Filter total_fair_value_delta where the value is greater than the given value. - `total_fair_value_delta__gte` (optional) - Filter total_fair_value_delta where the value is greater or equal to the given value. - `total_fair_value_delta__lt` (optional) - Filter total_fair_value_delta where the value is less than the given value. - `total_fair_value_delta__lte` (optional) - Filter total_fair_value_delta where the value is less or equal to the given value. - `total_fair_value_delta__in` (optional) - Filter total_fair_value_delta where the value is in the given list. - `total_fair_value_delta__isnull` (optional) - Filter total_fair_value_delta to rows where the value is NULL (true) or is not NULL (false). - `fvr_delta__eq` (optional) - Filter fvr_delta where the value is equal to the given value. - `fvr_delta__neq` (optional) - Filter fvr_delta where the value is not equal to the given value. - `fvr_delta__gt` (optional) - Filter fvr_delta where the value is greater than the given value. - `fvr_delta__gte` (optional) - Filter fvr_delta where the value is greater or equal to the given value. - `fvr_delta__lt` (optional) - Filter fvr_delta where the value is less than the given value. - `fvr_delta__lte` (optional) - Filter fvr_delta where the value is less or equal to the given value. - `fvr_delta__in` (optional) - Filter fvr_delta where the value is in the given list. - `fvr_delta__isnull` (optional) - Filter fvr_delta to rows where the value is NULL (true) or is not NULL (false). - `fvr_delta_weighted__eq` (optional) - Filter fvr_delta_weighted where the value is equal to the given value. - `fvr_delta_weighted__neq` (optional) - Filter fvr_delta_weighted where the value is not equal to the given value. - `fvr_delta_weighted__gt` (optional) - Filter fvr_delta_weighted where the value is greater than the given value. - `fvr_delta_weighted__gte` (optional) - Filter fvr_delta_weighted where the value is greater or equal to the given value. - `fvr_delta_weighted__lt` (optional) - Filter fvr_delta_weighted where the value is less than the given value. - `fvr_delta_weighted__lte` (optional) - Filter fvr_delta_weighted where the value is less or equal to the given value. - `fvr_delta_weighted__in` (optional) - Filter fvr_delta_weighted where the value is in the given list. - `fvr_delta_weighted__isnull` (optional) - Filter fvr_delta_weighted to rows where the value is NULL (true) or is not NULL (false). - `fvr_standard_deviation__eq` (optional) - Filter fvr_standard_deviation where the value is equal to the given value. - `fvr_standard_deviation__neq` (optional) - Filter fvr_standard_deviation where the value is not equal to the given value. - `fvr_standard_deviation__gt` (optional) - Filter fvr_standard_deviation where the value is greater than the given value. - `fvr_standard_deviation__gte` (optional) - Filter fvr_standard_deviation where the value is greater or equal to the given value. - `fvr_standard_deviation__lt` (optional) - Filter fvr_standard_deviation where the value is less than the given value. - `fvr_standard_deviation__lte` (optional) - Filter fvr_standard_deviation where the value is less or equal to the given value. - `fvr_standard_deviation__in` (optional) - Filter fvr_standard_deviation where the value is in the given list. - `fvr_standard_deviation__isnull` (optional) - Filter fvr_standard_deviation to rows where the value is NULL (true) or is not NULL (false). - `min_fvr__eq` (optional) - Filter min_fvr where the value is equal to the given value. - `min_fvr__neq` (optional) - Filter min_fvr where the value is not equal to the given value. - `min_fvr__gt` (optional) - Filter min_fvr where the value is greater than the given value. - `min_fvr__gte` (optional) - Filter min_fvr where the value is greater or equal to the given value. - `min_fvr__lt` (optional) - Filter min_fvr where the value is less than the given value. - `min_fvr__lte` (optional) - Filter min_fvr where the value is less or equal to the given value. - `min_fvr__in` (optional) - Filter min_fvr where the value is in the given list. - `min_fvr__isnull` (optional) - Filter min_fvr to rows where the value is NULL (true) or is not NULL (false). - `max_fvr__eq` (optional) - Filter max_fvr where the value is equal to the given value. - `max_fvr__neq` (optional) - Filter max_fvr where the value is not equal to the given value. - `max_fvr__gt` (optional) - Filter max_fvr where the value is greater than the given value. - `max_fvr__gte` (optional) - Filter max_fvr where the value is greater or equal to the given value. - `max_fvr__lt` (optional) - Filter max_fvr where the value is less than the given value. - `max_fvr__lte` (optional) - Filter max_fvr where the value is less or equal to the given value. - `max_fvr__in` (optional) - Filter max_fvr where the value is in the given list. - `max_fvr__isnull` (optional) - Filter max_fvr to rows where the value is NULL (true) or is not NULL (false). - `holding_quarter__eq` (optional) - Filter holding_quarter where the value is equal to the given value. - `holding_quarter__neq` (optional) - Filter holding_quarter where the value is not equal to the given value. - `holding_quarter__contains` (optional) - Filter holding_quarter where the value contains the given value. - `holding_quarter__in` (optional) - Filter holding_quarter where the value is in the given list. - `holding_quarter__isnull` (optional) - Filter holding_quarter to rows where the value is NULL (true) or is not NULL (false). - `non_accrual__eq` (optional) - Filter non_accrual where the value is equal to the given value. - `non_accrual__neq` (optional) - Filter non_accrual where the value is not equal to the given value. - `non_accrual__isnull` (optional) - Filter non_accrual to rows where the value is NULL (true) or is not NULL (false). ## Responses - `200` - Successful Response - `400` - Bad request (e.g. invalid cursor). - `422` - Validation Error - `500` - Unexpected server error. - `503` - Service unavailable (e.g. database down). ## OpenAPI definition ```yaml openapi: 3.1.0 info: title: 9Fin BDCs API version: 0.1.6 servers: - description: Production environment url: https://api.9fin.com paths: /v0/bdc/valuations: get: description: >- Returns a paginated list of borrower-level valuation summaries aggregated across BDC lenders. Each row represents one borrower for a given quarter, with consensus metrics computed over all BDCs holding the borrower — average fair value ratio (FVR), FVR delta from the prior quarter, standard deviation of FVRs, min/max FVR, total fair value, and count of BDCs holding. Use this to compare how BDCs collectively value the same borrower, or to track how a borrower's consensus valuation has shifted quarter-over-quarter. For row-level detail on individual holdings (specific instruments, terms, interest rates), use the BDC Holdings endpoints instead. operationId: get_bdc_valuations parameters: - description: "Comma-separated list of `field__asc` / `field__desc` tokens applied in order, e.g. `company_name__desc,price__asc`. Sortable fields: issuer_name, avg_fvr, avg_fvr_weighted, bdcs_holding, managers_holding, total_fair_value, total_fair_value_delta, fvr_delta, fvr_delta_weighted, fvr_standard_deviation, min_fvr, max_fvr, holding_quarter, non_accrual." in: query name: sort_by required: false schema: anyOf: - type: string - type: "null" default: null description: "Comma-separated list of `field__asc` / `field__desc` tokens applied in order, e.g. `company_name__desc,price__asc`. Sortable fields: issuer_name, avg_fvr, avg_fvr_weighted, bdcs_holding, managers_holding, total_fair_value, total_fair_value_delta, fvr_delta, fvr_delta_weighted, fvr_standard_deviation, min_fvr, max_fvr, holding_quarter, non_accrual." title: Sort By - description: Maximum number of rows to return. in: query name: limit required: false schema: anyOf: - maximum: 100 minimum: 1 type: integer - type: "null" default: 20 description: Maximum number of rows to return. title: Limit - description: Opaque keyset-pagination cursor from a prior page. in: query name: cursor required: false schema: anyOf: - type: string - type: "null" default: null description: Opaque keyset-pagination cursor from a prior page. title: Cursor - description: Filter bdc_name where the value is equal to the given value. in: query name: bdc_name__eq required: false schema: anyOf: - type: string - type: "null" default: null description: Filter bdc_name where the value is equal to the given value. title: Bdc Name Eq - description: Filter bdc_name where the value is not equal to the given value. in: query name: bdc_name__neq required: false schema: anyOf: - type: string - type: "null" default: null description: Filter bdc_name where the value is not equal to the given value. title: Bdc Name Neq - description: Filter bdc_name where the value contains the given value. in: query name: bdc_name__contains required: false schema: anyOf: - type: string - type: "null" default: null description: Filter bdc_name where the value contains the given value. title: Bdc Name Contains - description: Filter bdc_name where the value is in the given list. in: query name: bdc_name__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter bdc_name where the value is in the given list. title: Bdc Name In - description: Filter bdc_name to rows where the value is NULL (true) or is not NULL (false). in: query name: bdc_name__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter bdc_name to rows where the value is NULL (true) or is not NULL (false). title: Bdc Name Isnull - description: Filter manager where the value is equal to the given value. in: query name: manager__eq required: false schema: anyOf: - type: string - type: "null" default: null description: Filter manager where the value is equal to the given value. title: Manager Eq - description: Filter manager where the value is not equal to the given value. in: query name: manager__neq required: false schema: anyOf: - type: string - type: "null" default: null description: Filter manager where the value is not equal to the given value. title: Manager Neq - description: Filter manager where the value contains the given value. in: query name: manager__contains required: false schema: anyOf: - type: string - type: "null" default: null description: Filter manager where the value contains the given value. title: Manager Contains - description: Filter manager where the value is in the given list. in: query name: manager__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter manager where the value is in the given list. title: Manager In - description: Filter manager to rows where the value is NULL (true) or is not NULL (false). in: query name: manager__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter manager to rows where the value is NULL (true) or is not NULL (false). title: Manager Isnull - description: Filter seniority where the value is equal to the given value. in: query name: seniority__eq required: false schema: anyOf: - type: string - type: "null" default: null description: Filter seniority where the value is equal to the given value. title: Seniority Eq - description: Filter seniority where the value is not equal to the given value. in: query name: seniority__neq required: false schema: anyOf: - type: string - type: "null" default: null description: Filter seniority where the value is not equal to the given value. title: Seniority Neq - description: Filter seniority where the value contains the given value. in: query name: seniority__contains required: false schema: anyOf: - type: string - type: "null" default: null description: Filter seniority where the value contains the given value. title: Seniority Contains - description: Filter seniority where the value is in the given list. in: query name: seniority__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter seniority where the value is in the given list. title: Seniority In - description: Filter seniority to rows where the value is NULL (true) or is not NULL (false). in: query name: seniority__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter seniority to rows where the value is NULL (true) or is not NULL (false). title: Seniority Isnull - description: Filter where the industries array contains this value. in: query name: industries__contains required: false schema: anyOf: - type: string - type: "null" default: null description: Filter where the industries array contains this value. title: Industries Contains - description: Filter industries to rows where the value is NULL (true) or is not NULL (false). in: query name: industries__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter industries to rows where the value is NULL (true) or is not NULL (false). title: Industries Isnull - description: Filter issuer_name where the value is equal to the given value. in: query name: issuer_name__eq required: false schema: anyOf: - type: string - type: "null" default: null description: Filter issuer_name where the value is equal to the given value. title: Issuer Name Eq - description: Filter issuer_name where the value is not equal to the given value. in: query name: issuer_name__neq required: false schema: anyOf: - type: string - type: "null" default: null description: Filter issuer_name where the value is not equal to the given value. title: Issuer Name Neq - description: Filter issuer_name where the value contains the given value. in: query name: issuer_name__contains required: false schema: anyOf: - type: string - type: "null" default: null description: Filter issuer_name where the value contains the given value. title: Issuer Name Contains - description: Filter issuer_name where the value is in the given list. in: query name: issuer_name__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter issuer_name where the value is in the given list. title: Issuer Name In - description: Filter issuer_name to rows where the value is NULL (true) or is not NULL (false). in: query name: issuer_name__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter issuer_name to rows where the value is NULL (true) or is not NULL (false). title: Issuer Name Isnull - description: Filter avg_fvr where the value is equal to the given value. in: query name: avg_fvr__eq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr where the value is equal to the given value. title: Avg Fvr Eq - description: Filter avg_fvr where the value is not equal to the given value. in: query name: avg_fvr__neq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr where the value is not equal to the given value. title: Avg Fvr Neq - description: Filter avg_fvr where the value is greater than the given value. in: query name: avg_fvr__gt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr where the value is greater than the given value. title: Avg Fvr Gt - description: Filter avg_fvr where the value is greater or equal to the given value. in: query name: avg_fvr__gte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr where the value is greater or equal to the given value. title: Avg Fvr Gte - description: Filter avg_fvr where the value is less than the given value. in: query name: avg_fvr__lt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr where the value is less than the given value. title: Avg Fvr Lt - description: Filter avg_fvr where the value is less or equal to the given value. in: query name: avg_fvr__lte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr where the value is less or equal to the given value. title: Avg Fvr Lte - description: Filter avg_fvr where the value is in the given list. in: query name: avg_fvr__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter avg_fvr where the value is in the given list. title: Avg Fvr In - description: Filter avg_fvr to rows where the value is NULL (true) or is not NULL (false). in: query name: avg_fvr__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter avg_fvr to rows where the value is NULL (true) or is not NULL (false). title: Avg Fvr Isnull - description: Filter avg_fvr_weighted where the value is equal to the given value. in: query name: avg_fvr_weighted__eq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr_weighted where the value is equal to the given value. title: Avg Fvr Weighted Eq - description: Filter avg_fvr_weighted where the value is not equal to the given value. in: query name: avg_fvr_weighted__neq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr_weighted where the value is not equal to the given value. title: Avg Fvr Weighted Neq - description: Filter avg_fvr_weighted where the value is greater than the given value. in: query name: avg_fvr_weighted__gt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr_weighted where the value is greater than the given value. title: Avg Fvr Weighted Gt - description: Filter avg_fvr_weighted where the value is greater or equal to the given value. in: query name: avg_fvr_weighted__gte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr_weighted where the value is greater or equal to the given value. title: Avg Fvr Weighted Gte - description: Filter avg_fvr_weighted where the value is less than the given value. in: query name: avg_fvr_weighted__lt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr_weighted where the value is less than the given value. title: Avg Fvr Weighted Lt - description: Filter avg_fvr_weighted where the value is less or equal to the given value. in: query name: avg_fvr_weighted__lte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter avg_fvr_weighted where the value is less or equal to the given value. title: Avg Fvr Weighted Lte - description: Filter avg_fvr_weighted where the value is in the given list. in: query name: avg_fvr_weighted__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter avg_fvr_weighted where the value is in the given list. title: Avg Fvr Weighted In - description: Filter avg_fvr_weighted to rows where the value is NULL (true) or is not NULL (false). in: query name: avg_fvr_weighted__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter avg_fvr_weighted to rows where the value is NULL (true) or is not NULL (false). title: Avg Fvr Weighted Isnull - description: Filter bdcs_holding where the value is equal to the given value. in: query name: bdcs_holding__eq required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter bdcs_holding where the value is equal to the given value. title: Bdcs Holding Eq - description: Filter bdcs_holding where the value is not equal to the given value. in: query name: bdcs_holding__neq required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter bdcs_holding where the value is not equal to the given value. title: Bdcs Holding Neq - description: Filter bdcs_holding where the value is greater than the given value. in: query name: bdcs_holding__gt required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter bdcs_holding where the value is greater than the given value. title: Bdcs Holding Gt - description: Filter bdcs_holding where the value is greater or equal to the given value. in: query name: bdcs_holding__gte required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter bdcs_holding where the value is greater or equal to the given value. title: Bdcs Holding Gte - description: Filter bdcs_holding where the value is less than the given value. in: query name: bdcs_holding__lt required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter bdcs_holding where the value is less than the given value. title: Bdcs Holding Lt - description: Filter bdcs_holding where the value is less or equal to the given value. in: query name: bdcs_holding__lte required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter bdcs_holding where the value is less or equal to the given value. title: Bdcs Holding Lte - description: Filter bdcs_holding where the value is in the given list. in: query name: bdcs_holding__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter bdcs_holding where the value is in the given list. title: Bdcs Holding In - description: Filter bdcs_holding to rows where the value is NULL (true) or is not NULL (false). in: query name: bdcs_holding__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter bdcs_holding to rows where the value is NULL (true) or is not NULL (false). title: Bdcs Holding Isnull - description: Filter managers_holding where the value is equal to the given value. in: query name: managers_holding__eq required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter managers_holding where the value is equal to the given value. title: Managers Holding Eq - description: Filter managers_holding where the value is not equal to the given value. in: query name: managers_holding__neq required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter managers_holding where the value is not equal to the given value. title: Managers Holding Neq - description: Filter managers_holding where the value is greater than the given value. in: query name: managers_holding__gt required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter managers_holding where the value is greater than the given value. title: Managers Holding Gt - description: Filter managers_holding where the value is greater or equal to the given value. in: query name: managers_holding__gte required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter managers_holding where the value is greater or equal to the given value. title: Managers Holding Gte - description: Filter managers_holding where the value is less than the given value. in: query name: managers_holding__lt required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter managers_holding where the value is less than the given value. title: Managers Holding Lt - description: Filter managers_holding where the value is less or equal to the given value. in: query name: managers_holding__lte required: false schema: anyOf: - type: integer - type: "null" default: null description: Filter managers_holding where the value is less or equal to the given value. title: Managers Holding Lte - description: Filter managers_holding where the value is in the given list. in: query name: managers_holding__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter managers_holding where the value is in the given list. title: Managers Holding In - description: Filter managers_holding to rows where the value is NULL (true) or is not NULL (false). in: query name: managers_holding__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter managers_holding to rows where the value is NULL (true) or is not NULL (false). title: Managers Holding Isnull - description: Filter total_fair_value where the value is equal to the given value. in: query name: total_fair_value__eq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value where the value is equal to the given value. title: Total Fair Value Eq - description: Filter total_fair_value where the value is not equal to the given value. in: query name: total_fair_value__neq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value where the value is not equal to the given value. title: Total Fair Value Neq - description: Filter total_fair_value where the value is greater than the given value. in: query name: total_fair_value__gt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value where the value is greater than the given value. title: Total Fair Value Gt - description: Filter total_fair_value where the value is greater or equal to the given value. in: query name: total_fair_value__gte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value where the value is greater or equal to the given value. title: Total Fair Value Gte - description: Filter total_fair_value where the value is less than the given value. in: query name: total_fair_value__lt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value where the value is less than the given value. title: Total Fair Value Lt - description: Filter total_fair_value where the value is less or equal to the given value. in: query name: total_fair_value__lte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value where the value is less or equal to the given value. title: Total Fair Value Lte - description: Filter total_fair_value where the value is in the given list. in: query name: total_fair_value__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter total_fair_value where the value is in the given list. title: Total Fair Value In - description: Filter total_fair_value to rows where the value is NULL (true) or is not NULL (false). in: query name: total_fair_value__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter total_fair_value to rows where the value is NULL (true) or is not NULL (false). title: Total Fair Value Isnull - description: Filter total_fair_value_delta where the value is equal to the given value. in: query name: total_fair_value_delta__eq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value_delta where the value is equal to the given value. title: Total Fair Value Delta Eq - description: Filter total_fair_value_delta where the value is not equal to the given value. in: query name: total_fair_value_delta__neq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value_delta where the value is not equal to the given value. title: Total Fair Value Delta Neq - description: Filter total_fair_value_delta where the value is greater than the given value. in: query name: total_fair_value_delta__gt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value_delta where the value is greater than the given value. title: Total Fair Value Delta Gt - description: Filter total_fair_value_delta where the value is greater or equal to the given value. in: query name: total_fair_value_delta__gte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value_delta where the value is greater or equal to the given value. title: Total Fair Value Delta Gte - description: Filter total_fair_value_delta where the value is less than the given value. in: query name: total_fair_value_delta__lt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value_delta where the value is less than the given value. title: Total Fair Value Delta Lt - description: Filter total_fair_value_delta where the value is less or equal to the given value. in: query name: total_fair_value_delta__lte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter total_fair_value_delta where the value is less or equal to the given value. title: Total Fair Value Delta Lte - description: Filter total_fair_value_delta where the value is in the given list. in: query name: total_fair_value_delta__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter total_fair_value_delta where the value is in the given list. title: Total Fair Value Delta In - description: Filter total_fair_value_delta to rows where the value is NULL (true) or is not NULL (false). in: query name: total_fair_value_delta__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter total_fair_value_delta to rows where the value is NULL (true) or is not NULL (false). title: Total Fair Value Delta Isnull - description: Filter fvr_delta where the value is equal to the given value. in: query name: fvr_delta__eq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta where the value is equal to the given value. title: Fvr Delta Eq - description: Filter fvr_delta where the value is not equal to the given value. in: query name: fvr_delta__neq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta where the value is not equal to the given value. title: Fvr Delta Neq - description: Filter fvr_delta where the value is greater than the given value. in: query name: fvr_delta__gt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta where the value is greater than the given value. title: Fvr Delta Gt - description: Filter fvr_delta where the value is greater or equal to the given value. in: query name: fvr_delta__gte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta where the value is greater or equal to the given value. title: Fvr Delta Gte - description: Filter fvr_delta where the value is less than the given value. in: query name: fvr_delta__lt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta where the value is less than the given value. title: Fvr Delta Lt - description: Filter fvr_delta where the value is less or equal to the given value. in: query name: fvr_delta__lte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta where the value is less or equal to the given value. title: Fvr Delta Lte - description: Filter fvr_delta where the value is in the given list. in: query name: fvr_delta__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter fvr_delta where the value is in the given list. title: Fvr Delta In - description: Filter fvr_delta to rows where the value is NULL (true) or is not NULL (false). in: query name: fvr_delta__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter fvr_delta to rows where the value is NULL (true) or is not NULL (false). title: Fvr Delta Isnull - description: Filter fvr_delta_weighted where the value is equal to the given value. in: query name: fvr_delta_weighted__eq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta_weighted where the value is equal to the given value. title: Fvr Delta Weighted Eq - description: Filter fvr_delta_weighted where the value is not equal to the given value. in: query name: fvr_delta_weighted__neq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta_weighted where the value is not equal to the given value. title: Fvr Delta Weighted Neq - description: Filter fvr_delta_weighted where the value is greater than the given value. in: query name: fvr_delta_weighted__gt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta_weighted where the value is greater than the given value. title: Fvr Delta Weighted Gt - description: Filter fvr_delta_weighted where the value is greater or equal to the given value. in: query name: fvr_delta_weighted__gte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta_weighted where the value is greater or equal to the given value. title: Fvr Delta Weighted Gte - description: Filter fvr_delta_weighted where the value is less than the given value. in: query name: fvr_delta_weighted__lt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta_weighted where the value is less than the given value. title: Fvr Delta Weighted Lt - description: Filter fvr_delta_weighted where the value is less or equal to the given value. in: query name: fvr_delta_weighted__lte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_delta_weighted where the value is less or equal to the given value. title: Fvr Delta Weighted Lte - description: Filter fvr_delta_weighted where the value is in the given list. in: query name: fvr_delta_weighted__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter fvr_delta_weighted where the value is in the given list. title: Fvr Delta Weighted In - description: Filter fvr_delta_weighted to rows where the value is NULL (true) or is not NULL (false). in: query name: fvr_delta_weighted__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter fvr_delta_weighted to rows where the value is NULL (true) or is not NULL (false). title: Fvr Delta Weighted Isnull - description: Filter fvr_standard_deviation where the value is equal to the given value. in: query name: fvr_standard_deviation__eq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_standard_deviation where the value is equal to the given value. title: Fvr Standard Deviation Eq - description: Filter fvr_standard_deviation where the value is not equal to the given value. in: query name: fvr_standard_deviation__neq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_standard_deviation where the value is not equal to the given value. title: Fvr Standard Deviation Neq - description: Filter fvr_standard_deviation where the value is greater than the given value. in: query name: fvr_standard_deviation__gt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_standard_deviation where the value is greater than the given value. title: Fvr Standard Deviation Gt - description: Filter fvr_standard_deviation where the value is greater or equal to the given value. in: query name: fvr_standard_deviation__gte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_standard_deviation where the value is greater or equal to the given value. title: Fvr Standard Deviation Gte - description: Filter fvr_standard_deviation where the value is less than the given value. in: query name: fvr_standard_deviation__lt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_standard_deviation where the value is less than the given value. title: Fvr Standard Deviation Lt - description: Filter fvr_standard_deviation where the value is less or equal to the given value. in: query name: fvr_standard_deviation__lte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter fvr_standard_deviation where the value is less or equal to the given value. title: Fvr Standard Deviation Lte - description: Filter fvr_standard_deviation where the value is in the given list. in: query name: fvr_standard_deviation__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter fvr_standard_deviation where the value is in the given list. title: Fvr Standard Deviation In - description: Filter fvr_standard_deviation to rows where the value is NULL (true) or is not NULL (false). in: query name: fvr_standard_deviation__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter fvr_standard_deviation to rows where the value is NULL (true) or is not NULL (false). title: Fvr Standard Deviation Isnull - description: Filter min_fvr where the value is equal to the given value. in: query name: min_fvr__eq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter min_fvr where the value is equal to the given value. title: Min Fvr Eq - description: Filter min_fvr where the value is not equal to the given value. in: query name: min_fvr__neq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter min_fvr where the value is not equal to the given value. title: Min Fvr Neq - description: Filter min_fvr where the value is greater than the given value. in: query name: min_fvr__gt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter min_fvr where the value is greater than the given value. title: Min Fvr Gt - description: Filter min_fvr where the value is greater or equal to the given value. in: query name: min_fvr__gte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter min_fvr where the value is greater or equal to the given value. title: Min Fvr Gte - description: Filter min_fvr where the value is less than the given value. in: query name: min_fvr__lt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter min_fvr where the value is less than the given value. title: Min Fvr Lt - description: Filter min_fvr where the value is less or equal to the given value. in: query name: min_fvr__lte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter min_fvr where the value is less or equal to the given value. title: Min Fvr Lte - description: Filter min_fvr where the value is in the given list. in: query name: min_fvr__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter min_fvr where the value is in the given list. title: Min Fvr In - description: Filter min_fvr to rows where the value is NULL (true) or is not NULL (false). in: query name: min_fvr__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter min_fvr to rows where the value is NULL (true) or is not NULL (false). title: Min Fvr Isnull - description: Filter max_fvr where the value is equal to the given value. in: query name: max_fvr__eq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter max_fvr where the value is equal to the given value. title: Max Fvr Eq - description: Filter max_fvr where the value is not equal to the given value. in: query name: max_fvr__neq required: false schema: anyOf: - type: number - type: "null" default: null description: Filter max_fvr where the value is not equal to the given value. title: Max Fvr Neq - description: Filter max_fvr where the value is greater than the given value. in: query name: max_fvr__gt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter max_fvr where the value is greater than the given value. title: Max Fvr Gt - description: Filter max_fvr where the value is greater or equal to the given value. in: query name: max_fvr__gte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter max_fvr where the value is greater or equal to the given value. title: Max Fvr Gte - description: Filter max_fvr where the value is less than the given value. in: query name: max_fvr__lt required: false schema: anyOf: - type: number - type: "null" default: null description: Filter max_fvr where the value is less than the given value. title: Max Fvr Lt - description: Filter max_fvr where the value is less or equal to the given value. in: query name: max_fvr__lte required: false schema: anyOf: - type: number - type: "null" default: null description: Filter max_fvr where the value is less or equal to the given value. title: Max Fvr Lte - description: Filter max_fvr where the value is in the given list. in: query name: max_fvr__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter max_fvr where the value is in the given list. title: Max Fvr In - description: Filter max_fvr to rows where the value is NULL (true) or is not NULL (false). in: query name: max_fvr__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter max_fvr to rows where the value is NULL (true) or is not NULL (false). title: Max Fvr Isnull - description: Filter holding_quarter where the value is equal to the given value. in: query name: holding_quarter__eq required: false schema: anyOf: - type: string - type: "null" default: null description: Filter holding_quarter where the value is equal to the given value. title: Holding Quarter Eq - description: Filter holding_quarter where the value is not equal to the given value. in: query name: holding_quarter__neq required: false schema: anyOf: - type: string - type: "null" default: null description: Filter holding_quarter where the value is not equal to the given value. title: Holding Quarter Neq - description: Filter holding_quarter where the value contains the given value. in: query name: holding_quarter__contains required: false schema: anyOf: - type: string - type: "null" default: null description: Filter holding_quarter where the value contains the given value. title: Holding Quarter Contains - description: Filter holding_quarter where the value is in the given list. in: query name: holding_quarter__in required: false schema: anyOf: - type: string - type: "null" default: null description: Filter holding_quarter where the value is in the given list. title: Holding Quarter In - description: Filter holding_quarter to rows where the value is NULL (true) or is not NULL (false). in: query name: holding_quarter__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter holding_quarter to rows where the value is NULL (true) or is not NULL (false). title: Holding Quarter Isnull - description: Filter non_accrual where the value is equal to the given value. in: query name: non_accrual__eq required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter non_accrual where the value is equal to the given value. title: Non Accrual Eq - description: Filter non_accrual where the value is not equal to the given value. in: query name: non_accrual__neq required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter non_accrual where the value is not equal to the given value. title: Non Accrual Neq - description: Filter non_accrual to rows where the value is NULL (true) or is not NULL (false). in: query name: non_accrual__isnull required: false schema: anyOf: - type: boolean - type: "null" default: null description: Filter non_accrual to rows where the value is NULL (true) or is not NULL (false). title: Non Accrual Isnull responses: "200": content: application/json: schema: $ref: "#/components/schemas/BDCValuationsResponse" description: Successful Response "400": content: application/json: schema: $ref: "#/components/schemas/ErrorResponse" description: Bad request (e.g. invalid cursor). "422": content: application/json: schema: $ref: "#/components/schemas/HTTPValidationError" description: Validation Error "500": content: application/json: schema: $ref: "#/components/schemas/InternalServerErrorResponse" description: Unexpected server error. "503": content: application/json: schema: $ref: "#/components/schemas/ErrorResponse" description: Service unavailable (e.g. database down). security: - HTTPBearer: [] summary: BDC Borrower Valuations List tags: - BDC Valuations security: - HTTPBearer: [] components: schemas: BDCValuationsResponse: properties: items: description: Instruments the fit the provided filter criteria. items: $ref: "#/components/schemas/BDCBorrower" title: Items type: array next_cursor: anyOf: - type: string - type: "null" description: Cursor to pass in the next request to fetch the next page of instruments title: Next Cursor total_count: description: Total count of all items the match the provided filter criteria. title: Total Count type: integer required: - items - next_cursor - total_count title: BDCValuationsResponse type: object ErrorResponse: description: Client-facing error envelope. examples: - error_code: invalid_cursor message: The supplied cursor could not be decoded. trace_id: 202bde256c7d446f9623efdc96286c5d - error_code: service_unavailable message: Database is not available trace_id: c2416d52c6d14c8e831aad792407442c properties: error_code: title: Error Code type: string message: title: Message type: string trace_id: anyOf: - type: string - type: "null" title: Trace Id required: - error_code - message title: ErrorResponse type: object HTTPValidationError: properties: detail: items: $ref: "#/components/schemas/ValidationError" title: Detail type: array title: HTTPValidationError type: object InternalServerErrorResponse: properties: error_code: examples: - internal_server_error title: Error Code type: string message: examples: - An unexpected error occurred. title: Message type: string trace_id: anyOf: - type: string - type: "null" examples: - e7dfd20231374d308f04655eb0538be4 title: Trace Id required: - error_code - message - trace_id title: InternalServerErrorResponse type: object BDCBorrower: properties: avg_fvr: anyOf: - type: number - type: "null" title: Avg Fvr avg_fvr_weighted: anyOf: - type: number - type: "null" title: Avg Fvr Weighted bdcs_holding: title: Bdcs Holding type: integer end_quarter: anyOf: - format: date type: string - type: "null" title: End Quarter fvr_delta: anyOf: - type: number - type: "null" title: Fvr Delta fvr_delta_weighted: anyOf: - type: number - type: "null" title: Fvr Delta Weighted fvr_standard_deviation: anyOf: - type: number - type: "null" title: Fvr Standard Deviation holding_quarter: anyOf: - type: string - type: "null" title: Holding Quarter inaccurate: anyOf: - type: boolean - type: "null" title: Inaccurate industries: anyOf: - items: type: string type: array - type: "null" title: Industries is_european: anyOf: - type: boolean - type: "null" title: Is European is_new_borrower: anyOf: - type: boolean - type: "null" title: Is New Borrower is_pik: anyOf: - type: boolean - type: "null" title: Is Pik issuer_name: title: Issuer Name type: string lower_quarter: anyOf: - type: number - type: "null" title: Lower Quarter managers_holding: title: Managers Holding type: integer max_fvr: anyOf: - type: number - type: "null" title: Max Fvr min_fvr: anyOf: - type: number - type: "null" title: Min Fvr next_maturing: anyOf: - format: date type: string - type: "null" title: Next Maturing non_accrual: anyOf: - type: boolean - type: "null" title: Non Accrual total_fair_value: anyOf: - type: number - type: "null" title: Total Fair Value total_fair_value_delta: anyOf: - type: number - type: "null" title: Total Fair Value Delta upper_quarter: anyOf: - type: number - type: "null" title: Upper Quarter required: - issuer_name - bdcs_holding - managers_holding title: BDCBorrower type: object ValidationError: properties: ctx: title: Context type: object input: title: Input loc: items: anyOf: - type: string - type: integer title: Location type: array msg: title: Message type: string type: title: Error Type type: string required: - loc - msg - type title: ValidationError type: object securitySchemes: HTTPBearer: bearerFormat: JWT scheme: bearer type: http ```